DBA Data[Home] [Help]

APPS.CS_WORKFLOW_PUB dependencies on FND_API

Line 15: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

11: -- p_wf_process_name must be a valid Workflow process based on the
12: -- Service Request item type.
13: -- Parameters :
14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
17: -- p_return_status OUT VARCHAR2 Required Length = 1
18: -- p_msg_count OUT NUMBER Required
19: -- p_msg_data OUT VARCHAR2 Required Length = 2000

Line 16: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

12: -- Service Request item type.
13: -- Parameters :
14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
17: -- p_return_status OUT VARCHAR2 Required Length = 1
18: -- p_msg_count OUT NUMBER Required
19: -- p_msg_data OUT VARCHAR2 Required Length = 2000
20: -- p_request_number IN VARCHAR2 Required

Line 25: -- p_nowait IN VARCHAR2 Optional Default = FND_API.G_FALSE

21: -- p_initiator_user_id IN NUMBER Optional Default NULL
22: -- p_initiator_resp_id IN NUMBER Optional Default NULL
23: -- p_initiator_resp_appl_id IN NUMBER Optional Default NULL
24: -- p_itemkey OUT VARCHAR2 Required Length = 240
25: -- p_nowait IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: --
27: -- Version : Initial Version 1.0
28: --
29: -- Notes : This procedure will try to lock the service request record because

Line 42: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

38: -- --------------------------------------------------------------------------------
39:
40: PROCEDURE Launch_Servereq_Workflow (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_msg_count OUT NOCOPY NUMBER,
46: p_msg_data OUT NOCOPY VARCHAR2,

Line 43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

39:
40: PROCEDURE Launch_Servereq_Workflow (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_msg_count OUT NOCOPY NUMBER,
46: p_msg_data OUT NOCOPY VARCHAR2,
47: p_request_number IN VARCHAR2,

Line 52: p_nowait IN VARCHAR2 DEFAULT FND_API.G_FALSE );

48: p_initiator_user_id IN NUMBER DEFAULT NULL,
49: p_initiator_resp_id IN NUMBER DEFAULT NULL,
50: p_initiator_resp_appl_id IN NUMBER DEFAULT NULL,
51: p_itemkey OUT NOCOPY VARCHAR2,
52: p_nowait IN VARCHAR2 DEFAULT FND_API.G_FALSE );
53:
54:
55: -- --------------------------------------------------------------------------------
56: -- Start of comments

Line 65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

61: -- request.
62: -- Pre-reqs :
63: -- Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_return_status OUT VARCHAR2 Required Length = 1
68: -- p_msg_count OUT NUMBER Required
69: -- p_msg_data OUT VARCHAR2 Required Length = 2000

Line 66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

62: -- Pre-reqs :
63: -- Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67: -- p_return_status OUT VARCHAR2 Required Length = 1
68: -- p_msg_count OUT NUMBER Required
69: -- p_msg_data OUT VARCHAR2 Required Length = 2000
70: -- p_request_number IN VARCHAR2 Required

Line 83: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

