DBA Data[Home] [Help]

APPS.IGS_AD_WF_P2A dependencies on IGS_SS_ADM_APPL_STG

Line 94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;

90: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
91: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
92: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

Line 95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;

91: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
92: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

Line 96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;

92: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

Line 97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;

93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:

Line 98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:
102:

Line 99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:
102:
103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;

Line 100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
98: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:
102:
103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
104: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;

Line 371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;

367: l_gen_attribute_17 VARCHAR2(1);
368: l_gen_attribute_18 VARCHAR2(1);
369: l_gen_attribute_19 VARCHAR2(1);
370: l_gen_attribute_20 VARCHAR2(1);
371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

Line 372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;

368: l_gen_attribute_18 VARCHAR2(1);
369: l_gen_attribute_19 VARCHAR2(1);
370: l_gen_attribute_20 VARCHAR2(1);
371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

Line 373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;

369: l_gen_attribute_19 VARCHAR2(1);
370: l_gen_attribute_20 VARCHAR2(1);
371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

Line 374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;

370: l_gen_attribute_20 VARCHAR2(1);
371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:

Line 375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

371: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:
379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

Line 376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

372: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:
379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
380:

Line 377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

373: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
374: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;
375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:
379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
380:
381: cl_appl_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

Line 379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

375: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
376: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:
379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
380:
381: cl_appl_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
382: l_result VARCHAR2(30);
383: l_appl_type_uhk_prl c_appl_type_uhk_prl%ROWTYPE;