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 105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

101: oe_order_headers_all
102: WHERE
103: header_id = cp_hdr_id;
104:
105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
106: v_std_text VARCHAR2(50) ; -- bug # 3158976
107: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
108: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
109: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'

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

103: header_id = cp_hdr_id;
104:
105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
106: v_std_text VARCHAR2(50) ; -- bug # 3158976
107: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
108: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
109: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
110: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
111:

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

104:
105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
106: v_std_text VARCHAR2(50) ; -- bug # 3158976
107: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
108: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
109: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
110: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
111:
112: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;

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

105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
106: v_std_text VARCHAR2(50) ; -- bug # 3158976
107: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
108: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
109: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
110: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
111:
112: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
113: lv_source_name VARCHAR2(100) ;

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

106: v_std_text VARCHAR2(50) ; -- bug # 3158976
107: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name -- 'ja_in_wsh_dlry_rg'
108: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name -- ' wsh_new_deliveries'
109: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name -- 'delivery_id'
110: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
111:
112: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
113: lv_source_name VARCHAR2(100) ;
114: lv_category_name VARCHAR2(100) ;

Line 348: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

344: AND jrttv.regime_code = jai_constants.tcs_regime
345: AND jrct.customer_trx_id = cp_customer_trx_id
346: AND jrctl.customer_trx_line_id = nvl( cp_customer_trx_line_id , jrctl.customer_trx_line_id );
347:
348: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
349: v_std_text VARCHAR2(50) ;
350: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
351: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
352: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name

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

346: AND jrctl.customer_trx_line_id = nvl( cp_customer_trx_line_id , jrctl.customer_trx_line_id );
347:
348: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
349: v_std_text VARCHAR2(50) ;
350: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
351: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
352: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
353: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
354:

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

347:
348: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
349: v_std_text VARCHAR2(50) ;
350: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
351: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
352: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
353: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
354:
355: lv_source_name VARCHAR2(100) ;

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

348: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
349: v_std_text VARCHAR2(50) ;
350: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
351: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
352: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
353: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
354:
355: lv_source_name VARCHAR2(100) ;
356: lv_category_name VARCHAR2(100) ;

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

349: v_std_text VARCHAR2(50) ;
350: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE ; -- holds the object name
351: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE ; -- holds the table name
352: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE ; -- holds the column name
353: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
354:
355: lv_source_name VARCHAR2(100) ;
356: lv_category_name VARCHAR2(100) ;
357: