[Home] [Help]
PACKAGE: APPS.OE_LINE_ACK_UTIL
Source
1 PACKAGE OE_Line_Ack_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULAKS.pls 120.0.12000000.1 2007/01/16 22:03:37 appldev ship $ */
3
4 PROCEDURE Insert_Row
5 ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6 , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
7 , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
8 , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
9 , p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
10 , p_reject_order IN VARCHAR2
11 , p_ack_type IN VARCHAR2 := NULL
12 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 );
14
15 Procedure Insert_Row
16 ( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
17 p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
18 x_return_status Out NOCOPY /* file.sql.39 change */ VARCHAR2
19 );
20
21 PROCEDURE Delete_Row
22 ( p_line_id IN NUMBER,
23 p_ack_type In Varchar2,
24 p_orig_sys_document_ref In Varchar2 := NULL,
25 p_orig_sys_line_ref In Varchar2 := NULL,
26 p_orig_sys_shipment_ref In Varchar2 := NULL,
27 p_sold_to_org_id In Number := NULL,
28 p_sold_to_org In Varchar2 := NULL,
29 p_change_sequence In Varchar2 := NULL,
30 p_request_id In Number := NULL,
31 p_header_id In Number := NULL
32 );
33
34 END OE_Line_Ack_Util;