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_AD_GEN_015 dependencies on IGS_AD_CODE_CLASSES

Line 23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES

19: vvutukur 27-Nov-2002 Enh#2584986.Modified procedure create_enrollment_deposit.
20: ******************************************************************/
21: --Fwd Declarations
22: PROCEDURE check_ad_code_classes_setup (
23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID

Line 24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES

20: ******************************************************************/
21: --Fwd Declarations
22: PROCEDURE check_ad_code_classes_setup (
23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
28: );

Line 25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD

21: --Fwd Declarations
22: PROCEDURE check_ad_code_classes_setup (
23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
28: );
29:

Line 26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK

22: PROCEDURE check_ad_code_classes_setup (
23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
28: );
29:
30: --Procedure Definitions

Line 27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID

23: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
24: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
25: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
26: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
27: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
28: );
29:
30: --Procedure Definitions
31: PROCEDURE create_enrollment_deposit(

Line 74: AND applicant_fee_status IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_status AND system_status IN (cst_paid,cst_partial) AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')

70: SELECT NVL(SUM (fee_amount),0) total_fee_amount
71: FROM igs_ad_app_req
72: WHERE person_id = p_person_id
73: AND admission_appl_number = p_admission_appl_number
74: AND applicant_fee_status IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_status AND system_status IN (cst_paid,cst_partial) AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
75: AND applicant_fee_type IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_types AND system_status = cst_enroll_deposit AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
76:
77: c_paid_partial_rec c_paid_partial%ROWTYPE;
78:

Line 75: AND applicant_fee_type IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_types AND system_status = cst_enroll_deposit AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');

71: FROM igs_ad_app_req
72: WHERE person_id = p_person_id
73: AND admission_appl_number = p_admission_appl_number
74: AND applicant_fee_status IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_status AND system_status IN (cst_paid,cst_partial) AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
75: AND applicant_fee_type IN (SELECT code_id FROM igs_ad_code_classes WHERE class = cst_fee_types AND system_status = cst_enroll_deposit AND closed_ind = 'N' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
76:
77: c_paid_partial_rec c_paid_partial%ROWTYPE;
78:
79: -- Cursor to get the enroll_deposit_amount for the application type

Line 95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;

91: l_rowid VARCHAR2(25);
92: l_app_req_id NUMBER;
93: l_paid_record_created BOOLEAN;
94: l_request_id NUMBER;
95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;
98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;
99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;

Line 96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;

92: l_app_req_id NUMBER;
93: l_paid_record_created BOOLEAN;
94: l_request_id NUMBER;
95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;
98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;
99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;
100:

Line 97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;

93: l_paid_record_created BOOLEAN;
94: l_request_id NUMBER;
95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;
98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;
99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;
100:
101: BEGIN

Line 98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;

94: l_request_id NUMBER;
95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;
98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;
99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;
100:
101: BEGIN
102: -- Performing mandatory Admissions system setup check...

Line 99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;

95: l_paid_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
96: l_partial_fee_stat_code_id igs_ad_code_classes.code_id%TYPE;
97: l_final_sys_dflt_fee_stat igs_ad_code_classes.code_id%TYPE;
98: l_fee_type_code_id igs_ad_code_classes.code_id%TYPE;
99: l_pay_mthd_code_id igs_ad_code_classes.code_id%TYPE;
100:
101: BEGIN
102: -- Performing mandatory Admissions system setup check...
103: -- Check if set-up information exists for system defaulted user defined Fee Status with System Status: Paid.

Line 327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES

323:
324: END create_enrollment_deposit;
325:
326: PROCEDURE check_ad_code_classes_setup (
327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID

Line 328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES

324: END create_enrollment_deposit;
325:
326: PROCEDURE check_ad_code_classes_setup (
327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
332: ) IS

Line 329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD

325:
326: PROCEDURE check_ad_code_classes_setup (
327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
332: ) IS
333:

Line 330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK

326: PROCEDURE check_ad_code_classes_setup (
327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
332: ) IS
333:
334: /******************************************************************

Line 331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID

327: p_class_type IN igs_ad_code_classes.class%TYPE -- APPLICATION_FEES
328: , p_class IN igs_ad_code_classes.class%TYPE -- FEE_PAYMENT_METHODS, FEE_STATUS, FEE_TYPES
329: , p_std_sys_stat IN igs_ad_code_classes.system_status%TYPE -- SYS_FEE_STATUS, SYS_FEE_TYPE, SYS_FEE_PAY_METHOD
330: , p_sys_stat IN igs_ad_code_classes.system_status%TYPE -- PAID, ENROLL_DEPOSIT, CHECK
331: , p_code_id OUT NOCOPY igs_ad_code_classes.code_id%TYPE -- Return value: CODE_ID
332: ) IS
333:
334: /******************************************************************
335: Created By: Navin Sinha

Line 345: -- Cursor to check set for igs_ad_code_classes are done on client site.

341: Who When What
342: pathipat 06-Jan-2003 Bug: 2734574 - Removed exception section
343: ******************************************************************/
344:
345: -- Cursor to check set for igs_ad_code_classes are done on client site.
346: CURSOR c_ad_cd_class IS
347: SELECT code_id
348: FROM igs_ad_code_classes
349: WHERE class = p_class

Line 348: FROM igs_ad_code_classes

344:
345: -- Cursor to check set for igs_ad_code_classes are done on client site.
346: CURSOR c_ad_cd_class IS
347: SELECT code_id
348: FROM igs_ad_code_classes
349: WHERE class = p_class
350: AND system_status = p_sys_stat
351: AND NVL(system_default, 'N') = 'Y'
352: AND closed_ind = 'N'