DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 101: oe_order_headers_all

97: IS
98: SELECT
99: order_number
100: FROM
101: oe_order_headers_all
102: WHERE
103: header_id = cp_hdr_id;
104:
105: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;

Line 112: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;

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) ;
115:
116: v_int_liab_acc_ccid NUMBER;

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

550:
551: END ar_accounting;
552:
553:
554: PROCEDURE validate_sales_order ( p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,
555: p_process_flag OUT NOCOPY VARCHAR2 ,
556: p_process_message OUT NOCOPY VARCHAR2
557: )
558: IS

Line 5217: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,

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

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

5284: lv_process_flag VARCHAR2(2) ;
5285: lv_process_message VARCHAR2(2000) ;
5286:
5287: /* Added by JMEENA for TCS issue bug#7277211*/
5288: PROCEDURE process_sales_order (p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,
5289: p_process_flag OUT NOCOPY VARCHAR2 ,
5290: p_process_message OUT NOCOPY VARCHAR2
5291: )
5292: IS