[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_ACTIONS_UTIL
Source
1 PACKAGE ENG_CHANGE_ACTIONS_UTIL AS
2 /* $Header: ENGUCCMS.pls 120.3 2005/12/22 04:25:34 lkasturi noship $ */
3
4 -- Global constants
5 G_ENG_APPR_TIME_OUT CONSTANT NUMBER := 8; -- Approval time out
6 -- Change action types
7 G_ACT_SUBMIT CONSTANT VARCHAR2(30) := 'SUBMIT';
8
9
10 G_ACT_IMP_FAILED CONSTANT VARCHAR2(30) := 'IMPLEMENTATION_FAILED';
11 G_ACT_IMP_IN_PROGRESS CONSTANT VARCHAR2(30) := 'IMPLEMENT_IN_PROGRESS';
12 G_ACT_PROPAGATE CONSTANT VARCHAR2(30) := 'PROPAGATE_ECO';
13
14 G_ACT_WF_STARTED CONSTANT VARCHAR2(30) := 'WF_STARTED';
15 G_ACT_WF_COMPLETED CONSTANT VARCHAR2(30) := 'WF_COMPLETED';
16 G_ACT_WF_APPROVED CONSTANT VARCHAR2(30) := 'WF_APPROVED';
17 G_ACT_WF_REJECTED CONSTANT VARCHAR2(30) := 'WF_REJECTED';
18 G_ACT_WF_ABORTED CONSTANT VARCHAR2(30) := 'WF_ABORTED';
19 G_ACT_WF_TIME_OUT CONSTANT VARCHAR2(30) := 'WF_TIME_OUT';
20 G_ACT_WF_TRANSFERRED CONSTANT VARCHAR2(30) := 'WF_TRANSFERRED';
21 G_ACT_WF_DELEGATED CONSTANT VARCHAR2(30) := 'WF_DELEGATED';
22
23
24 -- Action Types
25 G_ACT_COMMENT CONSTANT VARCHAR2(30) := 'COMMENT' ;
26 G_ACT_REPLIED CONSTANT VARCHAR2(30) := 'REPLIED' ; -- user response
27 G_ACT_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED' ; -- user response
28 G_ACT_COMPLETED CONSTANT VARCHAR2(30) := 'COMPLETED' ; -- user response
29 G_ACT_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED' ; -- user response
30 G_ACT_PROMOTE CONSTANT VARCHAR2(30) := 'PROMOTE' ;
31 G_ACT_DEMOTE CONSTANT VARCHAR2(30) := 'DEMOTE' ;
32 G_ACT_DELEGATED CONSTANT VARCHAR2(30) := 'DELEGATED' ; -- user response for ntf proxy
33 G_ACT_TRANSFERRED CONSTANT VARCHAR2(30) := 'TRANSFERRED' ; -- user response for ntf proxy
34
35
36 /********************************************************************
37 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
38 * Write_Debug
39 * Parameters IN :
40 * Parameters OUT:
41 * Purpose : These procedures are for test and debug
42 *********************************************************************/
43 -- Open_Debug_Session
44 PROCEDURE Open_Debug_Session
45 ( p_output_dir IN VARCHAR2 := NULL
46 , p_file_name IN VARCHAR2 := NULL
47 );
48
49 -- Close Debug_Session
50 PROCEDURE Close_Debug_Session ;
51
52 -- Write Debug Message
53 PROCEDURE Write_Debug
54 ( p_debug_message IN VARCHAR2 ) ;
55
56 -- Write Debug Mode from Workflow Function Activities
57 PROCEDURE Get_Debug_Mode
58 ( p_item_type IN VARCHAR2
59 , p_item_key IN VARCHAR2
60 , x_debug_flag OUT NOCOPY BOOLEAN
61 , x_output_dir OUT NOCOPY VARCHAR2
62 , x_debug_filename OUT NOCOPY VARCHAR2
63 );
64
65
66 /**
67 * Create new action row in the ENG_CHANGE_ACTIONS and its TL table
68 */
69 PROCEDURE Create_Change_Action
70 (
71 p_api_version IN NUMBER --
72 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
73 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
74 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
76 ,p_output_dir IN VARCHAR2 := NULL --
77 ,p_debug_filename IN VARCHAR2 := NULL --
78 ,x_return_status OUT NOCOPY VARCHAR2 --
79 ,x_msg_count OUT NOCOPY NUMBER --
80 ,x_msg_data OUT NOCOPY VARCHAR2 --
81 ,p_action_type IN VARCHAR2 --
82 ,p_object_name IN VARCHAR2 --
83 ,p_object_id1 IN NUMBER --
84 ,p_object_id2 IN NUMBER DEFAULT NULL --
85 ,p_object_id3 IN NUMBER DEFAULT NULL --
86 ,p_object_id4 IN NUMBER DEFAULT NULL --
87 ,p_object_id5 IN NUMBER DEFAULT NULL --
88 ,p_parent_action_id IN NUMBER DEFAULT -1 --
89 ,p_status_code IN NUMBER DEFAULT NULL --
90 ,p_priority_code IN VARCHAR2 DEFAULT NULL --
91 ,p_assignee_id IN NUMBER DEFAULT NULL --
92 ,p_response_by_date IN DATE DEFAULT NULL --
93 ,p_party_id_list IN VARCHAR2 DEFAULT NULL --
94 ,p_parent_status_code IN NUMBER DEFAULT NULL --
95 ,p_workflow_item_type IN VARCHAR2 DEFAULT NULL --
96 ,p_workflow_item_key IN VARCHAR2 DEFAULT NULL --
97 ,p_route_id IN NUMBER DEFAULT NULL --
98 ,p_action_date IN DATE DEFAULT SYSDATE --
99 ,p_change_description IN VARCHAR2 DEFAULT NULL --
100 ,p_user_id IN NUMBER DEFAULT NULL --
101 ,p_api_caller IN VARCHAR2 DEFAULT NULL --
102 ,p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
103 ,p_local_organization_id IN NUMBER DEFAULT NULL --Bug 4704384
104 ,x_change_action_id OUT NOCOPY NUMBER --
105 );
106
107
108 /**
109 * Called right after creating action and submitting workflow
110 * to update the workflow-related columns value given the change_action_id
111 */
112 PROCEDURE Update_Workflow_Info
113 (
114 p_api_version IN NUMBER --
115 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
116 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
117 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
118 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
119 ,p_output_dir IN VARCHAR2 := '/nfs/log/bis_top/utl/plm115dv/log' --
120 ,p_debug_filename IN VARCHAR2 := 'eng.chgmt.action.wf.log'
121 ,x_return_status OUT NOCOPY VARCHAR2 --
122 ,x_msg_count OUT NOCOPY NUMBER --
123 ,x_msg_data OUT NOCOPY VARCHAR2 --
124 ,p_change_action_id IN NUMBER --
125 ,p_workflow_item_type IN VARCHAR2 DEFAULT NULL --
126 ,p_workflow_item_key IN VARCHAR2 DEFAULT NULL --
127 );
128
129
130 /**
131 * If the responder is on the comment request party list, this procedure
132 * updates the workflow notification with the response comment, and returns
133 * the corresponding notification id;
134 * otherwise no update is performed and notification_id is returned as null
135 */
136 PROCEDURE Respond_Notification
137 (
138 p_api_version IN NUMBER --
139 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
140 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
141 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
142 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
143 ,p_output_dir IN VARCHAR2 := '/nfs/log/bis_top/utl/plm115dv/log'
144 ,p_debug_filename IN VARCHAR2 := 'eng.chgmt.action.respNotif.log'
145 ,x_return_status OUT NOCOPY VARCHAR2 --
146 ,x_msg_count OUT NOCOPY NUMBER --
147 ,x_msg_data OUT NOCOPY VARCHAR2 --
148 ,p_parent_action_id IN NUMBER --
149 ,p_comment IN VARCHAR2 DEFAULT NULL --
150 ,p_fnd_user_name IN VARCHAR2 --
151 ,x_processed_ntf_id OUT NOCOPY NUMBER --
152 );
153
154
155 /**
156 * -- Workflow Utility Function
157 * Get notification id given workflow item type, workflow item key,
158 * and current logon user name, returns null if id doesn't exist
159 */
160 /*
161 FUNCTION Get_Workflow_Notif_Id
162 (
163 p_workflow_item_type IN VARCHAR2 --
164 ,p_workflow_item_key IN VARCHAR2 --
165 ,p_username IN VARCHAR2 --
166 ) RETURN NUMBER; --
167 */
168
169 /**
170 * Called when a line is deleted
171 * to delete all the action log entries associated with that line
172 */
173 PROCEDURE Delete_Line_Actions
174 (
175 p_api_version IN NUMBER --
176 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
177 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
178 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
180 ,p_output_dir IN VARCHAR2 := '/nfs/log/bis_top/utl/plm115dv/log' --
181 ,p_debug_filename IN VARCHAR2 := 'eng.chgmt.action.line.log'
182 ,x_return_status OUT NOCOPY VARCHAR2 --
183 ,x_msg_count OUT NOCOPY NUMBER --
184 ,x_msg_data OUT NOCOPY VARCHAR2 --
185 ,p_change_id IN NUMBER
186 ,p_change_line_id IN NUMBER
187 );
188
189 END ENG_CHANGE_ACTIONS_UTIL;
190