APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_APP_REQ

Line 626: igs_ad_app_req req

622: SELECT
623: (NVL(apl.appl_fee_amt,0)-sum(req.FEE_AMOUNT)) OutstandingBal
624: FROM
625: IGS_AD_APPL_ALL apl,
626: igs_ad_app_req req
627: WHERE
628: apl.person_id= p_person_id AND
629: apl.admission_appl_number = p_admission_appl_number AND
630: apl.person_id = req.person_id AND

Line 739: Modified call to igs_ad_app_req_pkg.insert_row() - added 3 new parameters

735: Who When What
736: (reverse chronological order - newest change first)
737: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build
738: Added new IN parameter, p_credit_card_tangible_cd
739: Modified call to igs_ad_app_req_pkg.insert_row() - added 3 new parameters
740: VVUTUKUR 26-NOV-2002 Enh#2584986.GL Interface Build. Added 9 new parameters to this procedure.
741: These additional attributes, i.e. credit card details, Accounting information and the GL_DATE are passed to the call to igs_ad_app_req_pkg.insert_row.
742: ***************************************************************/
743:

Line 741: These additional attributes, i.e. credit card details, Accounting information and the GL_DATE are passed to the call to igs_ad_app_req_pkg.insert_row.

737: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build
738: Added new IN parameter, p_credit_card_tangible_cd
739: Modified call to igs_ad_app_req_pkg.insert_row() - added 3 new parameters
740: VVUTUKUR 26-NOV-2002 Enh#2584986.GL Interface Build. Added 9 new parameters to this procedure.
741: These additional attributes, i.e. credit card details, Accounting information and the GL_DATE are passed to the call to igs_ad_app_req_pkg.insert_row.
742: ***************************************************************/
743:
744: --CURSOR which checks whether the application is a valid one
745: CURSOR is_valid_appl_cur(l_person_id IN NUMBER, l_admission_appl_number IN NUMBER) IS

Line 828: igs_ad_app_req_pkg.insert_row(

824: CLOSE def_fee_types_cur;
825:
826: -- Removed the existing check that disallowed multiple payments for the same fee type as a part of IGS.M
827:
828: igs_ad_app_req_pkg.insert_row(
829: X_ROWID => l_rowid,
830: X_APP_REQ_ID => l_app_req_id,
831: X_PERSON_ID => p_person_id,
832: X_ADMISSION_APPL_NUMBER => p_admission_appl_number,

Line 856: -- All the validations are successfull and insertion of record into igs_ad_app_req is successfull.

852: x_credit_card_status_code => 'PENDING'
853: );
854: END IF;
855:
856: -- All the validations are successfull and insertion of record into igs_ad_app_req is successfull.
857: x_return_status := 'S';
858: x_msg_count:=0;
859: x_msg_data :=NULL;
860: