DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 450: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

446: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
447: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
448: p_from_date IN DATE ,
449: p_to_date IN DATE ,
450: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
451: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
452: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
453: p_process_flag OUT NOCOPY VARCHAR2 ,
454: p_process_message OUT NOCOPY VARCHAR2,

Line 499: ra_customer_trx_all trx ,

495: jtrxtl.base_tax_amount ,
496: decode(upper(trx_types.type),cp_invoice_type,nvl(jtc.mod_cr_percentage,0),100) mod_cr_percentage ,
497: jtrxtl.link_to_cust_trx_line_id
498: FROM
499: ra_customer_trx_all trx ,
500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,

Line 663: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

659: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
660: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
661: p_from_date IN DATE ,
662: p_to_date IN DATE ,
663: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
664: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
665: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
666: p_process_flag OUT NOCOPY VARCHAR2 ,
667: p_process_message OUT NOCOPY VARCHAR2

Line 690: || in the ra_customer_trx_all table.

686:
687: /*
688: || Get all the cm's which exist in the reference table jai_rgm_trx_refs and have been incompleted/incompleted and deleted from AR base table
689: || IF a CM has been incompleted then it would exist with complete_flag = 'N' . if a CM has been incompleted and deleted then it would not exist
690: || in the ra_customer_trx_all table.
691: */
692: CURSOR c_get_incompleted_cm
693: IS
694: SELECT

Line 707: ra_customer_trx_all trx ,

703: nvl(rgtr.recovered_amount,0) <> 0 AND
704: NOT EXISTS ( SELECT
705: 1
706: FROM
707: ra_customer_trx_all trx ,
708: ra_cust_trx_types_all trx_types
709: WHERE
710: trx.customer_trx_id = rgtr.invoice_id AND
711: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND

Line 1133: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

1129: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1130: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1131: p_from_date IN DATE ,
1132: p_to_date IN DATE ,
1133: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1134: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1135: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1136: p_process_flag OUT NOCOPY VARCHAR2 ,
1137: p_process_message OUT NOCOPY VARCHAR2

Line 1197: ra_customer_trx_all cm_trx ,

1193: inv_jtrx.organization_id inv_invn_organization_id ,
1194: cm_jtrx.organization_id cm_invn_organization_id
1195: FROM
1196: ar_receivable_applications_all aral ,
1197: ra_customer_trx_all cm_trx ,
1198: ra_customer_trx_all inv_trx ,
1199: ra_cust_trx_types_all trx_types ,
1200: JAI_AR_TRXS inv_jtrx ,
1201: JAI_AR_TRXS cm_jtrx

Line 1198: ra_customer_trx_all inv_trx ,

1194: cm_jtrx.organization_id cm_invn_organization_id
1195: FROM
1196: ar_receivable_applications_all aral ,
1197: ra_customer_trx_all cm_trx ,
1198: ra_customer_trx_all inv_trx ,
1199: ra_cust_trx_types_all trx_types ,
1200: JAI_AR_TRXS inv_jtrx ,
1201: JAI_AR_TRXS cm_jtrx
1202: WHERE

Line 1314: cp_inv_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1310: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
1311:
1312: */
1313: CURSOR c_get_refinvrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1314: cp_inv_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1315: )
1316: IS
1317: SELECT
1318: reference_id ,

Line 1335: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1331: FOR UPDATE NOWAIT ;
1332:
1333:
1334: CURSOR c_get_refcmrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1335: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1336: )
1337: IS
1338: SELECT
1339: reference_id ,

Line 1357: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1353: /*
1354: || Get the total effective CM amount from the CM lines in reference table against which a CM application has to be recovered.
1355: */
1356: CURSOR c_get_cmref_totrd_amt ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1357: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1358: )
1359: IS
1360: SELECT
1361: nvl(sum(recoverable_amount - recovered_amount),0) tot_effcm_rb_amt

Line 1851: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

1847: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1848: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1849: p_from_date IN DATE ,
1850: p_to_date IN DATE ,
1851: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1852: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1853: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1854: p_process_flag OUT NOCOPY VARCHAR2 ,
1855: p_process_message OUT NOCOPY VARCHAR2

Line 1909: ra_customer_trx_all trx ,

1905: jtrx.organization_id inv_organization_id
1906: FROM
1907: ar_receivable_applications_all aral ,
1908: ar_cash_receipts_all acrl ,
1909: ra_customer_trx_all trx ,
1910: ra_cust_trx_types_all trx_types ,
1911: JAI_AR_TRXS jtrx
1912: WHERE
1913: aral.cash_receipt_id = acrl.cash_receipt_id AND

Line 2002: cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1998: /*
1999: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
2000: */
2001: CURSOR c_get_refrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
2002: cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
2003: )
2004: IS
2005: SELECT
2006: reference_id ,

Line 2343: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

2339: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
2340: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2341: p_from_date IN DATE ,
2342: p_to_date IN DATE ,
2343: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
2344: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
2345: p_process_flag OUT NOCOPY VARCHAR2 ,
2346: p_process_message OUT NOCOPY VARCHAR2 ,
2347: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/