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_APP_REQ

Line 7: New Package to Insert record in the table IGS_AD_APP_REQ

3: /******************************************************************
4: Created By: Navin Sinha
5: Date Created By: 07-Oct-2002
6: Purpose: BUG NO : 2602077 : HQ: release of build for td sf integrarion.
7: New Package to Insert record in the table IGS_AD_APP_REQ
8: (Application Fee ) whenever an Enrollment Deposit is
9: Recorded in the Student Finance .
10: Known limitations,enhancements,remarks:
11: Change History

Line 14: Added New procedure to updare record in the table IGS_AD_APP_REQ.

10: Known limitations,enhancements,remarks:
11: Change History
12: Who When What
13: Navin.sinha 10/1/2003 BUG NO : 3160036 : OSSTST15: enrollment deposit fee error in sf gl interface process
14: Added New procedure to updare record in the table IGS_AD_APP_REQ.
15: pathipat 14-Jun-2003 Enh 2831587 - FI210 Credit Card Fund Transfer build
16: Modified create_enrollment_deposit() - igs_ad_app_req_pkg.insert_row() call
17: pathipat 06-Jan-2003 Bug: 2728620 and 2734574 - Removed exception section
18: in create_enrollment_deposit() and check_ad_code_classes_setup()

Line 16: Modified create_enrollment_deposit() - igs_ad_app_req_pkg.insert_row() call

12: Who When What
13: Navin.sinha 10/1/2003 BUG NO : 3160036 : OSSTST15: enrollment deposit fee error in sf gl interface process
14: Added New procedure to updare record in the table IGS_AD_APP_REQ.
15: pathipat 14-Jun-2003 Enh 2831587 - FI210 Credit Card Fund Transfer build
16: Modified create_enrollment_deposit() - igs_ad_app_req_pkg.insert_row() call
17: pathipat 06-Jan-2003 Bug: 2728620 and 2734574 - Removed exception section
18: in create_enrollment_deposit() and check_ad_code_classes_setup()
19: vvutukur 27-Nov-2002 Enh#2584986.Modified procedure create_enrollment_deposit.
20: ******************************************************************/

Line 43: New Procedure to Insert record in the table IGS_AD_APP_REQ

39: /******************************************************************
40: Created By: Navin Sinha
41: Date Created By: 07-Oct-2002
42: Purpose: BUG NO : 2602077 : HQ: release of build for td sf integrarion.
43: New Procedure to Insert record in the table IGS_AD_APP_REQ
44: (Application Fee ) whenever an Enrollment Deposit is
45: Recorded in the Student Finance .
46: Known limitations,enhancements,remarks:
47: Change History

Line 50: Modified call to igs_ad_app_req_pkg.insert_row - added 3 new parameters

46: Known limitations,enhancements,remarks:
47: Change History
48: Who When What
49: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build
50: Modified call to igs_ad_app_req_pkg.insert_row - added 3 new parameters
51: pathipat 06-Jan-2003 Bug: 2728620 - Removed exception section
52: vvutukur 27-Nov-2002 Enh#2584986.Modified the tbh call to igs_ad_app_req.insert_row to include 11 new
53: columns. NULL is being passed to all the 11 columns.
54: ******************************************************************/

Line 52: vvutukur 27-Nov-2002 Enh#2584986.Modified the tbh call to igs_ad_app_req.insert_row to include 11 new

48: Who When What
49: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build
50: Modified call to igs_ad_app_req_pkg.insert_row - added 3 new parameters
51: pathipat 06-Jan-2003 Bug: 2728620 - Removed exception section
52: vvutukur 27-Nov-2002 Enh#2584986.Modified the tbh call to igs_ad_app_req.insert_row to include 11 new
53: columns. NULL is being passed to all the 11 columns.
54: ******************************************************************/
55:
56: cst_paid CONSTANT VARCHAR2(5) := 'PAID';

Line 71: FROM igs_ad_app_req

67: -- Cursor to Check if an enrollment deposit record(with system fee status as PARTIAL, PAID) already exists for this application.
68: -- SUM (fee_amount) > 0 will indicate that above condition is TRUE.
69: CURSOR c_paid_partial IS
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');

Line 169: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)

165: , l_fee_payment_method -- CHECK
166: , l_pay_mthd_code_id -- Return value: CODE_ID
167: );
168:
169: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)
170:
171: -- Create an fee payment record in the AD table
172: igs_ad_app_req_pkg.insert_row (
173: X_Mode => 'R',

Line 172: igs_ad_app_req_pkg.insert_row (

168:
169: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)
170:
171: -- Create an fee payment record in the AD table
172: igs_ad_app_req_pkg.insert_row (
173: X_Mode => 'R',
174: X_RowId => l_rowid,
175: X_App_Req_Id => l_app_req_id,
176: X_Person_Id => p_person_id,

Line 390: PROCEDURE update_igs_ad_app_req (

386: CLOSE c_ad_cd_class;
387:
388: END check_ad_code_classes_setup;
389:
390: PROCEDURE update_igs_ad_app_req (
391: p_rowid IN VARCHAR2,
392: p_app_req_id IN NUMBER,
393: p_person_id IN NUMBER,
394: p_admission_appl_number IN NUMBER,

Line 421: New procedure to updare record in the table IGS_AD_APP_REQ.

417: /*************************************************************
418: Created By: Navin Sinha
419: Date Created By: 01-Oct-2003
420: Purpose: BUG NO : 3160036 : OSSTST15: enrollment deposit fee error in sf gl interface process
421: New procedure to updare record in the table IGS_AD_APP_REQ.
422: Know limitations, enhancements or remarks
423: Change History
424: Who When What
425: (reverse chronological order - newest change first)

Line 429: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)

425: (reverse chronological order - newest change first)
426: ***************************************************************/
427:
428: BEGIN
429: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)
430:
431: -- Update the fee payment record in the AD table
432: igs_ad_app_req_pkg.update_row (
433: x_rowid => p_rowid,

Line 432: igs_ad_app_req_pkg.update_row (

428: BEGIN
429: igs_ad_gen_015.g_chk_ad_app_req := 'Y'; -- Based on the value of this variable , some of the validation wont be perform in igs_ad_app_req_pkg(bug#2901627 -- rghosh)
430:
431: -- Update the fee payment record in the AD table
432: igs_ad_app_req_pkg.update_row (
433: x_rowid => p_rowid,
434: x_app_req_id => p_app_req_id,
435: x_person_id => p_person_id,
436: x_admission_appl_number => p_admission_appl_number,

Line 461: END update_igs_ad_app_req;

457: x_mode => p_mode
458: );
459:
460: igs_ad_gen_015.g_chk_ad_app_req := 'N';
461: END update_igs_ad_app_req;
462:
463: END igs_ad_gen_015;