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_NO_TC_DP_UPLOAD dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 64: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

60: -- Parameter values to create Batch Lines
61: l_ee_user_key VARCHAR2(240);
62: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
63: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
64: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
65: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
66: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
67: l_datetrack_update_mode VARCHAR2(80);
68:

Line 65: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

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

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

162: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
163: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
164: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
165:
166: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
167: IS
168: SELECT user_key_value, unique_key_id
169: FROM hr_pump_batch_line_user_keys
170: WHERE user_key_value = p_user_key_value;

Line 169: FROM hr_pump_batch_line_user_keys

165:
166: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
167: IS
168: SELECT user_key_value, unique_key_id
169: FROM hr_pump_batch_line_user_keys
170: WHERE user_key_value = p_user_key_value;
171:
172:
173:

Line 477: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

473: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
474: --DELETE the key
475: IF csr_get_user_key%FOUND THEN
476: begin
477: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
478: end;
479: END IF;
480: CLOSE csr_get_user_key;
481: