DBA Data[Home] [Help]

APPS.IGS_AD_WF_P2A dependencies on IGS_CA_INST_ALL

Line 84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

80: FROM sys.dual;
81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

Line 85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;

81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;

Line 86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
90: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;

Line 87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;

83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%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;

Line 309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

305: FROM dual;
306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

Line 310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;

306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;

Line 311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
315: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;

Line 312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;

308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
315: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
316: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;

Line 877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

873:
874:
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

Line 878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;

874:
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;

Line 879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
883:

Line 880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;

876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
883:
884: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;