DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 177: oe_order_headers_all

173: IS
174: SELECT
175: order_number
176: FROM
177: oe_order_headers_all
178: WHERE
179: header_id = cp_hdr_id;
180:
181: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

Line 188: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;

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) ;
191:
192: v_int_liab_acc_ccid NUMBER;

Line 463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%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;
467: v_liab_acc_ccid NUMBER;

Line 1040: PROCEDURE validate_sales_order ( p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,

1036:
1037: END ar_accounting;
1038:
1039:
1040: PROCEDURE validate_sales_order ( p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,
1041: p_process_flag OUT NOCOPY VARCHAR2 ,
1042: p_process_message OUT NOCOPY VARCHAR2
1043: )
1044: IS

Line 5829: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,

5825:
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 ,

Line 5900: PROCEDURE process_sales_order (p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,

5896: lv_process_flag VARCHAR2(2) ;
5897: lv_process_message VARCHAR2(2000) ;
5898:
5899: /* Added by JMEENA for TCS issue bug#7277211*/
5900: PROCEDURE process_sales_order (p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,
5901: p_process_flag OUT NOCOPY VARCHAR2 ,
5902: p_process_message OUT NOCOPY VARCHAR2
5903: )
5904: IS