[Home] [Help]
PACKAGE: APPS.OE_ORDER_WF_UTIL
Source
1 PACKAGE OE_Order_WF_Util AS
2 /* $Header: OEXUOWFS.pls 120.0.12010000.1 2008/07/25 07:57:00 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_WF_UTIL';
5
6 PROCEDURE Set_Notification_Approver(
7 itemtype in varchar2,
8 itemkey in varchar2,
9 actid in number,
10 funcmode in varchar2,
11 resultout in out NOCOPY /* file.sql.39 change */ varchar2);
12
13 PROCEDURE Set_Header_User_Key
14 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
15 );
16
17 PROCEDURE Set_Line_User_Key
18 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
19 );
20
21 PROCEDURE Set_Header_Descriptor(document_id in varchar2,
22 display_type in varchar2,
23 document in out NOCOPY /* file.sql.39 change */ varchar2,
24 document_type in out NOCOPY /* file.sql.39 change */ varchar2
25 );
26
27
28 PROCEDURE Set_Line_Descriptor(document_id in varchar2,
29 display_type in varchar2,
30 document in out NOCOPY /* file.sql.39 change */ varchar2,
31 document_type in out NOCOPY /* file.sql.39 change */ varchar2
32 );
33
34
35 PROCEDURE Start_Flow
36 ( p_itemtype in varchar2
37 , p_itemkey in varchar2
38 );
39
40 PROCEDURE Start_LineFork
41 ( p_itemkey in varchar2
42 );
43
44 PROCEDURE CreateStart_HdrProcess
45 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
46 );
47
48 PROCEDURE Create_HdrWorkItem
49 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
50 );
51
52 PROCEDURE CreateStart_LineFork
53 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
54 );
55
56 PROCEDURE CreateStart_LineProcess
57 ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
58 );
59
60
61
62 PROCEDURE Create_LineWorkItem
63 ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type,
64 p_item_type IN VARCHAR2
65 );
66
67 PROCEDURE Create_LineFork
68 ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
69 );
70
71 FUNCTION Get_Wf_Item_type
72 ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
73 ) RETURN VARCHAR2;
74
75 PROCEDURE Start_All_Flows;
76
77 PROCEDURE Clear_FlowStart_Globals;
78
79 PROCEDURE Delete_Row
80 ( p_type IN VARCHAR2
81 , p_id IN NUMBER
82 );
83
84 PROCEDURE Update_Flow_Status_Code
85 ( p_header_id IN NUMBER DEFAULT NULL,
86 p_line_id IN NUMBER DEFAULT NULL,
87 p_flow_status_code IN VARCHAR2,
88 p_item_type IN VARCHAR2 DEFAULT NULL,
89 p_sales_document_type_code IN VARCHAR2 DEFAULT NULL,
90 x_return_status OUT NOCOPY VARCHAR2
91
92 );
93
94 PROCEDURE Update_Quote_Blanket
95 ( p_item_type IN VARCHAR2,
96 p_item_key IN VARCHAR2,
97 p_flow_status_code IN VARCHAR2 DEFAULT NULL,
98 p_open_flag IN VARCHAR2 DEFAULT NULL,
99 p_draft_submitted_flag IN VARCHAR2 DEFAULT NULL,
100 x_return_status OUT NOCOPY VARCHAR2
101
102 );
103
104 PROCEDURE Create_WorkItem_Upgrade
105 (p_item_type IN VARCHAR2,
106 p_item_key IN VARCHAR2,
107 p_process_name IN VARCHAR2,
108 p_transaction_number IN NUMBER,
109 p_sales_document_type_code IN VARCHAR2,
110 p_user_id IN NUMBER,
111 p_resp_id IN NUMBER,
112 p_appl_id IN NUMBER,
113 p_org_id IN NUMBER
114 );
115
116 PROCEDURE CreateStart_HdrInternal
117 ( p_item_type IN VARCHAR2,
118 p_header_id IN NUMBER,
119 p_transaction_number IN NUMBER,
120 p_sales_document_type_code IN VARCHAR2
121 );
122
123 PROCEDURE Create_HdrWorkItemInternal
124 (p_item_type IN VARCHAR2,
125 p_header_id IN NUMBER,
126 p_transaction_number IN NUMBER,
127 p_sales_document_type_code IN VARCHAR2
128 );
129
130 PROCEDURE Set_Negotiate_Hdr_User_Key
131 (p_header_id IN NUMBER,
132 p_sales_document_type_code IN VARCHAR2,
133 p_transaction_number IN NUMBER);
134
135 PROCEDURE Set_Blanket_Hdr_User_Key
136 (p_header_id IN NUMBER,
137 p_transaction_number IN NUMBER);
138
139
140 Procedure Set_transaction_Details(document_id in varchar2,
141 display_type in varchar2,
142 document in out NOCOPY varchar2,
143 document_type in out NOCOPY varchar2);
144
145 procedure build_quote_doc ( p_item_type in varchar2,
146 p_item_key in varchar2,
147 p_display_type in varchar2,
148 p_x_document in out NOCOPY varchar2
149 );
150
151 procedure build_blanket_doc ( p_item_type in varchar2,
152 p_item_key in varchar2,
153 p_display_type in varchar2,
154 p_x_document in out NOCOPY varchar2
155 );
156 function check_credit_hold (p_hold_entity_code IN varchar2,
157 p_hold_entity_id IN number
158 )
159 RETURN VARCHAR2;
160
161 PROCEDURE Complete_eligible_and_Book
162 ( p_api_version_number IN NUMBER
163 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
164 , p_header_id IN NUMBER
165 , x_return_status OUT NOCOPY VARCHAR2
166 , x_msg_count OUT NOCOPY NUMBER
167 , x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 END OE_Order_WF_Util;