1 PACKAGE OE_CHG_ORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVCHGS.pls 120.1 2005/09/25 02:38:54 lkxu noship $ */
3
4 -- Start of Comments
5 -- API name OE_CHG_ORDER_PVT
6 -- Type PRIVATE
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 G_PKG_NAME VARCHAR2(30) := 'OE_CHG_ORDER_PVT';
21 G_USER_TEXT VARCHAR2(2000);
22 G_ORDER_NUMBER NUMBER;
23 G_ORDER_TYPE VARCHAR2(150);
24
25
26 /* Procedure StartChgOrderProcess
27 ** Usage This procedure will launch a workflow as specified
28 ** in parameter p_workflow with item_key as p_wf_key_id
29 ** Any informations in table oe_line_pending_actions for
30 ** the given p_wf_key_id are reterived to populate workflow
31 ** Item attributes.
32 ** Parameters
33 ** IN p_workflow_process Name of the workflow process to be started
34 ** IN x_pending_rec pending request record type , this is used
35 ** to store the context information for workflow process
36 ** x_return_status Procedure result falg
37 */
38
39
40
41 PROCEDURE Start_ChangeOrderFlow
42 ( p_itemtype in varchar2
43 ,p_itemkey in varchar2
44 );
45
46
47 PROCEDURE Create_ChgOrderWorkItem
48 (
49 p_Workflow_Process IN VARCHAR2
50 , p_resolving_role IN VARCHAR2
51 , p_resolving_name IN VARCHAR2
52 , p_user_text IN VARCHAR2 );
53
54
55
56 /* Procedure Generate_PLSQLDoc - this is used to create
57 ** a PL/SQL document type of an attribute for dynamic
58 ** message body. The document buffer is aligned appropriately
59 ** based on the display type for the notification
60 */
61
62 PROCEDURE Generate_PLSQLDoc(p_document_id in varchar2,
63 p_display_type in varchar2,
64 p_document in out NOCOPY /* file.sql.39 change */ varchar2,
65 p_document_type in out NOCOPY /* file.sql.39 change */ varchar2);
66
67 PROCEDURE Update_User_Text(p_user_text in varchar2);
68
69 PROCEDURE Update_Order_Number(p_order_number in NUMBER);
70
71 /* Procedure RecordLinHist
72 ** Inserts a line record and reason_code, comments in the history tables.
73 ** p_histroy_type_code can be used to specify the activity for which the
74 ** history trail was recorded. wf_activity_code, wf_result_code
75 ** can be used to indicate the state of the line at which the history was
76 ** recorded.
77 ** Parameter
78 ** IN p_line_id Line for which the histroy is recorde
79 ** IN p_line_rec Line for which the histroy is recorded
80 ** IN p_hist_type_code Code indentifying the acitivity for whihc the
81 ** history record is generated
82 ** IN p_reason_code Reason code
83 ** IN p_comments Comments
84 ** IN p_wf_activity_code p_wf_activity code and p_wf_result_code
85 ** IN p_wf_result_code determine the state of the line with respect to
86 ** workflow at which the history was generatged.
87 */
88 Procedure RecordLineHist
89 (p_line_id In Number
90 ,p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE
91 := OE_Order_PUB.G_MISS_LINE_REC
92 ,p_hist_type_code In Varchar2
93 ,p_reason_code In varchar2
94 ,p_comments IN Varchar2
95 ,p_audit_flag IN Varchar2 := null
96 ,p_version_flag IN Varchar2 := null
97 ,p_phase_change_flag IN Varchar2 := null
98 ,p_version_number IN NUMBER := null
99 ,p_reason_id IN NUMBER := NULL
100 ,p_wf_activity_code IN Varchar2 := null
101 ,p_wf_result_code IN Varchar2 := null
102 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
103 );
104
105 /* Start Audit Trail */
106 Procedure RecordHeaderHist
107 (p_header_id In Number
108 ,p_header_rec In OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC
109 ,p_hist_type_code In Varchar2
110 ,p_reason_code In varchar2
111 ,p_comments IN Varchar2
112 ,p_audit_flag IN Varchar2 := null
113 ,p_version_flag IN Varchar2 := null
114 ,p_phase_change_flag IN Varchar2 := null
115 ,p_version_number IN NUMBER := null
116 ,p_reason_id IN NUMBER := NULL
117 ,p_wf_activity_code IN Varchar2 := null
118 ,p_wf_result_code IN Varchar2 := null
119 ,p_changed_attribute IN VARCHAR2 := null
120 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2);
121
122 Procedure RecordHSCreditHist
123 (p_header_scredit_id In Number
124 ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
125 ,p_hist_type_code In Varchar2
126 ,p_reason_code In varchar2
127 ,p_comments IN Varchar2
128 ,p_audit_flag IN Varchar2 := null
129 ,p_version_flag IN Varchar2 := null
130 ,p_phase_change_flag IN Varchar2 := null
131 ,p_version_number IN NUMBER := null
132 ,p_reason_id IN NUMBER := NULL
133 ,p_wf_activity_code IN Varchar2 := null
134 ,p_wf_result_code IN Varchar2 := null
135 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2);
136
137 Procedure RecordLSCreditHist
138 (p_line_scredit_id In Number
139 ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE
140 := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
141 ,p_hist_type_code In Varchar2
142 ,p_reason_code In varchar2
143 ,p_comments IN Varchar2
144 ,p_audit_flag IN Varchar2 := null
145 ,p_version_flag IN Varchar2 := null
146 ,p_phase_change_flag IN Varchar2 := null
147 ,p_version_number IN NUMBER := null
148 ,p_reason_id IN NUMBER := NULL
149 ,p_wf_activity_code IN Varchar2 := null
150 ,p_wf_result_code IN Varchar2 := null
151 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
152 );
153
154 Procedure RecordHPAdjHist
155 (p_header_adj_id In Number
156 ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE
157 := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
158 ,p_hist_type_code In Varchar2
159 ,p_reason_code In varchar2
160 ,p_comments IN Varchar2
161 ,p_audit_flag IN Varchar2 := null
162 ,p_version_flag IN Varchar2 := null
163 ,p_phase_change_flag IN Varchar2 := null
164 ,p_version_number IN NUMBER := null
165 ,p_reason_id IN NUMBER := NULL
166 ,p_wf_activity_code IN Varchar2 := null
167 ,p_wf_result_code IN Varchar2 := null
168 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
169 );
170
171 Procedure RecordLPAdjHist
172 (p_line_adj_id In Number
173 ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE
174 := OE_Order_PUB.G_MISS_LINE_ADJ_REC
175 ,p_hist_type_code In Varchar2
176 ,p_reason_code In varchar2
177 ,p_comments IN Varchar2
178 ,p_audit_flag IN Varchar2 := null
179 ,p_version_flag IN Varchar2 := null
180 ,p_phase_change_flag IN Varchar2 := null
181 ,p_version_number IN NUMBER := null
182 ,p_reason_id IN NUMBER := NULL
183 ,p_wf_activity_code IN Varchar2 := null
184 ,p_wf_result_code IN Varchar2 := null
185 ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
186 );
187
188 -- Added to fix 2964593
189 PROCEDURE Reset_Audit_History_Flags;
190
191 /* End Audit Trail */
192
193 END;