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.BEN_PRE_DATAPUMP_PROCESS dependencies on HRDPV_CREATE_ENROLLMENT

Line 70: INSERT INTO hrdpv_create_enrollment (

66: ,P_DATE_OF_BIRTH VARCHAR2
67: ,P_PERSON_NUM VARCHAR2
68: ) is
69: begin
70: INSERT INTO hrdpv_create_enrollment (
71: BATCH_ID
72: ,BATCH_LINE_ID
73: ,API_MODULE_ID
74: ,LINE_STATUS

Line 196: from hrdpv_create_enrollment ch

192: ) is
193: --
194: cursor c_choices is
195: select ch.*
196: from hrdpv_create_enrollment ch
197: where ch.batch_id = p_batch_id
198: and ch.line_status <> 'C'
199: order by p_person_num,
200: p_employee_number,

Line 211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;

207: p_plan_num,
208: p_record_typ_cd
209: for update;
210: --
211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;
212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;

Line 212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;

208: p_record_typ_cd
209: for update;
210: --
211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;
212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;

Line 213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;

209: for update;
210: --
211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;
212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;

Line 214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;

210: --
211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;
212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;

Line 215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;

211: l_link_value hrdpv_create_enrollment.link_value%TYPE := 0 ;
212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;

Line 216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;

212: l_sequence hrdpv_create_enrollment.user_sequence%TYPE := 1 ;
213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;

Line 217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;

213: l_person_num hrdpv_create_enrollment.p_person_num%TYPE;
214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;

Line 218: l_program hrdpv_create_enrollment.p_program%TYPE;

214: l_emp_num hrdpv_create_enrollment.p_employee_number%TYPE;
215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;
222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;

Line 219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;

215: l_ssn hrdpv_create_enrollment.p_national_identifier%TYPE;
216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;
222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;
223:

Line 220: l_plan hrdpv_create_enrollment.p_plan%TYPE;

216: l_full_name hrdpv_create_enrollment.p_full_name%TYPE;
217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;
222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;
223:
224: l_person_change boolean := true;

Line 221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;

217: l_dob hrdpv_create_enrollment.p_date_of_birth%TYPE;
218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;
222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;
223:
224: l_person_change boolean := true;
225: --

Line 222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;

218: l_program hrdpv_create_enrollment.p_program%TYPE;
219: l_program_num hrdpv_create_enrollment.p_program_num%TYPE;
220: l_plan hrdpv_create_enrollment.p_plan%TYPE;
221: l_plan_num hrdpv_create_enrollment.p_plan_num%TYPE;
222: l_record_typ hrdpv_create_enrollment.p_record_typ_cd%TYPE ;
223:
224: l_person_change boolean := true;
225: --
226: l_prev_rec c_choices%ROWTYPE;

Line 228: l_prev_link hrdpv_create_enrollment.link_value%TYPE ;

224: l_person_change boolean := true;
225: --
226: l_prev_rec c_choices%ROWTYPE;
227: l_curr_rec c_choices%ROWTYPE;
228: l_prev_link hrdpv_create_enrollment.link_value%TYPE ;
229: --
230: begin
231: --
232: /* IMPORTANT to enforce the following assumptions. Otherwise we need to enhance our

Line 254: UPDATE hrdpv_create_enrollment

250: SET bh.ATOMIC_LINKED_CALLS = 'Y'
251: WHERE bh.batch_id = p_batch_id ;
252: --
253: --
254: UPDATE hrdpv_create_enrollment
255: SET P_RECORD_TYP_CD = 'ENROLL'
256: WHERE batch_id = p_batch_id;
257: --
258: --

Line 388: update hrdpv_create_enrollment

384: --
385: l_sequence := l_sequence + 1;
386: --
387: */
388: update hrdpv_create_enrollment
389: set p_record_typ_cd = 'POST'
390: where batch_id = p_batch_id
391: and batch_line_id = l_prev_rec.batch_line_id;
392: --

Line 396: update hrdpv_create_enrollment

392: --
393: END IF;
394: --UPDATE STATEMENT
395: --
396: update hrdpv_create_enrollment
397: set user_sequence = l_sequence ,
398: link_value = l_link_value
399: where batch_id = p_batch_id
400: and batch_line_id = i.batch_line_id ;

Line 457: update hrdpv_create_enrollment

453: ,P_DATE_OF_BIRTH => l_prev_rec.P_DATE_OF_BIRTH
454: ,P_PERSON_NUM => l_prev_rec.P_PERSON_NUM
455: );
456: */
457: update hrdpv_create_enrollment
458: set p_record_typ_cd = 'POST'
459: where batch_id = p_batch_id
460: and batch_line_id = l_prev_rec.batch_line_id;
461: --