APPS.PAY_FI_TC_DP_UPLOAD dependencies on HR_PUMP_UTILS

Line 282: l_batch_id := hr_pump_utils.create_batch_header

278: l_file_type :=
279: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
280:
281: -- Create the Batch header
282: l_batch_id := hr_pump_utils.create_batch_header
283: (p_batch_name => p_batch_name,
284: p_business_group_name => l_bg_name,
285: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
286:

Line 418: hr_pump_utils.add_user_key(l_tc_ee_user_key,l_element_entry_id);

414: OPEN csr_get_user_key(l_tc_ee_user_key);
415: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
416: -- Add user key only if it does not exist previously
417: IF csr_get_user_key%NOTFOUND THEN
418: hr_pump_utils.add_user_key(l_tc_ee_user_key,l_element_entry_id);
419: ELSE
420:
421: hr_pump_utils.modify_user_key(l_tc_ee_user_key,l_tc_ee_user_key,l_element_entry_id);
422:

Line 421: hr_pump_utils.modify_user_key(l_tc_ee_user_key,l_tc_ee_user_key,l_element_entry_id);

417: IF csr_get_user_key%NOTFOUND THEN
418: hr_pump_utils.add_user_key(l_tc_ee_user_key,l_element_entry_id);
419: ELSE
420:
421: hr_pump_utils.modify_user_key(l_tc_ee_user_key,l_tc_ee_user_key,l_element_entry_id);
422:
423: END IF;
424: CLOSE csr_get_user_key;
425:

Line 512: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,l_assignment_id);

508: OPEN csr_get_user_key(L_ASSIGNMENT_USER_KEY);
509: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
510: -- Add user key only if it does not exist previously
511: IF csr_get_user_key%NOTFOUND THEN
512: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,l_assignment_id);
513: END IF;
514: CLOSE csr_get_user_key;
515:
516: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);

Line 520: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);

516: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);
517: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
518: -- Add user key only if it does not exist previously
519: IF csr_get_user_key%NOTFOUND THEN
520: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);
521: END IF;
522: CLOSE csr_get_user_key;
523:
524: hrdpp_create_element_entry.insert_batch_lines

Line 658: hr_pump_utils.add_user_key(l_t_ee_user_key,l_element_entry_id);

654: OPEN csr_get_user_key(l_t_ee_user_key);
655: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
656: -- Add user key only if it does not exist previously
657: IF csr_get_user_key%NOTFOUND THEN
658: hr_pump_utils.add_user_key(l_t_ee_user_key,l_element_entry_id);
659: END IF;
660: CLOSE csr_get_user_key;
661:
662: hr_utility.set_location ( ' User Key added ' , 210);