79: -- --------------------------------------------------------------------------------
80:
81: PROCEDURE Cancel_Servereq_Workflow (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_return_status OUT NOCOPY VARCHAR2,
86: p_msg_count OUT NOCOPY NUMBER,
87: p_msg_data OUT NOCOPY VARCHAR2,

Line 84: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

80:
81: PROCEDURE Cancel_Servereq_Workflow (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_return_status OUT NOCOPY VARCHAR2,
86: p_msg_count OUT NOCOPY NUMBER,
87: p_msg_data OUT NOCOPY VARCHAR2,
88: p_request_number IN VARCHAR2,

Line 103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

99: -- number, and workflow process ID.
100: -- Pre-reqs : None
101: -- Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_return_status OUT VARCHAR2 Required Length = 1
105: -- p_msg_count OUT NUMBER Required
106: -- p_msg_data OUT VARCHAR2 Required Length = 2000
107: -- p_itemkey IN VARCHAR2 Requried

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

116: -- --------------------------------------------------------------------------------
117:
118: PROCEDURE Decode_Servereq_Itemkey(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121: p_return_status OUT NOCOPY VARCHAR2,
122: p_msg_count OUT NOCOPY NUMBER,
123: p_msg_data OUT NOCOPY VARCHAR2,
124: p_itemkey IN VARCHAR2,

Line 139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

135: -- itemkey for the Service Request item type.
136: -- Pre-reqs : None
137: -- Parameters :
138: -- p_api_version IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_return_status OUT VARCHAR2 Required Length = 1
141: -- p_msg_count OUT NUMBER Required
142: -- p_msg_data OUT VARCHAR2 Required Length = 2000
143: -- p_request_number IN VARCHAR2 Required

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

152: -- --------------------------------------------------------------------------------
153:
154: PROCEDURE Encode_Servereq_Itemkey(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,
160: p_request_number IN VARCHAR2,

Line 174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

170: -- Description : Get the Workflow role name of the given employee
171: -- Pre-reqs : None
172: -- Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_return_status OUT VARCHAR2 Required Length = 1
176: -- p_msg_count OUT NUMBER Required
177: -- p_msg_data OUT VARCHAR2 Required Length = 2000
178: -- p_employee_id IN NUMBER Optional Default = NULL

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

201: -- --------------------------------------------------------------------------------
202:
203: PROCEDURE Get_Employee_Role (
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
206: p_return_status OUT NOCOPY VARCHAR2,
207: p_msg_count OUT NOCOPY NUMBER,
208: p_msg_data OUT NOCOPY VARCHAR2,
209: p_employee_id IN NUMBER DEFAULT NULL,

Line 226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

222: -- Workflow display name of the supervisor.
223: -- Pre-reqs : None
224: -- Parameters :
225: -- p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_return_status OUT VARCHAR2 Required Length = 1
228: -- p_msg_count OUT NUMBER Required
229: -- p_msg_data OUT VARCHAR2 Required Length = 2000
230: -- p_employee_id IN NUMBER Optional Default = NULL

Line 255: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

251: -- --------------------------------------------------------------------------------
252:
253: PROCEDURE Get_Emp_Supervisor(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
256: p_return_status OUT NOCOPY VARCHAR2,
257: p_msg_count OUT NOCOPY NUMBER,
258: p_msg_data OUT NOCOPY VARCHAR2,
259: p_employee_id IN NUMBER DEFAULT NULL,

Line 275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

271: -- Description : Get the FND user ID of the given employee
272: -- Pre-reqs : None
273: -- Parameters :
274: -- p_api_version IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
276: -- p_return_status OUT VARCHAR2 Required Length = 1
277: -- p_msg_count OUT NUMBER Required
278: -- p_msg_data OUT VARCHAR2 Required Length = 2000
279: -- p_employee_id IN NUMBER Optional Default = NULL

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

300: -- --------------------------------------------------------------------------------
301:
302: PROCEDURE Get_Emp_Fnd_User_ID(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
305: p_return_status OUT NOCOPY VARCHAR2,
306: p_msg_count OUT NOCOPY NUMBER,
307: p_msg_data OUT NOCOPY VARCHAR2,
308: p_employee_id IN NUMBER DEFAULT NULL,

Line 328: -- Default = FND_API.G_FALSE

324: -- Service Request Action item type.
325: -- Parameters :
326: -- IN : p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_request_id IN NUMBER Required
332: -- p_action_number IN NUMBER Required

Line 330: -- Default = FND_API.G_FALSE

326: -- IN : p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_request_id IN NUMBER Required
332: -- p_action_number IN NUMBER Required
333: -- p_initiator_user_id IN NUMBER Optional
334: -- Default = NULL

Line 340: -- Default = FND_API.G_FALSE

336: -- Default = NULL
337: -- p_initiator_resp_appl_id IN NUMBER Optional
338: -- Default = NULL
339: -- p_launched_by_dispatch IN VARCHAR2 Optional
340: -- Default = FND_API.G_FALSE
341: -- p_nowait IN VARCHAR2 Optional
342: -- Default = FND_API.G_FALSE
343: --
344: -- OUT : p_return_status OUT VARCHAR2(1)

Line 342: -- Default = FND_API.G_FALSE

338: -- Default = NULL
339: -- p_launched_by_dispatch IN VARCHAR2 Optional
340: -- Default = FND_API.G_FALSE
341: -- p_nowait IN VARCHAR2 Optional
342: -- Default = FND_API.G_FALSE
343: --
344: -- OUT : p_return_status OUT VARCHAR2(1)
345: -- p_msg_count OUT NUMBER
346: -- p_msg_data OUT VARCHAR2(2000)

Line 366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

362: -------------------------------------------------------------------------------
363:
364: /*PROCEDURE Launch_Action_Workflow
365: ( p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
368: p_return_status OUT VARCHAR2,
369: p_msg_count OUT NUMBER,
370: p_msg_data OUT VARCHAR2,

Line 367: p_commit IN VARCHAR2 := FND_API.G_FALSE,

363:
364: /*PROCEDURE Launch_Action_Workflow
365: ( p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
368: p_return_status OUT VARCHAR2,
369: p_msg_count OUT NUMBER,
370: p_msg_data OUT VARCHAR2,
371: p_request_id IN NUMBER,

Line 376: p_launched_by_dispatch IN VARCHAR2 := FND_API.G_FALSE,

372: p_action_number IN NUMBER,
373: p_initiator_user_id IN NUMBER := NULL,
374: p_initiator_resp_id IN NUMBER := NULL,
375: p_initiator_resp_appl_id IN NUMBER := NULL,
376: p_launched_by_dispatch IN VARCHAR2 := FND_API.G_FALSE,
377: p_nowait IN VARCHAR2 := FND_API.G_FALSE,
378: p_itemkey OUT VARCHAR2
379: );*/
380:

Line 377: p_nowait IN VARCHAR2 := FND_API.G_FALSE,

373: p_initiator_user_id IN NUMBER := NULL,
374: p_initiator_resp_id IN NUMBER := NULL,
375: p_initiator_resp_appl_id IN NUMBER := NULL,
376: p_launched_by_dispatch IN VARCHAR2 := FND_API.G_FALSE,
377: p_nowait IN VARCHAR2 := FND_API.G_FALSE,
378: p_itemkey OUT VARCHAR2
379: );*/
380:
381:

Line 394: -- Default = FND_API.G_FALSE

390: -- Pre-reqs : None.
391: -- Parameters :
392: -- IN : p_api_version IN NUMBER Required
393: -- p_init_msg_list IN VARCHAR2 Optional
394: -- Default = FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: -- p_request_id IN NUMBER Required
398: -- p_action_number IN NUMBER Required

Line 396: -- Default = FND_API.G_FALSE

392: -- IN : p_api_version IN NUMBER Required
393: -- p_init_msg_list IN VARCHAR2 Optional
394: -- Default = FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: -- p_request_id IN NUMBER Required
398: -- p_action_number IN NUMBER Required
399: -- p_wf_process_id IN NUMBER Required
400: -- p_abort_user_id IN NUMBER Required

Line 416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

412: -------------------------------------------------------------------------------
413:
414: PROCEDURE Cancel_Action_Workflow
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_return_status OUT NOCOPY VARCHAR2,
419: p_msg_count OUT NOCOPY NUMBER,
420: p_msg_data OUT NOCOPY VARCHAR2,

Line 417: p_commit IN VARCHAR2 := FND_API.G_FALSE,

413:
414: PROCEDURE Cancel_Action_Workflow
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_return_status OUT NOCOPY VARCHAR2,
419: p_msg_count OUT NOCOPY NUMBER,
420: p_msg_data OUT NOCOPY VARCHAR2,
421: p_request_id IN NUMBER,

Line 440: -- Default = FND_API.G_FALSE

436: -- Pre-reqs : None
437: -- Parameters :
438: -- IN : p_api_version IN NUMBER Required
439: -- p_init_msg_list IN VARCHAR2 Optional
440: -- Default = FND_API.G_FALSE
441: -- p_itemkey IN VARCHAR2 Requried
442: --
443: -- OUT : p_return_status OUT VARCHAR2(1)
444: -- p_msg_count OUT NUMBER

Line 459: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

455: -------------------------------------------------------------------------------
456:
457: PROCEDURE Decode_Action_Itemkey
458: ( p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
460: p_return_status OUT NOCOPY VARCHAR2,
461: p_msg_count OUT NOCOPY NUMBER,
462: p_msg_data OUT NOCOPY VARCHAR2,
463: p_itemkey IN VARCHAR2,