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 RA_CUSTOMER_TRX_ALL

Line 314: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,

310: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.wsh_interim_accounting '||substr(sqlerrm,1,300);
311:
312: END wsh_interim_accounting;
313:
314: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,
315: p_ractl IN RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE DEFAULT NULL ,
316: p_process_flag OUT NOCOPY VARCHAR2 ,
317: p_process_message OUT NOCOPY VARCHAR2
318: )

Line 322: CURSOR cur_get_inv_det ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,

318: )
319:
320: IS
321: ln_reg_id NUMBER;
322: CURSOR cur_get_inv_det ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
323: cp_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE DEFAULT NULL
324: )
325: IS
326: SELECT

Line 366: v_ref_24 := 'ra_customer_trx_all' ;

362: || VARIABLES INITIALIZATION - PART -1
363: ########################################################################################################*/
364: lv_member_name := 'AR_ACCOUNTING';
365: v_ref_23 := 'jai_ar_tcs_rep_pkg.ar_accounting';
366: v_ref_24 := 'ra_customer_trx_all' ;
367: v_ref_25 := 'customer_trx_id' ;
368: lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839
369: lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839
370: set_debug_context;

Line 800: PROCEDURE validate_invoice ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,

796:
797:
798: END validate_sales_order ;
799:
800: PROCEDURE validate_invoice ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
801: p_document_type OUT NOCOPY VARCHAR2 ,
802: p_process_flag OUT NOCOPY VARCHAR2 ,
803: p_process_message OUT NOCOPY VARCHAR2
804: )

Line 1329: CURSOR cur_chk_tcs_applicable (cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )

1325: ln_reg_id NUMBER;
1326: /*
1327: || Applied to Document of the receivable application has TCS type of tax.
1328: */
1329: CURSOR cur_chk_tcs_applicable (cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )
1330: IS
1331: SELECT
1332: jrct.organization_id ,
1333: jrctl.inventory_item_id ,

Line 1336: ra_customer_trx_all rcta ,

1332: jrct.organization_id ,
1333: jrctl.inventory_item_id ,
1334: gl_dist.amount
1335: FROM
1336: ra_customer_trx_all rcta ,
1337: ra_cust_trx_line_gl_dist_all gl_dist ,
1338: JAI_AR_TRXS jrct ,
1339: JAI_AR_TRX_LINES jrctl ,
1340: JAI_AR_TRX_TAX_LINES jrcttl ,

Line 2019: PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,

2015:
2016: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2017: END validate_receipts;
2018:
2019: PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
2020: p_document_type VARCHAR2 ,
2021: p_process_flag OUT NOCOPY VARCHAR2 ,
2022: p_process_message OUT NOCOPY VARCHAR2
2023: )

Line 2749: ra_customer_trx_all rcta ,

2745: jrct.organization_id app_to_organization_id ,
2746: nvl(bill_to_customer_id, ship_to_customer_id) app_to_customer_id , -- Bug 6132484
2747: nvl(bill_to_site_use_id,ship_to_site_use_id) app_to_customer_site_use_id -- Bug 6132484
2748: FROM
2749: ra_customer_trx_all rcta ,
2750: ra_cust_trx_types_all trx_types ,
2751: ra_cust_trx_line_gl_dist_all gl_dist ,
2752: JAI_AR_TRXS jrct ,
2753: JAI_AR_TRX_LINES jrctl ,

Line 2798: CURSOR cur_get_doc_type ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )

2794:
2795: /*
2796: ||Get the type of the document
2797: */
2798: CURSOR cur_get_doc_type ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )
2799: IS
2800: SELECT
2801: trx_types.type
2802: FROM

Line 2803: ra_customer_trx_all ract,

2799: IS
2800: SELECT
2801: trx_types.type
2802: FROM
2803: ra_customer_trx_all ract,
2804: ra_cust_trx_types_all trx_types
2805: WHERE
2806: ract.cust_trx_type_id = trx_types.cust_trx_type_id
2807: AND ract.customer_trx_id = cp_customer_trx_id;

Line 2853: ra_customer_trx_all rcta ,

2849: jrct.organization_id app_to_organization_id ,
2850: nvl( bill_to_customer_id , ship_to_customer_id ) app_to_customer_id ,
2851: nvl( bill_to_site_use_id , ship_to_site_use_id ) app_to_customer_site_use_id
2852: FROM
2853: ra_customer_trx_all rcta ,
2854: ra_cust_trx_types_all trx_types ,
2855: ra_cust_trx_line_gl_dist_all gl_dist ,
2856: JAI_AR_TRXS jrct ,
2857: JAI_AR_TRX_LINES jrctl ,

Line 4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,

4481: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4482: END copy_references;
4483:
4484:
4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
4486: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
4487: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
4488: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4489: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 4486: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,

4482: END copy_references;
4483:
4484:
4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
4486: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
4487: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
4488: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4489: p_process_flag OUT NOCOPY VARCHAR2 ,
4490: p_process_message OUT NOCOPY VARCHAR2

Line 4487: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,

4483:
4484:
4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
4486: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
4487: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
4488: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4489: p_process_flag OUT NOCOPY VARCHAR2 ,
4490: p_process_message OUT NOCOPY VARCHAR2
4491: )

Line 4488: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

4484:
4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
4486: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
4487: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
4488: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4489: p_process_flag OUT NOCOPY VARCHAR2 ,
4490: p_process_message OUT NOCOPY VARCHAR2
4491: )
4492: IS

Line 4676: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;

4672: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4673: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4674: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
4675: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
4676: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
4677: ln_ccid_tax_type_tcs NUMBER ;
4678: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
4679: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
4680: ln_amount NUMBER ;

Line 5218: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,

5214: PROCEDURE process_transactions (
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