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 1359: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

1355:
1356: /*
1357: ||Get the sign of the Cash receipt document
1358: */
1359: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1360: IS
1361: SELECT
1362: sign (nvl(amount,0)) app_fr_sign
1363: FROM

Line 1364: ar_cash_receipts_all

1360: IS
1361: SELECT
1362: sign (nvl(amount,0)) app_fr_sign
1363: FROM
1364: ar_cash_receipts_all
1365: WHERE
1366: cash_receipt_id = cp_cash_receipt_id;
1367:
1368: /*

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

1381:
1382: /*
1383: || Check that the Cash receipt has got TCS type of confirmed taxes
1384: */
1385: CURSOR cur_chk_crtcs_applicable ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1386: IS
1387: SELECT
1388: jcra.item_classification,
1389: acra.amount

Line 1391: ar_cash_receipts_all acra ,

1387: SELECT
1388: jcra.item_classification,
1389: acra.amount
1390: FROM
1391: ar_cash_receipts_all acra ,
1392: jai_ar_cash_receipts_all jcra ,
1393: jai_cmn_document_taxes jdt ,
1394: jai_regime_tax_types_v jrttv
1395: WHERE

Line 1392: jai_ar_cash_receipts_all jcra ,

1388: jcra.item_classification,
1389: acra.amount
1390: FROM
1391: ar_cash_receipts_all acra ,
1392: jai_ar_cash_receipts_all jcra ,
1393: jai_cmn_document_taxes jdt ,
1394: jai_regime_tax_types_v jrttv
1395: WHERE
1396: jcra.cash_receipt_id = acra.cash_receipt_id

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

1395: WHERE
1396: jcra.cash_receipt_id = acra.cash_receipt_id
1397: AND jcra.cash_receipt_id = cp_cash_receipt_id
1398: AND jcra.cash_receipt_id = jdt.source_doc_id
1399: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
1400: AND jcra.confirm_flag = jai_constants.yes
1401: AND jdt.tax_type = jrttv.tax_type /* Applied to doc has got TCS type of tax*/
1402: AND jrttv.regime_code = jai_constants.tcs_regime
1403: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug

Line 1425: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

1421:
1422: ln_sign_of_app_fr_doc NUMBER(3) ;
1423: ln_sign_of_app NUMBER(3) ;
1424: lv_exists VARCHAR2(1) ;
1425: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1426: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:

Line 1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1432: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1433: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1434:
1435: lv_app_doc_type VARCHAR2(100) ;

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

1852: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1853:
1854: END validate_app_unapp;
1855:
1856: PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
1857: p_document_type IN VARCHAR2 ,
1858: p_process_flag OUT NOCOPY VARCHAR2 ,
1859: p_process_message OUT NOCOPY VARCHAR2
1860: )

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

1865:
1866: /*
1867: || Check that the document has has TCS type of tax.
1868: */
1869: CURSOR cur_chk_tcs_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1870: IS
1871: SELECT
1872: 1
1873: FROM

Line 1874: jai_ar_cash_receipts_all jcra ,

1870: IS
1871: SELECT
1872: 1
1873: FROM
1874: jai_ar_cash_receipts_all jcra ,
1875: jai_cmn_document_taxes jdt ,
1876: jai_regime_tax_types_v jrttv
1877: WHERE
1878: jcra.cash_receipt_id = cp_cash_receipt_id

Line 2321: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,

2317: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2318: END process_invoices;
2319:
2320:
2321: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2322: p_document_type VARCHAR2 ,
2323: p_process_flag OUT NOCOPY VARCHAR2 ,
2324: p_process_message OUT NOCOPY VARCHAR2
2325: )

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

2327: ln_reg_id NUMBER;
2328: /*****
2329: || Get the details of the cash_receipts
2330: *****/
2331: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2332: IS
2333: SELECT
2334: jcra.customer_id ,
2335: jcra.organization_id ,

Line 2339: jai_ar_cash_receipts_all jcra

