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.

[Home] [Help]

APPS.PAY_DK_TC_DP_UPLOAD dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 54: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

50: -- Parameter values to create Batch Lines
51: l_ee_user_key VARCHAR2(240);
52: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
53: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
54: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
55: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
56: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
57: l_datetrack_update_mode VARCHAR2(80);
58:

Line 55: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

51: l_ee_user_key VARCHAR2(240);
52: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
53: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
54: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
55: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
56: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
57: l_datetrack_update_mode VARCHAR2(80);
58:
59: -- Variables to Read from File

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

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

Line 167: FROM hr_pump_batch_line_user_keys

163:
164: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
165: IS
166: SELECT user_key_value, unique_key_id
167: FROM hr_pump_batch_line_user_keys
168: WHERE user_key_value = p_user_key_value;
169:
170: CURSOR csr_get_legal_employer(v_bg_id per_business_groups.business_group_id%TYPE)
171: IS

Line 652: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

648: FETCH csr_get_user_key INTO l_user_key_value,l_unique_key_id;
649: --DELETE the key
650: IF csr_get_user_key%FOUND THEN
651: begin
652: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
653: end;
654: END IF;
655: CLOSE csr_get_user_key;
656: