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.IGS_PRECREATE_APPL_PUB dependencies on IGS_AD_CODE_CLASSES

Line 83: CURSOR c_estatus(p_estatus IGS_AD_CODE_CLASSES.code_id%TYPE) IS

79: FROM hz_parties hzp
80: WHERE hzp.party_id = p_person_id;
81:
82: -- Cursor to validate Entry Status
83: CURSOR c_estatus(p_estatus IGS_AD_CODE_CLASSES.code_id%TYPE) IS
84: SELECT code_id
85: FROM IGS_AD_CODE_CLASSES
86: WHERE class = 'STATUS' AND
87: code_id = p_estatus;

Line 85: FROM IGS_AD_CODE_CLASSES

81:
82: -- Cursor to validate Entry Status
83: CURSOR c_estatus(p_estatus IGS_AD_CODE_CLASSES.code_id%TYPE) IS
84: SELECT code_id
85: FROM IGS_AD_CODE_CLASSES
86: WHERE class = 'STATUS' AND
87: code_id = p_estatus;
88:
89: -- Cursor to validate Entry Level

Line 90: CURSOR c_elevel(p_elevel IGS_AD_CODE_CLASSES.code_id%TYPE) IS

86: WHERE class = 'STATUS' AND
87: code_id = p_estatus;
88:
89: -- Cursor to validate Entry Level
90: CURSOR c_elevel(p_elevel IGS_AD_CODE_CLASSES.code_id%TYPE) IS
91: SELECT code_id
92: FROM IGS_AD_CODE_CLASSES
93: WHERE class = 'LEVEL' AND
94: code_id = p_elevel;

Line 92: FROM IGS_AD_CODE_CLASSES

88:
89: -- Cursor to validate Entry Level
90: CURSOR c_elevel(p_elevel IGS_AD_CODE_CLASSES.code_id%TYPE) IS
91: SELECT code_id
92: FROM IGS_AD_CODE_CLASSES
93: WHERE class = 'LEVEL' AND
94: code_id = p_elevel;
95:
96: -- Cursor to validate Special Group 1

Line 97: CURSOR c_spcl_grp1(p_spcl_grp1 IGS_AD_CODE_CLASSES.code_id%TYPE) IS

93: WHERE class = 'LEVEL' AND
94: code_id = p_elevel;
95:
96: -- Cursor to validate Special Group 1
97: CURSOR c_spcl_grp1(p_spcl_grp1 IGS_AD_CODE_CLASSES.code_id%TYPE) IS
98: SELECT code_id
99: FROM IGS_AD_CODE_CLASSES
100: WHERE class = 'SPECIAL_GROUP1' AND
101: code_id = p_spcl_grp1;

Line 99: FROM IGS_AD_CODE_CLASSES

95:
96: -- Cursor to validate Special Group 1
97: CURSOR c_spcl_grp1(p_spcl_grp1 IGS_AD_CODE_CLASSES.code_id%TYPE) IS
98: SELECT code_id
99: FROM IGS_AD_CODE_CLASSES
100: WHERE class = 'SPECIAL_GROUP1' AND
101: code_id = p_spcl_grp1;
102:
103: -- Cursor to validate Special Group 2

Line 104: CURSOR c_spcl_grp2(p_spcl_grp2 IGS_AD_CODE_CLASSES.code_id%TYPE) IS

100: WHERE class = 'SPECIAL_GROUP1' AND
101: code_id = p_spcl_grp1;
102:
103: -- Cursor to validate Special Group 2
104: CURSOR c_spcl_grp2(p_spcl_grp2 IGS_AD_CODE_CLASSES.code_id%TYPE) IS
105: SELECT code_id
106: FROM IGS_AD_CODE_CLASSES
107: WHERE class = 'SPECIAL_GROUP2' AND
108: code_id = p_spcl_grp2;

Line 106: FROM IGS_AD_CODE_CLASSES

102:
103: -- Cursor to validate Special Group 2
104: CURSOR c_spcl_grp2(p_spcl_grp2 IGS_AD_CODE_CLASSES.code_id%TYPE) IS
105: SELECT code_id
106: FROM IGS_AD_CODE_CLASSES
107: WHERE class = 'SPECIAL_GROUP2' AND
108: code_id = p_spcl_grp2;
109:
110: -- Cursor to validate Admission Application Type

Line 127: CURSOR c_appsource(p_app_source_id IGS_AD_CODE_CLASSES.code_id%TYPE) IS

123: admission_cat = p_admission_cat AND
124: s_admission_process_type = p_s_admission_process_type;
125:
126: -- Cursor to validate Application Source Id. Applicant could be either Web Applicant or Web Staff
127: CURSOR c_appsource(p_app_source_id IGS_AD_CODE_CLASSES.code_id%TYPE) IS
128: SELECT code_id
129: FROM IGS_AD_CODE_CLASSES
130: WHERE class = 'SYS_APPL_SOURCE' AND
131: code_id = p_app_source_id AND

