DBA Data[Home] [Help]

APPS.PAY_NO_TC_DP_UPLOAD dependencies on HR_PUMP_UTILS

Line 212: l_batch_id := hr_pump_utils.create_batch_header

208: l_file_type :=
209: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
210:
211: -- Create the Batch header
212: l_batch_id := hr_pump_utils.create_batch_header
213: (p_batch_name => p_batch_name,
214: p_business_group_name => l_bg_name,
215: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
216:

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

388: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
389: -- Add user key only if it does not exist previously
390:
391: IF csr_get_user_key%NOTFOUND THEN
392: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
393: hr_utility.set_location ( ' User Key added ' , 190);
394: ELSE
395: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
396: hr_utility.set_location ( ' User Key modified ' , 190.1);

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

391: IF csr_get_user_key%NOTFOUND THEN
392: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
393: hr_utility.set_location ( ' User Key added ' , 190);
394: ELSE
395: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
396: hr_utility.set_location ( ' User Key modified ' , 190.1);
397: END IF;
398: CLOSE csr_get_user_key;
399:

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

482: OPEN csr_get_user_key(L_ASSIGNMENT_USER_KEY);
483: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
484: -- Add user key only if it does not exist previously
485: IF csr_get_user_key%NOTFOUND THEN
486: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,l_assignment_id);
487: END IF;
488: CLOSE csr_get_user_key;
489:
490: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);

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

490: OPEN csr_get_user_key(L_ELEMENT_LINK_USER_KEY);
491: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
492: -- Add user key only if it does not exist previously
493: IF csr_get_user_key%NOTFOUND THEN
494: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);
495: END IF;
496: CLOSE csr_get_user_key;
497:
498: