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_PROCESS_DEPENDENT

Line 140: INSERT INTO hrdpv_process_dependent (

136: ,P_DATE_OF_BIRTH VARCHAR2
137: ,P_PERSON_NUM VARCHAR2
138: ) is
139: begin
140: INSERT INTO hrdpv_process_dependent (
141: BATCH_ID
142: ,BATCH_LINE_ID
143: ,API_MODULE_ID
144: ,LINE_STATUS

Line 477: from hrdpv_process_dependent ch

473: ) is
474: --
475: cursor c_choices is
476: select ch.*
477: from hrdpv_process_dependent ch
478: where ch.batch_id = p_batch_id
479: and ch.line_status <> 'C'
480: order by p_person_num,
481: p_employee_number,

Line 494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;

490: p_option_num,
491: p_record_typ_cd
492: for update;
493: --
494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;

Line 495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;

491: p_record_typ_cd
492: for update;
493: --
494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;

Line 496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;

492: for update;
493: --
494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;

Line 497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;

493: --
494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;

Line 498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;

494: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;

Line 499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;

495: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;

Line 500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;

496: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;

Line 501: l_program hrdpv_process_dependent.p_program%TYPE;

497: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;

Line 502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;

498: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
506: --

Line 503: l_plan hrdpv_process_dependent.p_plan%TYPE;

499: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
506: --
507: l_person_change boolean := true;

Line 504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;

500: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
506: --
507: l_person_change boolean := true;
508: --

Line 505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;

501: l_program hrdpv_process_dependent.p_program%TYPE;
502: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
503: l_plan hrdpv_process_dependent.p_plan%TYPE;
504: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
505: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
506: --
507: l_person_change boolean := true;
508: --
509: l_prev_rec c_choices%ROWTYPE;

Line 511: l_prev_link hrdpv_process_dependent.link_value%TYPE ;

507: l_person_change boolean := true;
508: --
509: l_prev_rec c_choices%ROWTYPE;
510: l_curr_rec c_choices%ROWTYPE;
511: l_prev_link hrdpv_process_dependent.link_value%TYPE ;
512: --
513: begin
514: --
515: /* IMPORTANT to enforce the following assumptions. Otherwise we need to enhance our

Line 541: UPDATE hrdpv_process_dependent

537: (which => fnd_file.log,
538: buff => 'Updated Header for ATOMIC_LINKED_CALLS');
539: --
540: --
541: UPDATE hrdpv_process_dependent
542: SET P_RECORD_TYP_CD = 'ENROLL'
543: WHERE batch_id = p_batch_id;
544: --
545: --

Line 727: update hrdpv_process_dependent

723: --
724: l_sequence := l_sequence + 1;
725: --
726: */
727: update hrdpv_process_dependent
728: set p_record_typ_cd = 'POST'
729: where batch_id = p_batch_id
730: and batch_line_id = l_prev_rec.batch_line_id;
731: --

Line 735: update hrdpv_process_dependent

731: --
732: END IF;
733: --UPDATE STATEMENT
734: --
735: update hrdpv_process_dependent
736: set user_sequence = l_sequence ,
737: link_value = l_link_value
738: where batch_id = p_batch_id
739: and batch_line_id = i.batch_line_id ;

Line 800: update hrdpv_process_dependent

796: ,P_DATE_OF_BIRTH => l_prev_rec.P_DATE_OF_BIRTH
797: ,P_PERSON_NUM => l_prev_rec.P_PERSON_NUM
798: );
799: */
800: update hrdpv_process_dependent
801: set p_record_typ_cd = 'POST'
802: where batch_id = p_batch_id
803: and batch_line_id = l_prev_rec.batch_line_id;
804: --

Line 841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;

837: p_option_num,
838: p_record_typ_cd
839: for update;
840: --
841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;

Line 842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;

838: p_record_typ_cd
839: for update;
840: --
841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;

Line 843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;

839: for update;
840: --
841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;

Line 844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;

840: --
841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;

Line 845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;

841: l_link_value hrdpv_process_dependent.link_value%TYPE := 0 ;
842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;

Line 846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;

842: l_sequence hrdpv_process_dependent.user_sequence%TYPE := 1 ;
843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;

Line 847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;

843: l_person_num hrdpv_process_dependent.p_person_num%TYPE;
844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;

Line 848: l_program hrdpv_process_dependent.p_program%TYPE;

844: l_emp_num hrdpv_process_dependent.p_employee_number%TYPE;
845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;

Line 849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;

845: l_ssn hrdpv_process_dependent.p_national_identifier%TYPE;
846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
853: --

Line 850: l_plan hrdpv_process_dependent.p_plan%TYPE;

846: l_full_name hrdpv_process_dependent.p_full_name%TYPE;
847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
853: --
854: l_person_change boolean := true;

Line 851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;

847: l_dob hrdpv_process_dependent.p_date_of_birth%TYPE;
848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
853: --
854: l_person_change boolean := true;
855: --

Line 852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;

848: l_program hrdpv_process_dependent.p_program%TYPE;
849: l_program_num hrdpv_process_dependent.p_program_num%TYPE;
850: l_plan hrdpv_process_dependent.p_plan%TYPE;
851: l_plan_num hrdpv_process_dependent.p_plan_num%TYPE;
852: l_record_typ hrdpv_process_dependent.p_record_typ_cd%TYPE ;
853: --
854: l_person_change boolean := true;
855: --
856: l_prev_rec c_choices%ROWTYPE;

Line 858: l_prev_link hrdpv_process_dependent.link_value%TYPE ;

854: l_person_change boolean := true;
855: --
856: l_prev_rec c_choices%ROWTYPE;
857: l_curr_rec c_choices%ROWTYPE;
858: l_prev_link hrdpv_process_dependent.link_value%TYPE ;
859: --
860: begin
861: --
862: /* IMPORTANT to enforce the following assumptions. Otherwise we need to enhance our