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 GL_INTERFACE

Line 181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

177: oe_order_headers_all
178: WHERE
179: header_id = cp_hdr_id;
180:
181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
182: v_std_text VARCHAR2(50) ; -- bug # 3158976
183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'

Line 183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'

179: header_id = cp_hdr_id;
180:
181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
182: v_std_text VARCHAR2(50) ; -- bug # 3158976
183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
186: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
187:

Line 184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'

180:
181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
182: v_std_text VARCHAR2(50) ; -- bug # 3158976
183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
186: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
187:
188: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;

Line 185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'

181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
182: v_std_text VARCHAR2(50) ; -- bug # 3158976
183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
186: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
187:
188: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
189: lv_source_name VARCHAR2(100) ;

Line 186: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645

182: v_std_text VARCHAR2(50) ; -- bug # 3158976
183: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
184: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
185: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
186: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
187:
188: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
189: lv_source_name VARCHAR2(100) ;
190: lv_category_name VARCHAR2(100) ;

Line 392: Inserts entries into GL_INTERFACE, JAI_RCV_JOURNAL_ENTRIES and JAI_RCV_SUBLED_ENTRIES*/

388:
389: END wsh_interim_accounting;
390:
391: /*Bug 12543504 - Fetches the TCS Taxes from RMA Receipt. Moves the TCS Liability to Interim Liability as this is Receipt for RMA Order
392: Inserts entries into GL_INTERFACE, JAI_RCV_JOURNAL_ENTRIES and JAI_RCV_SUBLED_ENTRIES*/
393:
394: PROCEDURE receipt_interim_accounting(p_shipment_line_id IN NUMBER,
395: p_shipment_header_id IN NUMBER,
396: p_organization_id IN NUMBER,

Line 458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

454: lv_account_type VARCHAR2(30);
455: lv_period_name gl_periods.period_name%type;
456: v_process_status VARCHAR2(30);
457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645

Line 459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name

455: lv_period_name gl_periods.period_name%type;
456: v_process_status VARCHAR2(30);
457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;

Line 460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'

456: v_process_status VARCHAR2(30);
457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
464: lv_source_name VARCHAR2(100) := 'Receivables India' ;

Line 461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'

457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
464: lv_source_name VARCHAR2(100) := 'Receivables India' ;
465: lv_category_name VARCHAR2(100) := jai_constants.tcs_source ;

Line 462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645

458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
464: lv_source_name VARCHAR2(100) := 'Receivables India' ;
465: lv_category_name VARCHAR2(100) := jai_constants.tcs_source ;
466: v_int_liab_acc_ccid NUMBER;

Line 788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

784:
785: ld_dist_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE ;
786: /* Added for Bug 6734317 - End */
787:
788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
789: v_std_text VARCHAR2(50) ;
790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name

Line 790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name

786: /* Added for Bug 6734317 - End */
787:
788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
789: v_std_text VARCHAR2(50) ;
790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
793: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
794:

Line 791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name

787:
788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
789: v_std_text VARCHAR2(50) ;
790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
793: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
794:
795: lv_source_name VARCHAR2(100) ;

Line 792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name

788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
789: v_std_text VARCHAR2(50) ;
790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
793: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
794:
795: lv_source_name VARCHAR2(100) ;
796: lv_category_name VARCHAR2(100) ;

Line 793: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645

789: v_std_text VARCHAR2(50) ;
790: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
791: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
792: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
793: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
794:
795: lv_source_name VARCHAR2(100) ;
796: lv_category_name VARCHAR2(100) ;
797: