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 744: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,

740: END receipt_interim_accounting;
741:
742: /*Bug 12543504 - End*/
743:
744: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,
745: p_ractl IN RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE DEFAULT NULL ,
746: p_process_flag OUT NOCOPY VARCHAR2 ,
747: p_process_message OUT NOCOPY VARCHAR2
748: )

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

748: )
749:
750: IS
751: ln_reg_id NUMBER;
752: CURSOR cur_get_inv_det ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
753: cp_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE DEFAULT NULL
754: )
755: IS
756: SELECT

Line 824: v_ref_24 := 'ra_customer_trx_all' ;

820: || VARIABLES INITIALIZATION - PART -1
821: ########################################################################################################*/
822: lv_member_name := 'AR_ACCOUNTING';
823: v_ref_23 := 'jai_ar_tcs_rep_pkg.ar_accounting';
824: v_ref_24 := 'ra_customer_trx_all' ;
825: v_ref_25 := 'customer_trx_id' ;
826: -- lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839 commented for bug#9587338
827: -- lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839 commented for bug#9587338
828:

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

1286:
1287:
1288: END validate_sales_order ;
1289:
1290: PROCEDURE validate_invoice ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
1291: p_document_type OUT NOCOPY VARCHAR2 ,
1292: p_process_flag OUT NOCOPY VARCHAR2 ,
1293: p_process_message OUT NOCOPY VARCHAR2
1294: )

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

1840: ln_reg_id NUMBER;
1841: /*
1842: || Applied to Document of the receivable application has TCS type of tax.
1843: */
1844: CURSOR cur_chk_tcs_applicable (cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )
1845: IS
1846: SELECT
1847: jrct.organization_id ,
1848: jrctl.inventory_item_id ,

Line 1851: ra_customer_trx_all rcta ,

1847: jrct.organization_id ,
1848: jrctl.inventory_item_id ,
1849: gl_dist.amount
1850: FROM
1851: ra_customer_trx_all rcta ,
1852: ra_cust_trx_line_gl_dist_all gl_dist ,
1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,

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

2530:
2531: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2532: END validate_receipts;
2533:
2534: PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
2535: p_document_type VARCHAR2 ,
2536: p_process_flag OUT NOCOPY VARCHAR2 ,
2537: p_process_message OUT NOCOPY VARCHAR2
2538: )

Line 3270: ra_customer_trx_all rcta ,

3266: nvl(rcta.bill_to_site_use_id, rcta.ship_to_site_use_id) app_to_customer_site_use_id -- Bug 6132484
3267: --Modify by Zhiwei for bug#14040855 end
3268: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end
3269: FROM
3270: ra_customer_trx_all rcta ,
3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,

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

3315:
3316: /*
3317: ||Get the type of the document
3318: */
3319: CURSOR cur_get_doc_type ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE )
3320: IS
3321: SELECT
3322: trx_types.type
3323: FROM

Line 3324: ra_customer_trx_all ract,

3320: IS
3321: SELECT
3322: trx_types.type
3323: FROM
3324: ra_customer_trx_all ract,
3325: ra_cust_trx_types_all trx_types
3326: WHERE
3327: ract.cust_trx_type_id = trx_types.cust_trx_type_id
3328: AND ract.customer_trx_id = cp_customer_trx_id;

Line 3378: ra_customer_trx_all rcta ,

3374: nvl( bill_to_customer_id , rcta.ship_to_customer_id ) app_to_customer_id ,
3375: nvl( bill_to_site_use_id , rcta.ship_to_site_use_id ) app_to_customer_site_use_id
3376: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
3377: FROM
3378: ra_customer_trx_all rcta ,
3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,

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

5052: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5053: END copy_references;
5054:
5055:
5056: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
5057: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
5058: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
5059: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
5060: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 5057: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,

5053: END copy_references;
5054:
5055:
5056: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
5057: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
5058: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
5059: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
5060: p_process_flag OUT NOCOPY VARCHAR2 ,
5061: p_process_message OUT NOCOPY VARCHAR2

Line 5058: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,

5054:
5055:
5056: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
5057: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
5058: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
5059: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
5060: p_process_flag OUT NOCOPY VARCHAR2 ,
5061: p_process_message OUT NOCOPY VARCHAR2
5062: )

Line 5059: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

5055:
5056: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
5057: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
5058: p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
5059: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
5060: p_process_flag OUT NOCOPY VARCHAR2 ,
5061: p_process_message OUT NOCOPY VARCHAR2
5062: )
5063: IS

Line 5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;

5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
5257: ln_ccid_tax_type_tcs NUMBER ;
5258: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
5259: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
5260: ln_amount NUMBER ;

Line 5830: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,

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