APPS.IGS_AD_APP_REQ_PKG dependencies on IGS_AD_CODE_CLASSES

Line 151: FROM igs_ad_code_classes

147:
148: -- Cursor to get the fee type
149: CURSOR cur_enr_dpt(cp_applicant_fee_type igs_ad_app_req.applicant_fee_type%TYPE) IS
150: SELECT system_status
151: FROM igs_ad_code_classes
152: WHERE code_id = cp_applicant_fee_type;
153:
154: -- Cursor to get the fee status
155: CURSOR cur_ent_dpt_upd(cp_applicant_fee_status igs_ad_app_req.applicant_fee_status%TYPE) IS

Line 157: FROM igs_ad_code_classes

153:
154: -- Cursor to get the fee status
155: CURSOR cur_ent_dpt_upd(cp_applicant_fee_status igs_ad_app_req.applicant_fee_status%TYPE) IS
156: SELECT system_status
157: FROM igs_ad_code_classes
158: WHERE code_id = cp_applicant_fee_status;
159:
160: l_fee_status igs_ad_code_classes.system_status%TYPE;
161: l_fee_type igs_ad_code_classes.system_status%TYPE;

Line 160: l_fee_status igs_ad_code_classes.system_status%TYPE;

156: SELECT system_status
157: FROM igs_ad_code_classes
158: WHERE code_id = cp_applicant_fee_status;
159:
160: l_fee_status igs_ad_code_classes.system_status%TYPE;
161: l_fee_type igs_ad_code_classes.system_status%TYPE;
162:
163: -- Cursor to get the application date of the application
164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,

Line 161: l_fee_type igs_ad_code_classes.system_status%TYPE;

157: FROM igs_ad_code_classes
158: WHERE code_id = cp_applicant_fee_status;
159:
160: l_fee_status igs_ad_code_classes.system_status%TYPE;
161: l_fee_type igs_ad_code_classes.system_status%TYPE;
162:
163: -- Cursor to get the application date of the application
164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,
165: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS

Line 328: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

324:
325: IF (((old_references.fee_payment_method = new_references.fee_payment_method)) OR
326: ((new_references.fee_payment_method IS NULL))) THEN
327: NULL;
328: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
329: new_references.fee_payment_method ,
330: 'SYS_FEE_PAY_METHOD',
331: 'N'
332: ) THEN

Line 357: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

353:
354: IF (((old_references.applicant_fee_status = new_references.applicant_fee_status)) OR
355: ((new_references.applicant_fee_status IS NULL))) THEN
356: NULL;
357: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
358: new_references.applicant_fee_status ,
359: 'SYS_FEE_STATUS',
360: 'N'
361: ) THEN

Line 371: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

367:
368: IF (((old_references.applicant_fee_type = new_references.applicant_fee_type)) OR
369: ((new_references.applicant_fee_type IS NULL))) THEN
370: NULL;
371: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
372: new_references.applicant_fee_type ,
373: 'SYS_FEE_TYPE',
374: 'N'
375: ) THEN

Line 488: PROCEDURE Get_FK_Igs_Ad_Code_Classes (

484: Close cur_rowid;
485:
486: END Get_FK_Igs_Ad_Appl;
487:
488: PROCEDURE Get_FK_Igs_Ad_Code_Classes (
489: x_code_id IN NUMBER
490: ) AS
491:
492: /*************************************************************

Line 560: END Get_FK_Igs_Ad_Code_Classes;

556: Return;
557: END IF;
558: Close cur_rowid3;
559:
560: END Get_FK_Igs_Ad_Code_Classes;
561:
562:
563: PROCEDURE Before_DML (
564: p_action IN VARCHAR2,