APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_FEE_PMNT

Line 118: FROM igs_as_doc_fee_pmnt

114: -- Cursor to select the the info whether the student has paid the life time fee or not
115: --
116: CURSOR c_lifetime_fee IS
117: SELECT lifetime_fee_paid
118: FROM igs_as_doc_fee_pmnt
119: WHERE person_id = p_person_id
120: AND document_type = 'TRANSCRIPT'
121: AND fee_paid_type = 'LIFETIME';
122: --

Line 417: FROM igs_as_doc_fee_pmnt ltfp

413: -- Cursor that checks if a person has paid life time fee or not
414: --
415: CURSOR cur_life_time_fee_paid (cp_person_id IN NUMBER) IS
416: SELECT NVL (ltfp.lifetime_fee_paid, 'N') life_time_fee_paid
417: FROM igs_as_doc_fee_pmnt ltfp
418: WHERE ltfp.document_type = 'TRANSCRIPT'
419: AND fee_paid_type = 'LIFETIME'
420: AND ltfp.person_id = cp_person_id;
421: --

Line 1341: FROM igs_as_doc_fee_pmnt subs,

1337: pln.unlimited_ind,
1338: pln.quantity_limit,
1339: pln.period_of_plan,
1340: pln.total_periods_covered
1341: FROM igs_as_doc_fee_pmnt subs,
1342: igs_as_servic_plan pln
1343: WHERE subs.plan_id = pln.plan_id
1344: AND subs.person_id = p_person_id
1345: AND subs.plan_id = cp_plan_id

Line 1397: FROM igs_as_doc_fee_pmnt

1393: FOR free_plan_rec IN cur_free_plan LOOP
1394: --- See if the person has already availed this :
1395: SELECT SUM (NVL (num_of_copies, 0))
1396: INTO lncopies_availded
1397: FROM igs_as_doc_fee_pmnt
1398: WHERE person_id = p_person_id
1399: AND plan_id = free_plan_rec.plan_id
1400: AND program_on_file IN ('ALL', p_program_on_file);
1401: -- See if the number of copies availed so far still alows the free transcript.

Line 1703: /*IGS_AS_DOC_FEE_PMNT_PKG.INSERT_ROW(

1699: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
1700: RETURN;
1701: END IF;
1702: -- Inserting record into fee payment, so that transcript items dos fees are calc to Zero
1703: /*IGS_AS_DOC_FEE_PMNT_PKG.INSERT_ROW(
1704: X_ROWID => l_fmnt_row_Id,
1705: X_PERSON_ID => p_person_id,
1706: X_DOCUMENT_TYPE => 'TRANSCRIPT',
1707: X_FEE_PAID_TYPE => 'LIFETIME',

Line 1763: FROM igs_as_doc_fee_pmnt a

1759: -- to update the lft flag
1760: CURSOR c_doc_fee_pmnt_record IS
1761: SELECT a.*,
1762: a.ROWID
1763: FROM igs_as_doc_fee_pmnt a
1764: WHERE person_id = p_person_id;
1765: c_doc_fee_pmnt_rec c_doc_fee_pmnt_record%ROWTYPE;
1766: c_order_item_rec c_order_item%ROWTYPE;
1767: -- Variables

Line 1783: /*IGS_AS_DOC_FEE_PMNT_PKG.UPDATE_ROW(

1779: BEGIN
1780: OPEN c_doc_fee_pmnt_record;
1781: FETCH c_doc_fee_pmnt_record INTO c_doc_fee_pmnt_rec;
1782: -- Update record into fee payment, so that transcript items dos fees are calc to Zero
1783: /*IGS_AS_DOC_FEE_PMNT_PKG.UPDATE_ROW(
1784: X_ROWID => c_doc_fee_pmnt_rec.rowid,
1785: X_PERSON_ID => p_person_id,
1786: X_DOCUMENT_TYPE => c_doc_fee_pmnt_rec.document_type,
1787: X_FEE_PAID_TYPE => c_doc_fee_pmnt_rec.fee_paid_type,

Line 2203: FROM igs_as_doc_fee_pmnt f

2199: -- Cursor to update the doc_fee_pmnt
2200: CURSOR cur_doc_fee_pmnt IS
2201: SELECT f.ROWID row_id,
2202: f.*
2203: FROM igs_as_doc_fee_pmnt f
2204: WHERE person_id = p_person_id
2205: AND plan_id = p_plan_id;
2206: rec_doc_fee_pmnt cur_doc_fee_pmnt%ROWTYPE;
2207: prev_order_number NUMBER;

Line 2393: -- Update the IGS_AS_DOC_FEE_PMNT table with end date as SYSDATE.

2389: END update_itm_for_recalc;
2390: BEGIN -- Begin Of Main Procedure
2391: ln_plan_id := p_plan_id;
2392: IF p_subs_unsubs = 'U' THEN
2393: -- Update the IGS_AS_DOC_FEE_PMNT table with end date as SYSDATE.
2394: OPEN cur_doc_fee_pmnt;
2395: FETCH cur_doc_fee_pmnt INTO rec_doc_fee_pmnt;
2396: CLOSE cur_doc_fee_pmnt;
2397: BEGIN

Line 2398: igs_as_doc_fee_pmnt_pkg.update_row (

2394: OPEN cur_doc_fee_pmnt;
2395: FETCH cur_doc_fee_pmnt INTO rec_doc_fee_pmnt;
2396: CLOSE cur_doc_fee_pmnt;
2397: BEGIN
2398: igs_as_doc_fee_pmnt_pkg.update_row (
2399: x_rowid => rec_doc_fee_pmnt.row_id,
2400: x_person_id => rec_doc_fee_pmnt.person_id,
2401: x_fee_paid_date => rec_doc_fee_pmnt.fee_paid_date,
2402: x_fee_amount => rec_doc_fee_pmnt.fee_amount,