APPS.PSA_MFAR_RECEIPTS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 5: g_cust_trx_id ar_receivable_applications.applied_customer_trx_id%type;

1: PACKAGE BODY PSA_MFAR_RECEIPTS AS
2: /* $Header: PSAMFRTB.pls 120.29 2006/09/13 13:45:49 agovil ship $ */
3:
4: g_set_of_books_id gl_sets_of_books.set_of_books_id%type;
5: g_cust_trx_id ar_receivable_applications.applied_customer_trx_id%type;
6: g_receivable_application_id ar_receivable_applications.receivable_application_id%type;
7: g_inventory_item_profile NUMBER;
8: g_run_id NUMBER;
9: l_exception_message VARCHAR2(3000);

Line 6: g_receivable_application_id ar_receivable_applications.receivable_application_id%type;

2: /* $Header: PSAMFRTB.pls 120.29 2006/09/13 13:45:49 agovil ship $ */
3:
4: g_set_of_books_id gl_sets_of_books.set_of_books_id%type;
5: g_cust_trx_id ar_receivable_applications.applied_customer_trx_id%type;
6: g_receivable_application_id ar_receivable_applications.receivable_application_id%type;
7: g_inventory_item_profile NUMBER;
8: g_run_id NUMBER;
9: l_exception_message VARCHAR2(3000);
10:

Line 106: ar_receivable_applications_all ra

102: CURSOR c_crh
103: IS
104: SELECT distinct crh.status , crh.cash_receipt_id
105: FROM ar_cash_receipt_history_all crh,
106: ar_receivable_applications_all ra
107: WHERE crh.cash_receipt_id = ra.cash_receipt_id
108: AND ra.receivable_application_id = p_receivable_app_id
109: ORDER BY crh.status desc;
110:

Line 123: FROM ar_receivable_applications_all app

119: app.unearned_discount_taken unearned_discount,
120: app.earned_discount_ccid earned_discount_ccid,
121: app.unearned_discount_ccid unearned_discount_ccid,
122: app.customer_trx_id cm_trx_id
123: FROM ar_receivable_applications_all app
124: WHERE app.receivable_application_id = p_receivable_app_id
125: AND app.status = 'APP'
126: FOR UPDATE;
127:

Line 176: l_ccid ar_receivable_applications.code_combination_id%type;

172: c_crh_rec c_crh%ROWTYPE;
173: l_credit_memo_type c_credit_memo_type%rowtype;
174: l_direct_cm c_direct_cm%rowtype;
175: l_cash_ccid c_cash_ccid%rowtype;
176: l_ccid ar_receivable_applications.code_combination_id%type;
177:
178: l_direct_cm_line_amount c_direct_cm_line_amount%rowtype;
179: l_currency_code VARCHAR2(15);
180:

Line 731: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;

727:
728: -- l_accrual_rec c_accrual%rowtype;
729: -- l_cash_rec c_cash%rowtype;
730: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;
731: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;
732: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;
733: l_rowid ROWID;
734: run_num number(15);
735:

Line 732: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;

728: -- l_accrual_rec c_accrual%rowtype;
729: -- l_cash_rec c_cash%rowtype;
730: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;
731: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;
732: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;
733: l_rowid ROWID;
734: run_num number(15);
735:
736: l_c_accrual_stmt VARCHAR2(6000);

Line 1381: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;

1377:
1378: -- l_accrual_rec c_accrual%rowtype;
1379: -- l_cash_rec c_cash%rowtype;
1380: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;
1381: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;
1382: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;
1383: l_rowid ROWID;
1384: run_num number(15);
1385:

Line 1382: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;

1378: -- l_accrual_rec c_accrual%rowtype;
1379: -- l_cash_rec c_cash%rowtype;
1380: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;
1381: p_mf_earned_discount_ccid ar_receivable_applications.earned_discount_ccid%type;
1382: p_mf_unearned_discount_ccid ar_receivable_applications.unearned_discount_ccid%type;
1383: l_rowid ROWID;
1384: run_num number(15);
1385:
1386: l_c_accrual_stmt VARCHAR2(6000);

Line 1557: FROM ar_receivable_applications_all app

1553: -- for each receivable application ids
1554:
1555: SELECT -1*LINE_Applied , -1*TAX_Applied
1556: INTO l_line_amount, l_tax_amount
1557: FROM ar_receivable_applications_all app
1558: WHERE app.receivable_application_id = p_rcv_app_id
1559: AND app.status = 'APP';
1560:
1561:

Line 2029: FROM ar_receivable_applications app,

2025:
2026: CURSOR c_invalid_distributions
2027: IS
2028: SELECT distinct app.receivable_application_id rcv_app_id
2029: FROM ar_receivable_applications app,
2030: psa_mf_rct_dist_all mf_dist
2031: WHERE app.receivable_application_id = mf_dist.receivable_application_id
2032: AND (NOT(app.status = 'APP'));
2033: -- Commented out by RM to fix 1604281