APPS.PAY_DK_TC_DP_UPLOAD dependencies on HR_PUMP_UTILS

Line 321: l_batch_id := hr_pump_utils.create_batch_header

317: l_file_type :=
318: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
319: -- Create the Batch header
320:
321: l_batch_id := hr_pump_utils.create_batch_header
322: (p_batch_name => p_batch_name,
323: p_business_group_name => l_bg_name,
324: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
325:

Line 569: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);

565: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
566: -- Add user key only if it does not exist previously
567:
568: IF csr_get_user_key%NOTFOUND THEN
569: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
570: hr_utility.set_location ( ' User Key added ' , 190);
571: ELSE
572: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
573: hr_utility.set_location ( ' User Key modified ' , 190.1);

Line 572: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);

568: IF csr_get_user_key%NOTFOUND THEN
569: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
570: hr_utility.set_location ( ' User Key added ' , 190);
571: ELSE
572: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
573: hr_utility.set_location ( ' User Key modified ' , 190.1);
574: END IF;
575:
576: CLOSE csr_get_user_key;

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

658: OPEN csr_get_user_key(L_ASSIGNMENT_USER_KEY);
659: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
660: -- Add user key only if it does not exist previously
661: IF csr_get_user_key%NOTFOUND THEN
662: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,l_assignment_id);
663: END IF;
664: CLOSE csr_get_user_key;
665:
666: --fnd_file.put_line(fnd_file.LOG,'debug else3 ');

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

667: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);
668: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
669: -- Add user key only if it does not exist previously
670: IF csr_get_user_key%NOTFOUND THEN
671: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);
672: END IF;
673: CLOSE csr_get_user_key;
674:
675: --fnd_file.put_line(fnd_file.LOG,'debug else4 ');