DBA Data[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;