1 PACKAGE GR_WF_UTIL_PUB AS
2 /* $Header: GRWFUPBS.pls 120.2 2007/12/13 20:55:11 plowe ship $ */
3
4 /* Global variables */
5 G_PKG_NAME CONSTANT varchar2(30) := 'GR_WF_UTIL_PUB';
6 G_debug_level CONSTANT NUMBER := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
7 /*===========================================================================
8 -- PROCEDURE:
9 -- INITIATE_PROCESS_ITEM_CHNG
10 --
11 -- DESCRIPTION:
12 -- This PL/SQL procedure is used to initiate the Document Rebuild Required Workflow
13 -- for a Item Properties change for a regulatory item. And it will be called from the
14 -- trigger on Item properties table.
15 --
16 -- PARAMETERS:
17 -- p_api_version IN NUMBER - API Version
18 -- p_init_msg_list IN VARCHAR2 - Initiate the message list
19 -- p_commit IN VARCHAR2 - Commit Flag
20 -- p_orgn_id IN NUMBER - Organization Id for an Item
21 -- p_item_id IN NUMBER - Item Id of an Item
22 -- x_return_status OUT NOCOPY VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
23 -- x_error_code OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate error code
24 -- x_msg_data OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate message
25 --
26 -- SYNOPSIS:
27 -- INITIATE_PROCESS_ITEM_CHNG(l_api_version,l_init_msg_list,l_commit,l_orgn_id
28 -- l_item_id,x_return_status,x_error_code,x_msg_data);
29 --
30 -- HISTORY
31 -- Mercy Thomas 31-Mar-2005 BUG 4276612 - Created.
32 --
33 --=========================================================================== */
34
35 PROCEDURE INITIATE_PROCESS_ITEM_CHNG
36 (p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2,
38 p_commit IN VARCHAR2,
39 p_orgn_id IN NUMBER,
40 p_item_id IN NUMBER,
41 p_user_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_error_code OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 /*===========================================================================
48 -- PROCEDURE:
49 -- INITIATE_PROCESS_FORMULA_CHNG
50 --
51 -- DESCRIPTION:
52 -- This PL/SQL procedure is used to initiate the Document Rebuild Required Workflow
53 -- for a Formula change for a regulatory item. And it will be called from the
54 -- trigger from a Formula API.
55 --
56 -- PARAMETERS:
57 -- p_api_version IN NUMBER - API Version
58 -- p_init_msg_list IN VARCHAR2 - Initiate the message list
59 -- p_commit IN VARCHAR2 - Commit Flag
60 -- p_orgn_id IN NUMBER - Organization Id for an Item
61 -- p_item_id IN NUMBER - Item Id of an Item
62 -- p_formula_id IN NUMBER - Formula Id of product
63 -- x_return_status OUT NOCOPY VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
64 -- x_error_code OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate error code
65 -- x_msg_data OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate message
66 --
67 -- SYNOPSIS:
68 -- INITIATE_PROCESS_FORMULA_CHNG(l_api_version,l_init_msg_list,l_commit,l_orgn_id
69 -- l_item_id,l_formula_id,x_return_status,x_error_code,x_msg_data);
70 --
71 -- HISTORY
72 -- Mercy Thomas 31-Mar-2005 BUG 4276612 - Created.
73 --
74 --=========================================================================== */
75 PROCEDURE INITIATE_PROCESS_FORMULA_CHNG
76 (p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2,
78 p_commit IN VARCHAR2,
79 p_orgn_id IN NUMBER,
80 p_item_id IN NUMBER,
81 p_formula_no IN VARCHAR2,
82 p_formula_vers IN NUMBER,
83 p_user_id IN NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_error_code OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 /*===========================================================================
90 -- PROCEDURE:
91 -- INITIATE_PROCESS_SALES_ORDER
92 --
93 -- DESCRIPTION:
94 -- This PL/SQL procedure is used to initiate the Document Rebuild Required Workflow
95 -- or a Sales Order change for a hazardous regulatory item. And it will be called from the
96 -- trigger from INV_Move_Order_PUB.Create_Move_Order_Lines
97 --
98 -- PARAMETERS:
99 -- p_api_version IN NUMBER - API Version
100 -- p_init_msg_list IN VARCHAR2 - Initiate the message list
101 -- p_commit IN VARCHAR2 - Commit Flag
102 -- p_sales_order_org_id IN NUMBER - Organization Id (OU) for the Sales Order
103 -- p_orgn_id IN NUMBER - Organization Id for an Item
104 -- p_item_id IN NUMBER - Item Id of an Item
105 -- p_sales_order_noIN VARCHAR2 - Sales Order Number of an Item
106 -- x_return_status OUT NOCOPY VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
107 -- x_error_code OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate error code
108 -- x_msg_data OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate message
109 --
110 -- SYNOPSIS:
111 -- INITIATE_PROCESS_SALES_ORDER(l_api_version,l_init_msg_list,l_commit,l_orgn_id
112 -- l_item_id,l_sales_order_no,x_return_status,x_error_code,x_msg_data);
113 --
114 -- HISTORY
115 -- Mercy Thomas 31-Mar-2005 BUG 4276612 - Created.
116 -- Peter Lowe 13-Dec-2007 Bug 6689912 Added sales order org id to
117 -- signature of INITIATE_PROCESS_SALES_ORDER
118 -- for 3rd Party Integration
119 --========================================================================= */
120
121 PROCEDURE INITIATE_PROCESS_SALES_ORDER
122 (p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2,
124 p_commit IN VARCHAR2,
125 p_sales_order_org_id IN NUMBER,
126 p_orgn_id IN NUMBER,
127 p_item_id IN NUMBER,
128 p_sales_order_no IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_error_code OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2
132 );
133 /*===========================================================================
134 -- PROCEDURE:
135 -- INITIATE_PROCESS_TECH_CHNG
136 --
137 -- DESCRIPTION:
138 -- This PL/SQL procedure is used to initiate the Document Rebuild Required Workflow
139 -- for a Technical Parameters change for a regulatory item. And it will be called from the
140 -- trigger on Item Technical Data Header table.
141 --
142 -- PARAMETERS:
143 -- p_api_version IN NUMBER - API Version
144 -- p_init_msg_list IN VARCHAR2 - Initiate the message list
145 -- p_commit IN VARCHAR2 - Commit Flag
146 -- p_orgn_id IN NUMBER - Organization Id for an Item
147 -- p_item_id IN NUMBER - Item Id of an Item
148 -- p_tech_data_id IN NUMBER - Technical Data_Id of product
149 -- x_return_status OUT NOCOPY VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
150 -- x_error_code OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate error code
151 -- x_msg_data OUT NOCOPY VARCHAR2 - If there is an error, send back the approriate message
152 --
153 -- SYNOPSIS:
154 -- INITIATE_PROCESS_TECH_CHNG(l_api_version,l_init_msg_list,l_commit,l_orgn_id
155 -- l_item_id,l_tech_data_id,x_return_status,x_error_code,x_msg_data);
156 --
157 -- HISTORY
158 -- Mercy Thomas 31-Mar-2005 BUG 4276612 - Created.
159 --
160 --=========================================================================== */
161
162 PROCEDURE INITIATE_PROCESS_TECH_CHNG
163 (p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2,
165 p_commit IN VARCHAR2,
166 p_orgn_id IN NUMBER,
167 p_tech_data_id IN NUMBER,
168 p_tech_parm_id IN NUMBER,
169 p_user_id IN NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_error_code OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 END GR_WF_UTIL_PUB;