APPS.PSA_MFAR_RECEIPTS dependencies on PSA_MF_RCT_DIST_ALL

Line 241: -- If psa_mf_rct_dist_all does not have corresponding records,

237: --
238: -- Each receipt application has a unique receivable_application_id.
239: -- Any change to the receipt application (ccid/amount/discount/...)
240: -- will create a record with a new receivable_application_id.
241: -- If psa_mf_rct_dist_all does not have corresponding records,
242: -- multi-fund distributions are either not created or invalid.
243: --
244:
245: --

Line 543: FROM psa_mf_rct_dist_all rct

539: -- ========================= FND LOG ===========================
540:
541: SELECT count(rct.receivable_application_id)
542: INTO l_rct_dist_count
543: FROM psa_mf_rct_dist_all rct
544: WHERE rct.receivable_application_id = p_receivable_app_id;
545:
546: -- ========================= FND LOG ===========================
547: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid -> l_rct_dist_count ' || l_rct_dist_count);

Line 595: FROM psa_mf_rct_dist_all rct

591: -- ========================= FND LOG ===========================
592:
593: SELECT count(rct.receivable_application_id)
594: INTO l_rct_dist_count
595: FROM psa_mf_rct_dist_all rct
596: WHERE rct.receivable_application_id = p_receivable_app_id;
597:
598: -- ========================= FND LOG ===========================
599: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount -> ' || p_amount );

Line 685: FROM psa_mf_rct_dist_all

681:
682: CURSOR c_remit_reversal_account(p_gl_dist_id IN NUMBER) IS
683: SELECT
684: mf_cash_ccid
685: FROM psa_mf_rct_dist_all
686: WHERE receivable_application_id = p_rcv_app_id
687: AND cust_trx_line_gl_dist_id = p_gl_dist_id;
688: -- AND reference1 = 'REMITTED';
689: /*

Line 730: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;

726: */
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);

Line 1257: -- Insert into psa_mf_rct_dist_all

1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1254: -- ========================= FND LOG ===========================
1255:
1256: --
1257: -- Insert into psa_mf_rct_dist_all
1258: --
1259:
1260: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW
1261: (

Line 1374: FROM psa_mf_rct_dist_all

1370:
1371: CURSOR c_remit_reversal_account(p_gl_dist_id IN NUMBER) IS
1372: SELECT
1373: mf_cash_ccid
1374: FROM psa_mf_rct_dist_all
1375: WHERE receivable_application_id = p_rcv_app_id
1376: AND cust_trx_line_gl_dist_id = p_gl_dist_id;
1377:
1378: -- l_accrual_rec c_accrual%rowtype;

Line 1380: p_ccid psa_mf_rct_dist_all.mf_cash_ccid%type;

1376: AND cust_trx_line_gl_dist_id = p_gl_dist_id;
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);

Line 1911: -- Insert into psa_mf_rct_dist_all

1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1908: -- ========================= FND LOG ===========================
1909:
1910: --
1911: -- Insert into psa_mf_rct_dist_all
1912: --
1913:
1914: IF l_count = 1 THEN
1915:

Line 2030: psa_mf_rct_dist_all mf_dist

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
2034: -- OR not(app.display = 'Y')

Line 2057: DELETE FROM psa_mf_rct_dist_all

2053: -- ========================= FND LOG ===========================
2054: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> deleting ' || l_invalid_distributions_rec.rcv_app_id);
2055: -- ========================= FND LOG ===========================
2056:
2057: DELETE FROM psa_mf_rct_dist_all
2058: WHERE receivable_application_id = l_invalid_distributions_rec.rcv_app_id;
2059:
2060: -- ========================= FND LOG ===========================
2061: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> rows ' || SQL%ROWCOUNT);