1 PACKAGE OE_Negotiate_WF AUTHID CURRENT_USER AS
2 /* $Header: OEXWNEGS.pls 120.1 2006/03/29 16:53:14 spooruli noship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_NEGOTIATE_WF';
6
7 PROCEDURE Update_Status_Lost(
8 itemtype in varchar2,
9 itemkey in varchar2,
10 actid in number,
11 funcmode in varchar2,
12 resultout in out nocopy varchar2);
13
14 PROCEDURE Negotiation_Complete(
15 itemtype in varchar2,
16 itemkey in varchar2,
17 actid in number,
18 funcmode in varchar2,
19 resultout in out nocopy varchar2);
20
21 PROCEDURE Submit_Draft_Internal(
22 itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout in out nocopy varchar2);
27
28 PROCEDURE Customer_Acceptance(
29 itemtype in varchar2,
30 itemkey in varchar2,
31 actid in number,
32 funcmode in varchar2,
33 resultout in out nocopy varchar2);
34
35 PROCEDURE Update_Customer_Accepted(
36 itemtype in varchar2,
37 itemkey in varchar2,
38 actid in number,
39 funcmode in varchar2,
40 resultout in out nocopy varchar2);
41
42 PROCEDURE Update_Customer_Rejected(
43 itemtype in varchar2,
44 itemkey in varchar2,
45 actid in number,
46 funcmode in varchar2,
47 resultout in out nocopy varchar2);
48
49 PROCEDURE Check_Expiration_Date(
50 itemtype in varchar2,
51 itemkey in varchar2,
52 actid in number,
53 funcmode in varchar2,
54 resultout in out nocopy varchar2);
55
56 PROCEDURE Offer_Expired(
57 itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout in out nocopy varchar2);
62
63 PROCEDURE Set_Negotiate_Hdr_Descriptor
64 (document_id in VARCHAR2,
65 display_type in VARCHAR2,
66 document in out nocopy VARCHAR2,
67 document_type in out nocopy VARCHAR2);
68
69
70
71 PROCEDURE Lost(p_header_id in NUMBER,
72 p_entity_code in VARCHAR2,
73 p_version_number in NUMBER,
74 p_reason_type in VARCHAR2,
75 p_reason_code in VARCHAR2,
76 p_reason_comments in VARCHAR2,
77 x_return_status out nocopy VARCHAR2);
78
79 PROCEDURE Customer_Accepted(p_header_id in NUMBER, x_return_status out nocopy VARCHAR2);
80
81 PROCEDURE Customer_Rejected(p_header_id in NUMBER,
82 p_entity_code in VARCHAR2,
83 p_version_number in NUMBER,
84 p_reason_type in VARCHAR2,
85 p_reason_code in VARCHAR2,
86 p_reason_comments in VARCHAR2,
87 x_return_status out nocopy VARCHAR2);
88
89 PROCEDURE Offer_Date_Changed(p_header_id in NUMBER, x_return_status out nocopy VARCHAR2);
90
91 PROCEDURE Submit_Draft(p_header_id in NUMBER, x_return_status out nocopy VARCHAR2);
92
93 PROCEDURE Set_Header_Attributes
94 (itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funcmode in varchar2,
98 resultout in out nocopy varchar2);
99
100 PROCEDURE Set_Header_Attributes_Internal(p_header_id IN NUMBER);
101
102 PROCEDURE Set_Final_Expiration_Date
103 (itemtype in varchar2,
104 itemkey in varchar2,
105 actid in number,
106 funcmode in varchar2,
107 resultout in out nocopy varchar2);
108
109
110
111
112 FUNCTION At_Customer_Acceptance(p_header_id NUMBER) RETURN Boolean;
113
114 END OE_NEGOTIATE_WF;