2335: jcra.organization_id ,
2336: jcra.gl_date ,
2337: jcra.item_classification
2338: FROM
2339: jai_ar_cash_receipts_all jcra
2340: WHERE
2341: jcra.cash_receipt_id = cp_cash_receipt_id ;
2342:
2343: /*****

Line 2376: jai_ar_cash_receipts_all jcra

2372: SELECT
2373: ra.*
2374: FROM
2375: ar_receivable_applications_all ra ,
2376: jai_ar_cash_receipts_all jcra
2377: WHERE
2378: ra.cash_receipt_id = jcra.cash_receipt_id
2379: AND ra.cash_receipt_id = cp_cash_receipt_id
2380: AND ra.status = 'APP'

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

2387: jai_cmn_document_taxes jdt ,
2388: jai_regime_tax_types_v jrttv
2389: WHERE
2390: jdt.source_doc_id = jcra.cash_receipt_id
2391: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
2392: AND jdt.tax_type = jrttv.tax_type
2393: AND jrttv.regime_code = jai_constants.tcs_regime
2394: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash --added by eric for a bug
2395: )

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

2808:
2809: /*
2810: ||Get the applied to document cash receipt details
2811: */
2812: CURSOR cur_get_cr_details ( cp_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2813: IS
2814: SELECT
2815: nvl(acra.amount,0) * nvl(acra.exchange_rate , 1 ) app_fr_doc_amt ,
2816: nvl(acra.exchange_rate,1) exchange_rate ,

Line 2823: ar_cash_receipts_all acra ,

2819: acra.pay_from_customer ,
2820: acra.customer_site_use_id ,
2821: acra.org_id
2822: FROM
2823: ar_cash_receipts_all acra ,
2824: ar_payment_schedules_all arps ,
2825: jai_ar_cash_receipts_all jcra ,
2826: jai_cmn_document_taxes jdt ,
2827: jai_regime_tax_types_v jrttv

Line 2825: jai_ar_cash_receipts_all jcra ,

2821: acra.org_id
2822: FROM
2823: ar_cash_receipts_all acra ,
2824: ar_payment_schedules_all arps ,
2825: jai_ar_cash_receipts_all jcra ,
2826: jai_cmn_document_taxes jdt ,
2827: jai_regime_tax_types_v jrttv
2828: WHERE
2829: acra.cash_receipt_id = arps.cash_receipt_id

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

2991: ln_exchange_rate := rec_cur_get_cr_details.exchange_rate ;
2992:
2993: ln_app_fr_doc_id := p_araa.cash_receipt_id ;
2994: ln_app_fr_doc_type := jai_constants.ar_cash_tax_confirmed ; /* Receipt confirmation */
2995: ln_app_fr_doc_table := jai_constants.jai_cash_rcpts ; /* table JAI_AR_CASH_RECEIPTS_ALL */
2996:
2997: ln_fr_organization_id := rec_cur_get_cr_details.app_fr_organization_id ;
2998: ln_fr_party_id := rec_cur_get_cr_details.pay_from_customer ;
2999: ln_fr_party_site_id := rec_cur_get_cr_details.customer_site_use_id ;

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

3015: ln_exchange_rate := rec_cur_get_cm_details.exchange_rate ;
3016:
3017: ln_app_fr_doc_id := p_araa.customer_trx_id ;
3018: ln_app_fr_doc_type := jai_constants.ar_invoice_type_cm ; /* 'CM' */
3019: ln_app_fr_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3020:
3021: ln_fr_organization_id := rec_cur_get_cm_details.app_to_organization_id ;
3022: ln_fr_party_id := rec_cur_get_cm_details.app_to_customer_id ;
3023: ln_fr_party_site_id := rec_cur_get_cm_details.app_to_customer_site_use_id ;

Line 3269: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,

3265: END process_applications;
3266:
3267:
3268: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3269: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
3270: p_document_type IN VARCHAR2 ,
3271: p_process_flag OUT NOCOPY VARCHAR2 ,
3272: p_process_message OUT NOCOPY VARCHAR2
3273: )

Line 5219: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,

5215: p_event IN VARCHAR2 ,
5216: p_document_type IN VARCHAR2 Default Null ,
5217: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,
5218: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,
5219: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,
5220: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,
5221: p_process_flag OUT NOCOPY VARCHAR2 ,
5222: p_process_message OUT NOCOPY VARCHAR2
5223: )