Line 129: FROM IGS_AD_CODE_CLASSES

125:
126: -- Cursor to validate Application Source Id. Applicant could be either Web Applicant or Web Staff
127: CURSOR c_appsource(p_app_source_id IGS_AD_CODE_CLASSES.code_id%TYPE) IS
128: SELECT code_id
129: FROM IGS_AD_CODE_CLASSES
130: WHERE class = 'SYS_APPL_SOURCE' AND
131: code_id = p_app_source_id AND
132: SYSTEM_STATUS IN ('WEB_STAFF', 'WEB_APPL');
133:

Line 184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

180: s_admission_step_type = 'LATE-APP' AND
181: mandatory_step_ind = 'Y';
182:
183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;
184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;

Line 185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

181: mandatory_step_ind = 'Y';
182:
183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;
184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;
189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;

Line 186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

182:
183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;
184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;
189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
190: l_appsource_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

Line 187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;
184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;
189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
190: l_appsource_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
191: l_cal_rel_rec IGS_CA_INST.CAL_TYPE%TYPE := NULL;

Line 190: l_appsource_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;

186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;
189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
190: l_appsource_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
191: l_cal_rel_rec IGS_CA_INST.CAL_TYPE%TYPE := NULL;
192:
193: l_apptype_rec c_apptype%ROWTYPE := NULL;
194: l_cal_rec c_cal%ROWTYPE := NULL;

Line 1764: CURSOR C_FEE_TYPE(p_APPL_FEE_TYPE IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS

1760: l_msg_index NUMBER;
1761: l_return_status VARCHAR2(1);
1762: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1763:
1764: CURSOR C_FEE_TYPE(p_APPL_FEE_TYPE IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1765: SELECT CC.CODE_ID
1766: FROM IGS_AD_CODE_CLASSES CC
1767: WHERE CC.CODE_ID = p_APPL_FEE_TYPE
1768: AND CC.CLASS = 'SYS_FEE_TYPE'

Line 1766: FROM IGS_AD_CODE_CLASSES CC

1762: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1763:
1764: CURSOR C_FEE_TYPE(p_APPL_FEE_TYPE IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1765: SELECT CC.CODE_ID
1766: FROM IGS_AD_CODE_CLASSES CC
1767: WHERE CC.CODE_ID = p_APPL_FEE_TYPE
1768: AND CC.CLASS = 'SYS_FEE_TYPE'
1769: AND NVL(CLOSED_IND,'N') = 'N'
1770: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 1772: CURSOR C_FEE_STATUS(p_APPL_FEE_STATUS IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS

1768: AND CC.CLASS = 'SYS_FEE_TYPE'
1769: AND NVL(CLOSED_IND,'N') = 'N'
1770: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';
1771:
1772: CURSOR C_FEE_STATUS(p_APPL_FEE_STATUS IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1773: SELECT CC.CODE_ID
1774: FROM IGS_AD_CODE_CLASSES CC
1775: WHERE CC.CODE_ID = p_APPL_FEE_STATUS
1776: AND CC.CLASS = 'SYS_FEE_STATUS'

Line 1774: FROM IGS_AD_CODE_CLASSES CC

1770: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';
1771:
1772: CURSOR C_FEE_STATUS(p_APPL_FEE_STATUS IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1773: SELECT CC.CODE_ID
1774: FROM IGS_AD_CODE_CLASSES CC
1775: WHERE CC.CODE_ID = p_APPL_FEE_STATUS
1776: AND CC.CLASS = 'SYS_FEE_STATUS'
1777: AND NVL(CLOSED_IND,'N') = 'N'
1778: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 1781: CURSOR C_FEE_PAYMENT_METHOD(p_APPL_FEE_PAY_MET IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS

1777: AND NVL(CLOSED_IND,'N') = 'N'
1778: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';
1779:
1780:
1781: CURSOR C_FEE_PAYMENT_METHOD(p_APPL_FEE_PAY_MET IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1782: SELECT CC.CODE_ID
1783: FROM IGS_AD_CODE_CLASSES CC
1784: WHERE CC.CODE_ID = p_APPL_FEE_PAY_MET
1785: AND CC.CLASS = 'SYS_FEE_PAY_METHOD'

Line 1783: FROM IGS_AD_CODE_CLASSES CC

1779:
1780:
1781: CURSOR C_FEE_PAYMENT_METHOD(p_APPL_FEE_PAY_MET IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1782: SELECT CC.CODE_ID
1783: FROM IGS_AD_CODE_CLASSES CC
1784: WHERE CC.CODE_ID = p_APPL_FEE_PAY_MET
1785: AND CC.CLASS = 'SYS_FEE_PAY_METHOD'
1786: AND NVL(CLOSED_IND,'N') = 'N'
1787: AND CC.CLASS_TYPE_CODE='ADM_CODE_CLASSES';