Sunday, December 25, 2022
In this post, we have given the sample script to retire an API in R12. API: FA_RETIREMENT_PUB.DO_RETIREMENT Test Instance: R12.1.3 Script: SET SERVEROUTPUT ON;
DECLARE
le_api_error EXCEPTION;
-- Asset to be retired
lv_asset_number VARCHAR2(100) DEFAULT '43296';
lv_book_type_code VARCHAR2(15) DEFAULT 'CORP';
ln_asset_id NUMBER;
ln_user_id NUMBER := 12345;
ln_cost_retired NUMBER;
ln_proceeds_of_sale NUMBER := 0;
ln_cost_of_removal NUMBER := 0;
...
Sunday, December 25, 2022 1
Thursday, November 17, 2022
In this post, we have given a small script to convert BINARY data to BASE64 encoded data. Before seeing the script, lets have a quick background, Background: We have some binary data that we want to send across a network. Let's assume, we send them as bits and bytes over the network in a raw format. Possibility 1: Few combinations of Binary data may be considered as control characters by the...
Thursday, November 17, 2022 0
Saturday, November 12, 2022
API to terminate Employee in Oracle Apps R12 (HR_EX_EMPLOYEE_API.ACTUAL_TERMINATION_EMP, HR_EX_EMPLOYEE_API.UPDATE_TERM_DETAILS_EMP, HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP )
In this post we have given a script to end date an employee. Below three API's are used. API:HR_EX_EMPLOYEE_API.ACTUAL_TERMINATION_EMPHR_EX_EMPLOYEE_API.UPDATE_TERM_DETAILS_EMPHR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP TEST Instance: R12.1.3Script:SET SERVEROUTPUT ON;
DECLARE
l_obj NUMBER;
l_period_of_service_id...
Saturday, November 12, 2022 0
Subscribe to:
Posts (Atom)