eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_TC_DP_UPLOAD dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 62: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

58: l_tc_ee_user_key VARCHAR2(240);
59: l_t_ee_user_key VARCHAR2(240);
60: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
61: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
62: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
63: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
65: l_datetrack_update_mode VARCHAR2(80);
66:

Line 63: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

59: l_t_ee_user_key VARCHAR2(240);
60: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
61: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
62: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
63: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
65: l_datetrack_update_mode VARCHAR2(80);
66:
67: -- Variables to Read from File

Line 241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)

237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
240:
241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
242: IS
243: SELECT user_key_value, unique_key_id
244: FROM hr_pump_batch_line_user_keys
245: WHERE user_key_value = p_user_key_value;

Line 244: FROM hr_pump_batch_line_user_keys

240:
241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
242: IS
243: SELECT user_key_value, unique_key_id
244: FROM hr_pump_batch_line_user_keys
245: WHERE user_key_value = p_user_key_value;
246:
247:
248:

Line 501: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

497: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
498: --DELETE the key
499:
500: IF csr_get_user_key%FOUND THEN
501: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
502: END IF;
503: CLOSE csr_get_user_key;
504: /* deletion code for user key*/
505: