eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 923: FROM ar_cash_receipts_all acra,

919: nvl(jtc.mod_cr_percentage,0) mod_cr_percentage ,
920: jdt.tax_amt tax_amount,
921: jdt.func_tax_amt,
922: acra.amount receipt_amount
923: FROM ar_cash_receipts_all acra,
924: jai_ar_cash_receipts_all jcra,
925: jai_cmn_document_taxes jdt ,
926: JAI_CMN_TAXES_ALL jtc ,
927: jai_regime_tax_types_v jrttv

Line 924: jai_ar_cash_receipts_all jcra,

920: jdt.tax_amt tax_amount,
921: jdt.func_tax_amt,
922: acra.amount receipt_amount
923: FROM ar_cash_receipts_all acra,
924: jai_ar_cash_receipts_all jcra,
925: jai_cmn_document_taxes jdt ,
926: JAI_CMN_TAXES_ALL jtc ,
927: jai_regime_tax_types_v jrttv
928: WHERE acra.cash_receipt_id = jcra.cash_receipt_id

Line 2629: ar_cash_receipts_all acrl ,

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
2633: WHERE

Line 3612: jai_ar_cash_receipts_all jcra

3608: , jcra.service_type_code
3609: , jcra.exchange_rate
3610: , jcra.exchange_rate_type
3611: FROM
3612: jai_ar_cash_receipts_all jcra
3613: , ar_cash_receipts_all acra
3614: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3615: AND jcra.confirm_flag = 'Y'
3616: AND jcra.document_type = 'Service'

Line 3613: , ar_cash_receipts_all acra

3609: , jcra.exchange_rate
3610: , jcra.exchange_rate_type
3611: FROM
3612: jai_ar_cash_receipts_all jcra
3613: , ar_cash_receipts_all acra
3614: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3615: AND jcra.confirm_flag = 'Y'
3616: AND jcra.document_type = 'Service'
3617: --AND acra.reversal_date IS NULL

Line 3625: AND rgtr.source_table_name = 'AR_CASH_RECEIPTS_ALL'

3621: AND NOT EXISTS (SELECT 1
3622: FROM jai_rgm_trx_records rgtr
3623: WHERE rgtr.source = 'AR'
3624: AND rgtr.organization_id = p_organization_id
3625: AND rgtr.source_table_name = 'AR_CASH_RECEIPTS_ALL'
3626: AND rgtr.source_trx_type = jai_constants.trx_type_adv_rcpts
3627: AND rgtr.source_document_id = jcra.cash_receipt_id)
3628: AND EXISTS (SELECT 1
3629: FROM jai_rgm_trx_refs rgtf

Line 3640: , jai_ar_cash_receipts_all jacr

3636: jdt.tax_type,
3637: jdt.tax_amt,
3638: jdt.func_tax_amt
3639: FROM jai_cmn_document_taxes jdt
3640: , jai_ar_cash_receipts_all jacr
3641: , jai_cmn_taxes_all jcta
3642: , jai_regime_tax_types_v jrttv
3643: WHERE jacr.cash_receipt_id = cn_cash_receipt_id
3644: AND jdt.source_doc_id = jacr.cash_receipt_id

Line 3671: jai_ar_cash_receipts_all jcra

3667: , jcra.service_type_code
3668: , jcra.exchange_rate
3669: , jcra.exchange_rate_type
3670: FROM
3671: jai_ar_cash_receipts_all jcra
3672: , ar_cash_receipts_all acra
3673: , ar_cash_receipt_history_all acrh --Added by Qiong for bug13555753
3674: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3675: AND jcra.confirm_flag = 'Y'

Line 3672: , ar_cash_receipts_all acra

3668: , jcra.exchange_rate
3669: , jcra.exchange_rate_type
3670: FROM
3671: jai_ar_cash_receipts_all jcra
3672: , ar_cash_receipts_all acra
3673: , ar_cash_receipt_history_all acrh --Added by Qiong for bug13555753
3674: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3675: AND jcra.confirm_flag = 'Y'
3676: AND jcra.document_type = 'Service'

Line 3692: AND rgtr.source_table_name = 'AR_CASH_RECEIPTS_ALL'

3688: AND NOT EXISTS (SELECT 1
3689: FROM jai_rgm_trx_records rgtr
3690: WHERE rgtr.source = 'AR'
3691: AND rgtr.organization_id = p_organization_id
3692: AND rgtr.source_table_name = 'AR_CASH_RECEIPTS_ALL'
3693: AND rgtr.source_trx_type = jai_constants.trx_type_adv_rvs
3694: --Modified jai_constants.trx_type_rct_rvs to jai_constants.trx_type_adv_rvs
3695: --by Qinglei on 24-Dec-2012 for bug#13741544
3696: AND rgtr.source_document_id = jcra.cash_receipt_id)

Line 3736: , ar_cash_receipts_all acra

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
3740: AND araa.cash_receipt_id = acra.cash_receipt_id

Line 3737: , jai_ar_cash_receipts_all jcra

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
3740: AND araa.cash_receipt_id = acra.cash_receipt_id
3741: AND jcra.cash_receipt_id = acra.cash_receipt_id

Line 3797: jai_ar_cash_receipts_all jcra

3793: nvl(araa.unearned_discount_taken, 0))) discount_amount
3794: , acra.set_of_books_id
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

Line 3798: , ar_cash_receipts_all acra

3794: , acra.set_of_books_id
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

Line 4199: p_source_table_name => 'AR_CASH_RECEIPTS_ALL',

4195: p_location_id => ln_location_id,
4196: p_service_type_code => lv_service_type_code,
4197: p_source => 'AR',
4198: p_source_trx_type => jai_constants.trx_type_adv_rcpts,
4199: p_source_table_name => 'AR_CASH_RECEIPTS_ALL',
4200: p_source_document_id => rec_c_ar_receipts.cash_receipt_id,
4201: p_transaction_date => ld_gl_date,
4202: p_account_name => NULL,
4203: p_charge_account_id => NULL,

Line 4291: p_source_table_name => 'AR_CASH_RECEIPTS_ALL',

4287: p_source => 'AR',
4288: p_source_trx_type => jai_constants.trx_type_adv_rvs,
4289: --Modified jai_constants.trx_type_rct_rvs to jai_constants.trx_type_adv_rvs
4290: --by Qinglei on 28-Dec-2012 for bug#13741544
4291: p_source_table_name => 'AR_CASH_RECEIPTS_ALL',
4292: p_source_document_id => rec_c_receipts_reversal.cash_receipt_id,
4293: p_transaction_date => ld_gl_date,
4294: p_account_name => NULL,
4295: p_charge_account_id => NULL,

Line 4897: -- : p_acra rowtype of ar_cash_receipts_all

4893: /*Added by Wenqiong for Advanced Receipt on Service Taxes Begin */
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

Line 4908: ,p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default NULL

4904: --
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: )

Line 4915: r_acra ar_cash_receipts_all%ROWTYPE;

4911: ,p_process_message OUT NOCOPY VARCHAR2
4912: )
4913: IS
4914: lv_document_type VARCHAR2(80);
4915: r_acra ar_cash_receipts_all%ROWTYPE;
4916:
4917: CURSOR cur_get_app_cash_receipts(cp_cash_receipt_id NUMBER)
4918: IS
4919: SELECT *

Line 4920: FROM ar_cash_receipts_all

4916:
4917: CURSOR cur_get_app_cash_receipts(cp_cash_receipt_id NUMBER)
4918: IS
4919: SELECT *
4920: FROM ar_cash_receipts_all
4921: WHERE cash_receipt_id = cp_cash_receipt_id;
4922:
4923: BEGIN
4924:

Line 5054: -- PARAMETERS: p_acra rowtype of ar_cash_receipts_all

5050: END process_st_advance_receipts;
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

Line 5066: ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE

5062: -- EXCEPTIONS:
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

Line 5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

5072: IS
5073: /*****
5074: || Get the details of the cash_receipts
5075: *****/
5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
5077: IS
5078: SELECT *
5079: FROM
5080: jai_ar_cash_receipts_all jcra

Line 5080: jai_ar_cash_receipts_all jcra

