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 394: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);

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

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

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

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

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

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

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