APPS.IGS_FI_CC_PMT dependencies on IGS_AD_APP_REQ

Line 17: FROM igs_ad_app_req aar

13:
14: CURSOR c_app_req(cp_pending IN VARCHAR2)
15: IS
16: SELECT aar.rowid, aar.*
17: FROM igs_ad_app_req aar
18: WHERE credit_card_number IS NOT NULL
19: AND credit_card_status_code = cp_pending
20: AND credit_card_tangible_cd IS NOT NULL
21: FOR UPDATE NOWAIT;

Line 41: --vvutukur 09-Oct-2003 Bug#3160036.Replaced the call to igs_ad_app_req.update_row with

37: --Who When What
38: --agairola 29-Aug-2005 Tuition Waiver build: 3392095: Changes done for this build
39: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
40: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
41: --vvutukur 09-Oct-2003 Bug#3160036.Replaced the call to igs_ad_app_req.update_row with
42: -- call to igs_ad_gen_015.update_igs_ad_app_req.
43: -------------------------------------------------------------------
44:
45: -- Get the payment status

Line 42: -- call to igs_ad_gen_015.update_igs_ad_app_req.

38: --agairola 29-Aug-2005 Tuition Waiver build: 3392095: Changes done for this build
39: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
40: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
41: --vvutukur 09-Oct-2003 Bug#3160036.Replaced the call to igs_ad_app_req.update_row with
42: -- call to igs_ad_gen_015.update_igs_ad_app_req.
43: -------------------------------------------------------------------
44:
45: -- Get the payment status
46: CURSOR c_iby_trans(cp_tangible_id IN iby_trans_all_v.tangibleid%TYPE,

Line 211: igs_ad_gen_015.update_igs_ad_app_req(

207: IF l_flag THEN
208: SAVEPOINT sp_adm;
209: BEGIN
210: -- Update the credit card status in the Admissions Applications Request Table
211: igs_ad_gen_015.update_igs_ad_app_req(
212: p_rowid => p_r_ad_app_row.rowid,
213: p_app_req_id => p_r_ad_app_row.app_req_id,
214: p_person_id => p_r_ad_app_row.person_id,
215: p_admission_appl_number => p_r_ad_app_row.admission_appl_number,