[Home] [Help]
26: g_asg_comments varchar2(150);
27: g_sec_asg_flag number :=0;
28: --$ To upload supervisor id
29: g_supervisor_user_key varchar2(240);
30: --$ To Upload Benefit Group Name in HR Pump Batch Lines
31: g_benefit_grp_name varchar2(100);
32: --$ Get upload mode - "Create and Update" (C) or "Update Only" (U)
33: -- or "View/Download Only" (D)
34: g_crt_upd varchar2 (1):= 'D'; -- By default 'Download only'
6901: -- added to the maximum value of Link_Value for that batch_id
6902: --
6903: cursor csr_get_link_value (c_batch_id number) is
6904: select Max(link_value) + 1
6905: from hr_pump_batch_lines
6906: where batch_id = c_batch_id;
6907:
6908: l_proc_name constant varchar2(150):= g_pkg ||'DataPump_API_Call';
6909: l_person_user_key varchar2(240);
6985:
6986: --$ Update Batch Entry in case Corrections are to be made for a record
6987: if p_batch_link is not null then
6988: --Delete old records in batch lines for this batch id and link value
6989: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6987: if p_batch_link is not null then
6988: --Delete old records in batch lines for this batch id and link value
6989: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6994: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
6995: and link_value = p_batch_link );
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6994: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
6995: and link_value = p_batch_link );
6996:
6997: delete from hr_pump_batch_lines where batch_id = p_batch_id and
6998: link_value = p_batch_link;
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6994: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
6995: and link_value = p_batch_link );
6996:
6997: delete from hr_pump_batch_lines where batch_id = p_batch_id and
6998: link_value = p_batch_link;
6999: --Now, use same link value to insert the corrected record and hence
7000: --new batch lines
7001: l_link_value := p_batch_link;
7355: from hr_api_modules
7356: where module_name = 'CREATE_EMPLOYEE'
7357: and module_package = 'HR_EMPLOYEE_API'
7358: and api_module_id in (select api_module_id
7359: from hr_pump_batch_lines
7360: where batch_id = c_batch_id
7361: and link_value = c_link_value);
7362:
7363: -- Cursor to get all the api_ids which have LINE_STATUS in status 'E' or 'U'
7363: -- Cursor to get all the api_ids which have LINE_STATUS in status 'E' or 'U'
7364: cursor csr_get_api_names (c_batch_id in number
7365: ,c_link_value in number) is
7366: select module_name
7367: from hr_pump_batch_lines hpbl
7368: ,hr_api_modules ham
7369: where batch_id = c_batch_id
7370: and link_value = c_link_value
7371: and line_status in ('U', 'E')
7480: begin
7481: hr_utility.set_location('Entering: ' || l_proc_name, 10);
7482:
7483: -- Check if operation being corrected was insert or update because of
7484: -- duplicate person id based on the API_MODULE_ID in hr_pump_batch_lines
7485: -- and then set dp_mode flag respectively
7486:
7487: open csr_get_dp_mode (c_batch_id => p_batch_id
7488: ,c_link_value => p_data_pump_batch_line_id
7523: -- NOTE : We will be calling the same "INSERT_BATCH_LINES" for updation
7524: -- as internally "INSERT_BATCH_LINES" deletes the previous entry
7525: -- for corresponding Batch_line_Id and makes a fresh entry.
7526: -- Hence, in the cursor we will temporarily store some of the data
7527: -- which we will require in newly created entry in HR_PUMP_BATCH_LINES
7528:
7529:
7530: loop
7531: