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_TCS_REP_PKG dependencies on AR_CASH_RECEIPTS_ALL

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

1870:
1871: /*
1872: ||Get the sign of the Cash receipt document
1873: */
1874: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1875: IS
1876: SELECT
1877: sign (nvl(amount,0)) app_fr_sign
1878: FROM

Line 1879: ar_cash_receipts_all

1875: IS
1876: SELECT
1877: sign (nvl(amount,0)) app_fr_sign
1878: FROM
1879: ar_cash_receipts_all
1880: WHERE
1881: cash_receipt_id = cp_cash_receipt_id;
1882:
1883: /*

Line 1900: CURSOR cur_chk_crtcs_applicable ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

1896:
1897: /*
1898: || Check that the Cash receipt has got TCS type of confirmed taxes
1899: */
1900: CURSOR cur_chk_crtcs_applicable ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1901: IS
1902: SELECT
1903: jcra.item_classification,
1904: acra.amount

Line 1906: ar_cash_receipts_all acra ,

1902: SELECT
1903: jcra.item_classification,
1904: acra.amount
1905: FROM
1906: ar_cash_receipts_all acra ,
1907: jai_ar_cash_receipts_all jcra ,
1908: jai_cmn_document_taxes jdt ,
1909: jai_regime_tax_types_v jrttv
1910: WHERE

Line 1907: jai_ar_cash_receipts_all jcra ,

1903: jcra.item_classification,
1904: acra.amount
1905: FROM
1906: ar_cash_receipts_all acra ,
1907: jai_ar_cash_receipts_all jcra ,
1908: jai_cmn_document_taxes jdt ,
1909: jai_regime_tax_types_v jrttv
1910: WHERE
1911: jcra.cash_receipt_id = acra.cash_receipt_id

Line 1914: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */

1910: WHERE
1911: jcra.cash_receipt_id = acra.cash_receipt_id
1912: AND jcra.cash_receipt_id = cp_cash_receipt_id
1913: AND jcra.cash_receipt_id = jdt.source_doc_id
1914: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
1915: AND jcra.confirm_flag = jai_constants.yes
1916: AND jdt.tax_type = jrttv.tax_type /* Applied to doc has got TCS type of tax*/
1917: AND jrttv.regime_code = jai_constants.tcs_regime
1918: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug

Line 1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

1936:
1937: ln_sign_of_app_fr_doc NUMBER(3) ;
1938: ln_sign_of_app NUMBER(3) ;
1939: lv_exists VARCHAR2(1) ;
1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:

Line 1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1949:
1950: lv_app_doc_type VARCHAR2(100) ;

Line 2371: PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,

2367: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2368:
2369: END validate_app_unapp;
2370:
2371: PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2372: p_document_type IN VARCHAR2 ,
2373: p_process_flag OUT NOCOPY VARCHAR2 ,
2374: p_process_message OUT NOCOPY VARCHAR2
2375: )

Line 2384: CURSOR cur_chk_tcs_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

2380:
2381: /*
2382: || Check that the document has has TCS type of tax.
2383: */
2384: CURSOR cur_chk_tcs_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2385: IS
2386: SELECT
2387: 1
2388: FROM

Line 2389: jai_ar_cash_receipts_all jcra ,

2385: IS
2386: SELECT
2387: 1
2388: FROM
2389: jai_ar_cash_receipts_all jcra ,
2390: jai_cmn_document_taxes jdt ,
2391: jai_regime_tax_types_v jrttv
2392: WHERE
2393: jcra.cash_receipt_id = cp_cash_receipt_id

Line 2836: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,

2832: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2833: END process_invoices;
2834:
2835:
2836: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2837: p_document_type VARCHAR2 ,
2838: p_process_flag OUT NOCOPY VARCHAR2 ,
2839: p_process_message OUT NOCOPY VARCHAR2
2840: )

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

2842: ln_reg_id NUMBER;
2843: /*****
2844: || Get the details of the cash_receipts
2845: *****/
2846: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2847: IS
2848: SELECT
2849: jcra.customer_id ,
2850: jcra.organization_id ,

Line 2854: jai_ar_cash_receipts_all jcra

