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