[Home] [Help]
129: + If there are multiple applications and unapplication, repository entries
130: are corrupt
131: Fix:
132: + JAI_RGM_TRX_RECORDS is populated based on line_applied and tax_applied columns
133: in AR_RECEIVABLE_APPLICATIONS_ALL. In case of currency difference between Invoice and
134: Receipt, the Invoice currency is used to populate AR_RECEIVABLE_APPLICATIONS_ALL.
135: This was not considered when calculating Transaction Amount.
136: Multiplied by Invoice Exchange Rate if Invoice is in foreign currency or divided
137: by Receipt/Credit Memo exchange rate if Receipt/CM is in foreign currency.
130: are corrupt
131: Fix:
132: + JAI_RGM_TRX_RECORDS is populated based on line_applied and tax_applied columns
133: in AR_RECEIVABLE_APPLICATIONS_ALL. In case of currency difference between Invoice and
134: Receipt, the Invoice currency is used to populate AR_RECEIVABLE_APPLICATIONS_ALL.
135: This was not considered when calculating Transaction Amount.
136: Multiplied by Invoice Exchange Rate if Invoice is in foreign currency or divided
137: by Receipt/Credit Memo exchange rate if Receipt/CM is in foreign currency.
138: + If there are multiple applications and unapplication, repository entries
537: p_error_flag := jai_constants.unexpected_error;
538: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
539: END get_regime_info;
540:
541: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
540:
541: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
546: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
547: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
548: p_process_flag OUT NOCOPY VARCHAR2 ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
546: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
547: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
548: p_process_flag OUT NOCOPY VARCHAR2 ,
549: p_process_message OUT NOCOPY VARCHAR2
550: )
601: SELECT
602: nvl(tax_ediscounted,0) tax_ediscounted ,
603: nvl(tax_uediscounted,0) tax_uediscounted
604: FROM
605: ar_receivable_applications_all
606: WHERE
607: receivable_application_id = p_receivable_application_id AND
608: org_id = p_org_id;
609:
1191: p_process_message OUT NOCOPY VARCHAR2
1192: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)
1193: IS
1194:
1195: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1196: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1197: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
1198: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
1199: ln_err_cm_customer_trx_id JAI_RGM_TRX_REFS.INVOICE_ID%TYPE ;
1690: p_process_message OUT NOCOPY VARCHAR2
1691: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
1692: IS
1693:
1694: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1695: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
1696: ln_cm_ref_upd JAI_RGM_TRX_REFS.RECOVERED_AMOUNT%TYPE ;
1697: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1698: lv_source_trx_type VARCHAR2(50) ;
1703: ln_cm_ref_ratio NUMBER ;
1704: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
1705: -- Added ln_func_amount for Bug 7522584
1706: ln_func_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
1707: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE := -1 ;
1708: lv_process_flag VARCHAR2(2) ;
1709: lv_process_message VARCHAR2(1996) ;
1710: ln_uncommitted_transactions NUMBER(10) := 0 ;
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1708: lv_process_flag VARCHAR2(2) ;
1709: lv_process_message VARCHAR2(1996) ;
1710: ln_uncommitted_transactions NUMBER(10) := 0 ;
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1709: lv_process_message VARCHAR2(1996) ;
1710: ln_uncommitted_transactions NUMBER(10) := 0 ;
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1717: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1717: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1718:
1719: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
1760: inv_trx.exchange_date invoice_exchange_date ,
1761: inv_trx.exchange_rate_type invoice_exchange_rate_type
1762: -- Added for Bug 8294236 - End
1763: FROM
1764: ar_receivable_applications_all aral ,
1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
2112: */
2113: /* ln_amount := abs(ln_eff_cm_tax_amount) * ln_sign_of_credit_memo ; */
2114: ln_amount := abs(ln_eff_cm_tax_amount) ;
2115: /*Bug 10623735
2116: If Invoice and Credit Memo currency are different, data in AR_RECEIVABLE_APPLICATIONS_ALL is populated
2117: in Invoice Currency. Hence the same cannot be passed as Transaction Amount in JAI_RGM_TRX_RECORDS
2118: Transaction Amount Data in JAI_RGM_TRX_RECORDS must be in Credit Memo Currency for CM Application Event.
2119: Hence multiplied by Invoice Exchange Rate if Invoice is in foreign currency and divided
2120: by CM Exchange Rate if CM is in foreign currency
2464: p_organization_id => ln_organization_id ,
2465: p_location_id => ln_location_id ,
2466: p_source => p_source ,
2467: p_source_trx_type => lv_source_trx_type ,
2468: p_source_table_name => 'AR_RECEIVABLE_APPLICATIONS_ALL' ,
2469: p_source_document_id => rec_c_get_cm_rec_app.receivable_application_id ,
2470: p_transaction_date => rec_c_get_cm_rec_app.cm_transaction_date ,
2471: p_account_name => NULL ,
2472: p_charge_account_id => NULL ,
2560: p_process_message OUT NOCOPY VARCHAR2
2561: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
2562: IS
2563:
2564: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
2565: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
2566: ln_eff_cr_disc_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ;
2567: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
2568: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
2561: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
2562: IS
2563:
2564: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
2565: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
2566: ln_eff_cr_disc_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ;
2567: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
2568: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
2569: -- Added for Bug 7522584
2562: IS
2563:
2564: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
2565: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
2566: ln_eff_cr_disc_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ;
2567: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
2568: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
2569: -- Added for Bug 7522584
2570: ln_func_tax_amt NUMBER ;
2574: lv_attribute_context VARCHAR2(50) ;
2575: ln_uncommitted_transactions NUMBER(10) := 0 ;
2576: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
2577: ln_location_id NUMBER(15);/*5879769*/
2578: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
2579: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980
2580:
2581: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
2582: ln_line_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07
2624: trx.exchange_date invoice_exchange_date ,
2625: trx.exchange_rate_type invoice_exchange_rate_type
2626: -- Added for Bug 8294236
2627: FROM
2628: ar_receivable_applications_all aral ,
2629: ar_cash_receipts_all acrl ,
2630: ra_customer_trx_all trx ,
2631: ra_cust_trx_types_all trx_types ,
2632: JAI_AR_TRXS jtrx
3184:
3185:
3186: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
3187: /*Bug 10623735
3188: If Invoice and Receipt currency are different, data in AR_RECEIVABLE_APPLICATIONS_ALL is populated
3189: in Invoice Currency. Hence the same cannot be passed as Transaction Amount in JAI_RGM_TRX_RECORDS
3190: Transaction Amount Data in JAI_RGM_TRX_RECORDS must be in Receipt Currency for Receipt Application Event.
3191: Hence multiplied by Invoice Exchange Rate if Invoice is in foreign currency and divided
3192: by Receipt Exchange Rate if Receipt is in foreign currency
3295: p_organization_id => ln_organization_id ,
3296: p_location_id => ln_location_id ,
3297: p_source => p_source ,
3298: p_source_trx_type => lv_source_trx_type ,
3299: p_source_table_name => 'AR_RECEIVABLE_APPLICATIONS_ALL' ,
3300: p_source_document_id => rec_c_get_rec_app.receivable_application_id ,
3301: p_transaction_date => rec_c_get_rec_app.receipt_date ,
3302: p_account_name => NULL ,
3303: p_charge_account_id => NULL ,
3576: AND jsir.date_of_reversal BETWEEN p_from_date AND p_to_date;
3577:
3578: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS
3579: SELECT nvl(amount_applied, 0) claim_amt, receivable_application_id, gl_date
3580: FROM ar_receivable_applications_all araa
3581: WHERE araa.applied_customer_trx_id = pn_invoice_id
3582: AND araa.receivable_application_id > nvl(pn_max_payment_id, 0)
3583: AND trunc(araa.apply_date) <= p_to_date
3584: AND araa.status = 'APP'
3583: AND trunc(araa.apply_date) <= p_to_date
3584: AND araa.status = 'APP'
3585: AND NOT EXISTS (SELECT 1
3586: FROM jai_rgm_trx_records jrtr
3587: WHERE jrtr.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
3588: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
3589: AND jrtr.source = 'AR_CLAIM'
3590: AND jrtr.source_document_id = araa.receivable_application_id)
3591: AND EXISTS (SELECT 1
3731: nvl(araa.unearned_discount_taken, 0))) discount_amount
3732: , acra.set_of_books_id
3733: --Added by Qinglei on 05-Jan-2012 for bug#13556198
3734: FROM
3735: ar_receivable_applications_all araa
3736: , ar_cash_receipts_all acra
3737: , jai_ar_cash_receipts_all jcra
3738: , ra_customer_trx_all trx
3739: WHERE araa.applied_customer_trx_id = trx.customer_trx_id
3752: AND NOT EXISTS (SELECT 1
3753: FROM jai_rgm_trx_records rgtr
3754: WHERE rgtr.source = 'AR'
3755: AND rgtr.organization_id = p_organization_id
3756: AND rgtr.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
3757: AND rgtr.source_trx_type = jai_constants.trx_type_adv_app
3758: AND rgtr.source_document_id = araa.receivable_application_id)
3759: AND EXISTS (SELECT 1
3760: FROM jai_rgm_trx_refs rgtf
3795: --Added by Qinglei on 05-Jan-2012 for bug#13556198
3796: FROM
3797: jai_ar_cash_receipts_all jcra
3798: , ar_cash_receipts_all acra
3799: , ar_receivable_applications_all araa
3800: , ra_customer_trx_all trx
3801: WHERE araa.applied_customer_trx_id = trx.customer_trx_id
3802: AND araa.cash_receipt_id = acra.cash_receipt_id
3803: AND jcra.cash_receipt_id = acra.cash_receipt_id
3814: AND NOT EXISTS (SELECT 1
3815: FROM jai_rgm_trx_records rgtr
3816: WHERE rgtr.source = 'AR'
3817: AND rgtr.organization_id = p_organization_id
3818: AND rgtr.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
3819: AND rgtr.source_trx_type = jai_constants.trx_type_adv_unapp
3820: AND rgtr.source_document_id = araa.receivable_application_id )
3821: AND EXISTS (SELECT 1
3822: FROM jai_rgm_trx_refs rgtf
4108: p_location_id => ln_location_id,
4109: p_service_type_code => lv_service_type_code,
4110: p_source => 'AR_CLAIM',
4111: p_source_trx_type => 'CLAIM_ACCOUNTING',
4112: p_source_table_name => 'AR_RECEIVABLE_APPLICATIONS_ALL',
4113: p_source_document_id => rec_claim_line.receivable_application_id,
4114: p_transaction_date => ld_accounting_date,
4115: p_account_name => NULL,
4116: p_charge_account_id => NULL,
4351: FETCH c_rcpt_ref_records INTO lr_ar_ref_records;
4352: CLOSE c_rcpt_ref_records;
4353:
4354: /*
4355: If Invoice and Receipt currency are different, data in AR_RECEIVABLE_APPLICATIONS_ALL is populated
4356: in Invoice Currency. Hence the same cannot be passed as Transaction Amount in JAI_RGM_TRX_RECORDS
4357: Transaction Amount Data in JAI_RGM_TRX_RECORDS must be in Receipt Currency for Receipt Application Event.
4358: */
4359: ln_tax_amount := -ROUND(ABS(rec_receipt_entries.func_tax_amt
4392: p_location_id => ln_location_id,
4393: p_service_type_code => lv_service_type_code,
4394: p_source => 'AR',
4395: p_source_trx_type => jai_constants.trx_type_adv_app,
4396: p_source_table_name => 'AR_RECEIVABLE_APPLICATIONS_ALL',
4397: p_source_document_id => rec_c_receipts_application.receivable_application_id,
4398: p_transaction_date => rec_c_receipts_application.gl_date,
4399: p_account_name => NULL,
4400: p_charge_account_id => NULL,
4456: FETCH c_rcpt_ref_records INTO lr_ar_ref_records;
4457: CLOSE c_rcpt_ref_records;
4458:
4459: /*
4460: If Invoice and Receipt currency are different, data in AR_RECEIVABLE_APPLICATIONS_ALL is populated
4461: in Invoice Currency. Hence the same cannot be passed as Transaction Amount in JAI_RGM_TRX_RECORDS
4462: Transaction Amount Data in JAI_RGM_TRX_RECORDS must be in Receipt Currency for Receipt Application Event.
4463: */
4464: ln_tax_amount := ROUND(ABS(rec_receipt_entries.func_tax_amt
4499: p_location_id => ln_location_id,
4500: p_service_type_code => lv_service_type_code,
4501: p_source => 'AR',
4502: p_source_trx_type => jai_constants.trx_type_adv_unapp,
4503: p_source_table_name => 'AR_RECEIVABLE_APPLICATIONS_ALL',
4504: p_source_document_id => rec_c_receipts_unapplication.receivable_application_id,
4505: p_transaction_date => rec_c_receipts_unapplication.gl_date,
4506: p_account_name => NULL,
4507: p_charge_account_id => NULL,
4560: AND jsir.tax_to_be_adjusted > 0;
4561:
4562: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS
4563: SELECT nvl(amount_applied, 0) claim_amt, receivable_application_id, gl_date
4564: FROM ar_receivable_applications_all araa
4565: WHERE araa.applied_customer_trx_id = pn_invoice_id
4566: AND araa.apply_date <= pd_to_date
4567: AND araa.status = 'APP'
4568: AND araa.receivable_application_id > nvl(pn_max_payment_id, 0)
4567: AND araa.status = 'APP'
4568: AND araa.receivable_application_id > nvl(pn_max_payment_id, 0)
4569: AND NOT EXISTS (SELECT 1
4570: FROM jai_rgm_trx_records jrtr
4571: WHERE jrtr.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4572: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4573: AND jrtr.source = 'AR_CLAIM'
4574: AND jrtr.source_document_id = araa.receivable_application_id)
4575: AND EXISTS (SELECT 1
4894: --========================================================================
4895: -- PROCEDURE : process_st_advance_receipts PUBLIC
4896: -- PARAMETERS: p_event current event name
4897: -- : p_acra rowtype of ar_cash_receipts_all
4898: -- : p_araa rowtype of ar_receivable_applications_all
4899: -- : p_process_flag the process result
4900: -- : p_process_message the process message
4901: -- COMMENT : process service tax on advance receipt according to event
4902: -- PRE-COND : AR Receipt must attach service tax
4905: --========================================================================
4906: PROCEDURE process_st_advance_receipts
4907: ( p_event IN VARCHAR2
4908: ,p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default NULL
4909: ,p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default NULL
4910: ,p_process_flag OUT NOCOPY VARCHAR2
4911: ,p_process_message OUT NOCOPY VARCHAR2
4912: )
4913: IS
5051:
5052: --========================================================================
5053: -- PROCEDURE : generate_docuements PUBLIC
5054: -- PARAMETERS: p_acra rowtype of ar_cash_receipts_all
5055: -- : p_araa rowtype of ar_receivable_applications_all
5056: -- : p_document_type
5057: -- : p_process_flag the process result
5058: -- : p_process_message the process message
5059: -- COMMENT : generate documents accroding to document type and inclusive
5063: --
5064: --========================================================================
5065: PROCEDURE generate_documents
5066: ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE
5067: ,p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null
5068: ,p_document_type IN VARCHAR2
5069: ,p_process_flag OUT NOCOPY VARCHAR2
5070: ,p_process_message OUT NOCOPY VARCHAR2
5071: )
5743: --========================================================================
5744: -- PROCEDURE : generate_gl_entry PUBLIC
5745: -- PARAMETERS: p_jacr rowtype of jai_ar_cash_receipts_all
5746: -- : p_acra rowtype of ar_cash_receipts_all
5747: -- : p_araa rowtype of ar_receivable_applications_all
5748: -- : p_document_type
5749: -- : p_regime_id
5750: -- : pn_organization_id
5751: -- : pn_location_id
5761: --========================================================================
5762: PROCEDURE generate_gl_entry
5763: ( p_jacr IN JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE
5764: ,p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE
5765: ,p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL
5766: ,p_document_type IN VARCHAR2
5767: ,pn_regime_id IN NUMBER
5768: ,pn_organization_id IN NUMBER
5769: ,pn_location_id IN NUMBER
5871: ELSE
5872: ln_accounted_amt := ln_accounted_amt;
5873: lv_repository_name := 'receivable_application_id';
5874: lv_call_from := 'UNAPPLY_ACCOUNTING';
5875: lv_source_table_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5876: ln_source_document_id := p_araa.RECEIVABLE_APPLICATION_ID;
5877: ld_gl_date := p_araa.gl_date;
5878: ld_transaction_date := p_araa.APPLY_DATE;
5879: lv_reference_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5875: lv_source_table_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5876: ln_source_document_id := p_araa.RECEIVABLE_APPLICATION_ID;
5877: ld_gl_date := p_araa.gl_date;
5878: ld_transaction_date := p_araa.APPLY_DATE;
5879: lv_reference_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5880: ln_reference_id := p_araa.RECEIVABLE_APPLICATION_ID;
5881: lv_attribute1 := to_char(p_araa.CASH_RECEIPT_ID);
5882: lv_attribute2 := to_char(p_araa.CUSTOMER_TRX_ID);
5883: END IF;
5909: lv_attribute1 := p_acra.RECEIPT_NUMBER;
5910: ELSE
5911: lv_repository_name := 'receivable_application_id';
5912: lv_call_from := 'APPLY_ACCOUNTING';
5913: lv_source_table_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5914: ln_source_document_id := p_araa.RECEIVABLE_APPLICATION_ID;
5915: ld_gl_date := p_araa.gl_date;
5916: ld_transaction_date := p_araa.APPLY_DATE;
5917: lv_reference_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5913: lv_source_table_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5914: ln_source_document_id := p_araa.RECEIVABLE_APPLICATION_ID;
5915: ld_gl_date := p_araa.gl_date;
5916: ld_transaction_date := p_araa.APPLY_DATE;
5917: lv_reference_name := 'AR_RECEIVABLE_APPLICATIONS_ALL';
5918: ln_reference_id := p_araa.RECEIVABLE_APPLICATION_ID;
5919: lv_attribute1 := to_char(p_araa.CASH_RECEIPT_ID);
5920: lv_attribute2 := to_char(p_araa.CUSTOMER_TRX_ID);
5921: END IF;
6043: END validate_receipts;
6044:
6045: --========================================================================
6046: -- PROCEDURE : generate_gl_entry PUBLIC
6047: -- PARAMETERS: p_araa rowtype of ar_receivable_applications_all
6048: -- : p_document_type
6049: -- : p_process_flag the process result
6050: -- : p_process_message the process message
6051: -- COMMENT : validate if current receipt attached sercice tax and determine
6054: -- EXCEPTIONS:
6055: --
6056: --========================================================================
6057: PROCEDURE validate_app_unapp
6058: ( p_araa IN ar_receivable_applications_all%ROWTYPE
6059: ,p_document_type OUT NOCOPY VARCHAR2
6060: ,p_process_flag OUT NOCOPY VARCHAR2
6061: ,p_process_message OUT NOCOPY VARCHAR2)
6062: IS