2850: jcra.organization_id ,
2851: jcra.gl_date ,
2852: jcra.item_classification
2853: FROM
2854: jai_ar_cash_receipts_all jcra
2855: WHERE
2856: jcra.cash_receipt_id = cp_cash_receipt_id ;
2857:
2858: /*****

Line 2891: jai_ar_cash_receipts_all jcra

2887: SELECT
2888: ra.*
2889: FROM
2890: ar_receivable_applications_all ra ,
2891: jai_ar_cash_receipts_all jcra
2892: WHERE
2893: ra.cash_receipt_id = jcra.cash_receipt_id
2894: AND ra.cash_receipt_id = cp_cash_receipt_id
2895: AND ra.status = 'APP'

Line 2906: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */

2902: jai_cmn_document_taxes jdt ,
2903: jai_regime_tax_types_v jrttv
2904: WHERE
2905: jdt.source_doc_id = jcra.cash_receipt_id
2906: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
2907: AND jdt.tax_type = jrttv.tax_type
2908: AND jrttv.regime_code = jai_constants.tcs_regime
2909: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash --added by eric for a bug
2910: )

Line 3333: CURSOR cur_get_cr_details ( cp_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

3329:
3330: /*
3331: ||Get the applied to document cash receipt details
3332: */
3333: CURSOR cur_get_cr_details ( cp_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
3334: IS
3335: SELECT
3336: nvl(acra.amount,0) * nvl(acra.exchange_rate , 1 ) app_fr_doc_amt ,
3337: nvl(acra.exchange_rate,1) exchange_rate ,

Line 3344: ar_cash_receipts_all acra ,

3340: acra.pay_from_customer ,
3341: acra.customer_site_use_id ,
3342: acra.org_id
3343: FROM
3344: ar_cash_receipts_all acra ,
3345: ar_payment_schedules_all arps ,
3346: jai_ar_cash_receipts_all jcra ,
3347: jai_cmn_document_taxes jdt ,
3348: jai_regime_tax_types_v jrttv

Line 3346: jai_ar_cash_receipts_all jcra ,

3342: acra.org_id
3343: FROM
3344: ar_cash_receipts_all acra ,
3345: ar_payment_schedules_all arps ,
3346: jai_ar_cash_receipts_all jcra ,
3347: jai_cmn_document_taxes jdt ,
3348: jai_regime_tax_types_v jrttv
3349: WHERE
3350: acra.cash_receipt_id = arps.cash_receipt_id

Line 3520: ln_app_fr_doc_table := jai_constants.jai_cash_rcpts ; /* table JAI_AR_CASH_RECEIPTS_ALL */

3516: ln_exchange_rate := rec_cur_get_cr_details.exchange_rate ;
3517:
3518: ln_app_fr_doc_id := p_araa.cash_receipt_id ;
3519: ln_app_fr_doc_type := jai_constants.ar_cash_tax_confirmed ; /* Receipt confirmation */
3520: ln_app_fr_doc_table := jai_constants.jai_cash_rcpts ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3521:
3522: ln_fr_organization_id := rec_cur_get_cr_details.app_fr_organization_id ;
3523: ln_fr_party_id := rec_cur_get_cr_details.pay_from_customer ;
3524: ln_fr_party_site_id := rec_cur_get_cr_details.customer_site_use_id ;

Line 3544: ln_app_fr_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_CASH_RECEIPTS_ALL */

3540: ln_exchange_rate := rec_cur_get_cm_details.exchange_rate ;
3541:
3542: ln_app_fr_doc_id := p_araa.customer_trx_id ;
3543: ln_app_fr_doc_type := jai_constants.ar_invoice_type_cm ; /* 'CM' */
3544: ln_app_fr_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3545:
3546: ln_fr_organization_id := rec_cur_get_cm_details.app_to_organization_id ;
3547: ln_fr_party_id := rec_cur_get_cm_details.app_to_customer_id ;
3548: ln_fr_party_site_id := rec_cur_get_cm_details.app_to_customer_site_use_id ;

Line 3805: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,

3801: END process_applications;
3802:
3803:
3804: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3805: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
3806: p_document_type IN VARCHAR2 ,
3807: p_process_flag OUT NOCOPY VARCHAR2 ,
3808: p_process_message OUT NOCOPY VARCHAR2
3809: )

Line 5831: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,

5827: p_event IN VARCHAR2 ,
5828: p_document_type IN VARCHAR2 Default Null ,
5829: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,
5830: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,
5831: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,
5832: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,
5833: p_process_flag OUT NOCOPY VARCHAR2 ,
5834: p_process_message OUT NOCOPY VARCHAR2
5835: )