5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
5077: IS
5078: SELECT *
5079: FROM
5080: jai_ar_cash_receipts_all jcra
5081: WHERE
5082: jcra.cash_receipt_id = cp_cash_receipt_id ;
5083:
5084: /*****

Line 5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;

5197: ln_user_id ra_interface_lines_all.CREATED_BY%TYPE;
5198: ln_login_id ra_interface_lines_all.LAST_UPDATE_LOGIN%TYPE;
5199: lv_process_message VARCHAR2(4000);
5200:
5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;
5202: rec_cur_get_rcpt_taxes cur_get_rcpt_taxes%ROWTYPE;
5203: rec_ra_interface_lines ra_interface_lines_all%ROWTYPE;
5204: rec_ra_interface_dist ra_interface_distributions_all%ROWTYPE;
5205: ln_rcpt_amount NUMBER;

Line 5745: -- PARAMETERS: p_jacr rowtype of jai_ar_cash_receipts_all

5741: END generate_cm_dm;
5742:
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

Line 5746: -- : p_acra rowtype of ar_cash_receipts_all

5742:
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

Line 5763: ( p_jacr IN JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE

5759: -- EXCEPTIONS:
5760: --
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

Line 5764: ,p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE

5760: --
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

Line 5864: lv_source_table_name := 'AR_CASH_RECEIPTS_ALL';

5860: --Changed by Qiong from ar_cash_tax_confirmed to trx_type_adv_rcpts for bug13569249
5861: THEN
5862: lv_repository_name := 'cash_receipt_id';
5863: lv_call_from := 'CONFIRM_ACCOUNTING';
5864: lv_source_table_name := 'AR_CASH_RECEIPTS_ALL';
5865: ln_source_document_id := p_jacr.cash_receipt_id;
5866: ld_transaction_date := p_jacr.CONFIRM_DATE;
5867: ld_gl_date := p_jacr.gl_date;
5868: lv_reference_name := jai_constants.jai_cash_rcpts;

Line 5902: lv_source_table_name := 'AR_CASH_RECEIPTS_ALL';

5898: CLOSE cur_get_rcpt_reversal_gl_date;
5899: /*Added by Qinglei on 12-Jan-2012 for bug#13569242 end*/
5900: lv_repository_name := 'cash_receipt_id';
5901: lv_call_from := 'REVERSE_ACCOUNTING';
5902: lv_source_table_name := 'AR_CASH_RECEIPTS_ALL';
5903: ln_source_document_id := p_jacr.cash_receipt_id;
5904: ld_transaction_date := p_acra.reversal_date;
5905: --ld_gl_date := p_acra.reversal_date;
5906: /*Commented by Qinglei on 12-Jan-2012 for bug#13569242*/

Line 5992: -- PARAMETERS: p_acra rowtype of ar_cash_receipts_all

5988: END generate_gl_entry;
5989:
5990: --========================================================================
5991: -- PROCEDURE : generate_gl_entry PUBLIC
5992: -- PARAMETERS: p_acra rowtype of ar_cash_receipts_all
5993: -- : p_document_type
5994: -- : p_process_flag the process result
5995: -- : p_process_message the process message
5996: -- COMMENT : validate if current receipt attached service tax

Line 6002: ( p_acra IN ar_cash_receipts_all%ROWTYPE

5998: -- EXCEPTIONS:
5999: --
6000: --========================================================================
6001: PROCEDURE validate_receipts
6002: ( p_acra IN ar_cash_receipts_all%ROWTYPE
6003: ,p_document_type IN VARCHAR2
6004: ,p_process_flag OUT NOCOPY VARCHAR2
6005: ,p_process_message OUT NOCOPY VARCHAR2)
6006: IS

Line 6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6010:
6011: /*
6012: || Check that the document has has Service tax.
6013: */
6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6015: IS
6016: SELECT 1
6017: FROM jai_ar_cash_receipts_all jcra,
6018: jai_cmn_document_taxes jdt,

Line 6017: FROM jai_ar_cash_receipts_all jcra,

6013: */
6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6015: IS
6016: SELECT 1
6017: FROM jai_ar_cash_receipts_all jcra,
6018: jai_cmn_document_taxes jdt,
6019: jai_regime_tax_types_v jrttv
6020: WHERE jcra.cash_receipt_id = cp_cash_receipt_id
6021: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 6066: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6062: IS
6063: /*
6064: ||Get the sign of the Cash receipt document
6065: */
6066: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6067: IS
6068: SELECT
6069: sign (nvl(amount,0)) app_fr_sign
6070: FROM

Line 6071: ar_cash_receipts_all

6067: IS
6068: SELECT
6069: sign (nvl(amount,0)) app_fr_sign
6070: FROM
6071: ar_cash_receipts_all
6072: WHERE
6073: cash_receipt_id = cp_cash_receipt_id;
6074:
6075: ln_sign_of_app NUMBER(3);

Line 6086: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6082:
6083: /*
6084: || Check that the document has has Service tax.
6085: */
6086: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6087: IS
6088: SELECT
6089: 1
6090: FROM

Line 6091: jai_ar_cash_receipts_all jcra ,

6087: IS
6088: SELECT
6089: 1
6090: FROM
6091: jai_ar_cash_receipts_all jcra ,
6092: jai_cmn_document_taxes jdt ,
6093: jai_regime_tax_types_v jrttv
6094: WHERE
6095: jcra.cash_receipt_id = cp_cash_receipt_id