1 PACKAGE ASO_ORDER_FEEDBACK_VUHK AUTHID CURRENT_USER as
2 /* $Header: asohomfs.pls 120.1 2005/06/29 12:31:52 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_ORDER_FEEDBACK_VUHK
5 -- Purpose :
6 -- This package is the spec required for customer user hooks needed to
7 -- simplify the customization process. It consists of both the pre and
8 -- post processing APIs.
9
10 PROCEDURE Update_Notice_PRE(
11 p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
12 p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13 p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
14 p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15 p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
16 p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17 p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
18 p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19 p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
20 p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21 p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
22 p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23 p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
24 p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25 p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
26 p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27 p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
28 p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29 p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
30 p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31 p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
32 p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33 p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
34 p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35 p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
36 p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37 p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
38 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
40 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 );
42
43
44
45 PROCEDURE Update_Notice_Post(
46 p_header_rec IN OE_Order_PUB.Header_Rec_Type,
47 p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
48 p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
49 p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50 p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
51 p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52 p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
53 p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54 p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
55 p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56 p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
57 p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58 p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
59 p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60 p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
61 p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62 p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
63 p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64 p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
65 p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66 p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
67 p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68 p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
69 p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70 p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
71 p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72 p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
73 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
75 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 );
77
78 End ASO_ORDER_FEEDBACK_VUHK;