DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

7: -- Return Value : N/A
8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 := 'N'

Line 12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 := 'N'
16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 47: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

43:
44: procedure Create_Relationship
45: (
46: p_api_version IN NUMBER := 1.0
47: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
48: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
50: ,p_validation_level IN VARCHAR2 := 100
51: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

44: procedure Create_Relationship
45: (
46: p_api_version IN NUMBER := 1.0
47: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
48: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
50: ,p_validation_level IN VARCHAR2 := 100
51: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
52: ,p_debug_mode IN VARCHAR2 := 'N'

Line 49: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

45: (
46: p_api_version IN NUMBER := 1.0
47: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
48: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
50: ,p_validation_level IN VARCHAR2 := 100
51: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
52: ,p_debug_mode IN VARCHAR2 := 'N'
53: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 84: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

80: -- Pre-reqs : None
81: -- Return Value : N/A
82: -- Parameters
83: -- p_api_version IN NUMBER := 1.0
84: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
87: -- p_validation_level IN VARCHAR2 := 100
88: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 85: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

81: -- Return Value : N/A
82: -- Parameters
83: -- p_api_version IN NUMBER := 1.0
84: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
87: -- p_validation_level IN VARCHAR2 := 100
88: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 := 'N'

Line 86: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

82: -- Parameters
83: -- p_api_version IN NUMBER := 1.0
84: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
87: -- p_validation_level IN VARCHAR2 := 100
88: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 := 'N'
90: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

115:
116: procedure Update_Relationship
117: (
118: p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN VARCHAR2 := 100
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

116: procedure Update_Relationship
117: (
118: p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN VARCHAR2 := 100
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'

Line 121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

117: (
118: p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN VARCHAR2 := 100
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 153: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

149: -- Pre-reqs : None
150: -- Return Value : N/A
151: -- Parameters
152: -- p_api_version IN NUMBER := 1.0
153: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
154: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
155: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
156: -- p_validation_level IN VARCHAR2 := 100
157: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 154: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

150: -- Return Value : N/A
151: -- Parameters
152: -- p_api_version IN NUMBER := 1.0
153: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
154: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
155: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
156: -- p_validation_level IN VARCHAR2 := 100
157: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
158: -- p_debug_mode IN VARCHAR2 := 'N'

Line 155: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

151: -- Parameters
152: -- p_api_version IN NUMBER := 1.0
153: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
154: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
155: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
156: -- p_validation_level IN VARCHAR2 := 100
157: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
158: -- p_debug_mode IN VARCHAR2 := 'N'
159: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

172:
173: procedure Delete_Relationship
174: (
175: p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN VARCHAR2 := 100
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

173: procedure Delete_Relationship
174: (
175: p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN VARCHAR2 := 100
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'

Line 178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

174: (
175: p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN VARCHAR2 := 100
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 196: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

192: -- Pre-reqs : None
193: -- Return Value : N/A
194: -- Parameters
195: -- p_api_version IN NUMBER := 1.0
196: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
198: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
199: -- p_validation_level IN VARCHAR2 := 100
200: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 197: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

193: -- Return Value : N/A
194: -- Parameters
195: -- p_api_version IN NUMBER := 1.0
196: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
198: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
199: -- p_validation_level IN VARCHAR2 := 100
200: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
201: -- p_debug_mode IN VARCHAR2 := 'N'

Line 198: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

194: -- Parameters
195: -- p_api_version IN NUMBER := 1.0
196: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
198: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
199: -- p_validation_level IN VARCHAR2 := 100
200: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
201: -- p_debug_mode IN VARCHAR2 := 'N'
202: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

221:
222: procedure Create_dependency
223: (
224: p_api_version IN NUMBER := 1.0
225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
228: ,p_validation_level IN VARCHAR2 := 100
229: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

222: procedure Create_dependency
223: (
224: p_api_version IN NUMBER := 1.0
225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
228: ,p_validation_level IN VARCHAR2 := 100
229: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
230: ,p_debug_mode IN VARCHAR2 := 'N'

Line 227: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

223: (
224: p_api_version IN NUMBER := 1.0
225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
228: ,p_validation_level IN VARCHAR2 := 100
229: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
230: ,p_debug_mode IN VARCHAR2 := 'N'
231: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 251: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

247: -- Pre-reqs : None
248: -- Return Value : N/A
249: -- Parameters
250: -- p_api_version IN NUMBER := 1.0
251: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
252: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
253: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
254: -- p_validation_level IN VARCHAR2 := 100
255: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 252: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

248: -- Return Value : N/A
249: -- Parameters
250: -- p_api_version IN NUMBER := 1.0
251: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
252: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
253: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
254: -- p_validation_level IN VARCHAR2 := 100
255: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
256: -- p_debug_mode IN VARCHAR2 := 'N'

Line 253: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

249: -- Parameters
250: -- p_api_version IN NUMBER := 1.0
251: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
252: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
253: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
254: -- p_validation_level IN VARCHAR2 := 100
255: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
256: -- p_debug_mode IN VARCHAR2 := 'N'
257: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 277: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

273:
274: procedure Update_dependency
275: (
276: p_api_version IN NUMBER := 1.0
277: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
278: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
279: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
280: ,p_validation_level IN VARCHAR2 := 100
281: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

274: procedure Update_dependency
275: (
276: p_api_version IN NUMBER := 1.0
277: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
278: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
279: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
280: ,p_validation_level IN VARCHAR2 := 100
281: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
282: ,p_debug_mode IN VARCHAR2 := 'N'

Line 279: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

275: (
276: p_api_version IN NUMBER := 1.0
277: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
278: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
279: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
280: ,p_validation_level IN VARCHAR2 := 100
281: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
282: ,p_debug_mode IN VARCHAR2 := 'N'
283: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 301: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

297: -- Pre-reqs : None
298: -- Return Value : N/A
299: -- Parameters
300: -- p_api_version IN NUMBER := 1.0
301: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
302: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
303: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
304: -- p_validation_level IN VARCHAR2 := 100
305: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 302: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

298: -- Return Value : N/A
299: -- Parameters
300: -- p_api_version IN NUMBER := 1.0
301: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
302: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
303: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
304: -- p_validation_level IN VARCHAR2 := 100
305: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
306: -- p_debug_mode IN VARCHAR2 := 'N'

Line 303: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

299: -- Parameters
300: -- p_api_version IN NUMBER := 1.0
301: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
302: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
303: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
304: -- p_validation_level IN VARCHAR2 := 100
305: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
306: -- p_debug_mode IN VARCHAR2 := 'N'
307: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

319:
320: procedure Delete_Dependency
321: (
322: p_api_version IN NUMBER := 1.0
323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
324: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
325: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
326: ,p_validation_level IN VARCHAR2 := 100
327: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

320: procedure Delete_Dependency
321: (
322: p_api_version IN NUMBER := 1.0
323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
324: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
325: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
326: ,p_validation_level IN VARCHAR2 := 100
327: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
328: ,p_debug_mode IN VARCHAR2 := 'N'

Line 325: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

321: (
322: p_api_version IN NUMBER := 1.0
323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
324: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
325: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
326: ,p_validation_level IN VARCHAR2 := 100
327: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
328: ,p_debug_mode IN VARCHAR2 := 'N'
329: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 380: -- p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

376: -- Pre-reqs : None
377: -- Return Value : N/A
378: -- Parameters
379: -- p_api_version IN NUMBER :=1.0
380: -- p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: -- p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
382: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
383: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
384: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE

Line 381: -- p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

377: -- Return Value : N/A
378: -- Parameters
379: -- p_api_version IN NUMBER :=1.0
380: -- p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: -- p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
382: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
383: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
384: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
385: -- p_debug_mode IN VARCHAR2 :='N'

Line 382: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

378: -- Parameters
379: -- p_api_version IN NUMBER :=1.0
380: -- p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: -- p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
382: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
383: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
384: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
385: -- p_debug_mode IN VARCHAR2 :='N'
386: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 384: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE

380: -- p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: -- p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
382: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
383: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
384: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
385: -- p_debug_mode IN VARCHAR2 :='N'
386: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
387: -- p_src_proj_id IN pa_projects_all.project_id%type
388: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type

Line 406: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

402: --
403: --
404: --
405: Procedure Create_Subproject_Association(p_api_version IN NUMBER :=1.0,
406: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
407: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
408: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409: p_validation_level IN VARCHAR2 := 100,
410: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

Line 407: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

403: --
404: --
405: Procedure Create_Subproject_Association(p_api_version IN NUMBER :=1.0,
406: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
407: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
408: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409: p_validation_level IN VARCHAR2 := 100,
410: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

Line 408: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

404: --
405: Procedure Create_Subproject_Association(p_api_version IN NUMBER :=1.0,
406: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
407: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
408: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409: p_validation_level IN VARCHAR2 := 100,
410: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
412: p_debug_mode IN VARCHAR2 :='N',

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

407: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
408: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409: p_validation_level IN VARCHAR2 := 100,
410: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
412: p_debug_mode IN VARCHAR2 :='N',
413: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
414: p_src_proj_id IN pa_projects_all.project_id%type,
415: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,

Line 428: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

424: -- Type : Private Procedure
425: -- Pre-reqs : None
426: -- Return Value : N/A
427: -- Parameters
428: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
429: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
430: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
431: -- p_validation_level IN VARCHAR2 := 100
432: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 429: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

425: -- Pre-reqs : None
426: -- Return Value : N/A
427: -- Parameters
428: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
429: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
430: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
431: -- p_validation_level IN VARCHAR2 := 100
432: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
433: -- p_debug_mode IN VARCHAR2 := 'N'

Line 430: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

426: -- Return Value : N/A
427: -- Parameters
428: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
429: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
430: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
431: -- p_validation_level IN VARCHAR2 := 100
432: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
433: -- p_debug_mode IN VARCHAR2 := 'N'
434: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 461: /*PROCEDURE Insert_Subproject_Association(p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

457: -- -Created this procedure for subproject association
458: --
459: -- FPM bug 3450684
460: --
461: /*PROCEDURE Insert_Subproject_Association(p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
462: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
463: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
464: ,p_validation_level IN VARCHAR2 := 100
465: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

458: --
459: -- FPM bug 3450684
460: --
461: /*PROCEDURE Insert_Subproject_Association(p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
462: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
463: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
464: ,p_validation_level IN VARCHAR2 := 100
465: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
466: ,p_debug_mode IN VARCHAR2 := 'N'

Line 463: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

459: -- FPM bug 3450684
460: --
461: /*PROCEDURE Insert_Subproject_Association(p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
462: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
463: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
464: ,p_validation_level IN VARCHAR2 := 100
465: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
466: ,p_debug_mode IN VARCHAR2 := 'N'
467: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 494: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

490: -- Pre-reqs : None
491: -- Return Value : N/A
492: -- Parameters
493: -- p_api_version IN NUMBER := 1.0
494: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
495: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
496: -- p_validation_level IN VARCHAR2 := 100
497: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
498: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 495: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

491: -- Return Value : N/A
492: -- Parameters
493: -- p_api_version IN NUMBER := 1.0
494: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
495: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
496: -- p_validation_level IN VARCHAR2 := 100
497: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
498: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
499: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 499: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

495: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
496: -- p_validation_level IN VARCHAR2 := 100
497: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
498: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
499: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
500: -- p_debug_mode IN VARCHAR2 := 'N'
501: -- p_object_relationship_id IN NUMBER
502: -- p_record_version_number IN NUMBER
503: -- p_comment IN VARCHAR2

Line 516: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

512: --
513: -- FPM bug 3450684
514: --
515: Procedure Update_Subproject_Association(p_api_version IN NUMBER := 1.0,
516: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
517: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
518: p_validation_level IN VARCHAR2 := 100,
519: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
520: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 517: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

513: -- FPM bug 3450684
514: --
515: Procedure Update_Subproject_Association(p_api_version IN NUMBER := 1.0,
516: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
517: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
518: p_validation_level IN VARCHAR2 := 100,
519: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
520: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
521: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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

517: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
518: p_validation_level IN VARCHAR2 := 100,
519: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
520: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
522: p_debug_mode IN VARCHAR2 := 'N',
523: p_object_relationship_id IN NUMBER,
524: p_record_version_number IN NUMBER,
525: p_comment IN VARCHAR2,

Line 535: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

531: -- Type : Private Procedure
532: -- Pre-reqs : None
533: -- Return Value : N/A
534: -- Parameters
535: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
536: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
537: -- p_validation_level IN VARCHAR2 := 100
538: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
539: -- p_debug_mode IN VARCHAR2 := 'N'

Line 536: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

532: -- Pre-reqs : None
533: -- Return Value : N/A
534: -- Parameters
535: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
536: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
537: -- p_validation_level IN VARCHAR2 := 100
538: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
539: -- p_debug_mode IN VARCHAR2 := 'N'
540: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 553: Procedure Delete_SubProject_Association(p_commit IN VARCHAR2 := FND_API.G_FALSE,

549: -- 20-Feb-04 Smukka -Created
550: -- -Created this procedure for subproject association
551: --
552: -- FPM bug 3450684
553: Procedure Delete_SubProject_Association(p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
555: p_validation_level IN VARCHAR2 := 100,
556: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
557: p_debug_mode IN VARCHAR2 := 'N',

Line 554: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

550: -- -Created this procedure for subproject association
551: --
552: -- FPM bug 3450684
553: Procedure Delete_SubProject_Association(p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
555: p_validation_level IN VARCHAR2 := 100,
556: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
557: p_debug_mode IN VARCHAR2 := 'N',
558: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 566: Procedure Copy_OG_Lnk_For_Subproj_Ass(p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

562: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
563: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
564: --
565: --
566: Procedure Copy_OG_Lnk_For_Subproj_Ass(p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
567: p_validation_level IN VARCHAR2 := 100,
568: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
569: p_debug_mode IN VARCHAR2 := 'N',
570: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

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

567: p_validation_level IN VARCHAR2 := 100,
568: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
569: p_debug_mode IN VARCHAR2 := 'N',
570: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
571: p_commit IN VARCHAR2 := FND_API.G_FALSE,
572: p_src_str_version_id IN NUMBER,
573: p_dest_str_version_id IN NUMBER, -- Destination Str version id can be of published str also
574: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
575: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 580: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

576: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
577: --
578: --
579: PROCEDURE Move_CI_Lnk_For_subproj_step1(p_api_version IN NUMBER :=1.0,
580: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
581: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
582: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
583: p_validation_level IN VARCHAR2 := 100,
584: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

Line 581: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

577: --
578: --
579: PROCEDURE Move_CI_Lnk_For_subproj_step1(p_api_version IN NUMBER :=1.0,
580: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
581: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
582: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
583: p_validation_level IN VARCHAR2 := 100,
584: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
585: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

Line 582: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

578: --
579: PROCEDURE Move_CI_Lnk_For_subproj_step1(p_api_version IN NUMBER :=1.0,
580: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
581: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
582: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
583: p_validation_level IN VARCHAR2 := 100,
584: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
585: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
586: p_debug_mode IN VARCHAR2 :='N',

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

581: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
582: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
583: p_validation_level IN VARCHAR2 := 100,
584: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
585: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
586: p_debug_mode IN VARCHAR2 :='N',
587: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
588: p_src_str_version_id IN NUMBER,
589: p_pub_str_version_id IN NUMBER, --published str, which is destination

Line 596: /*PROCEDURE Move_CI_Lnk_For_subproj_step2(p_commit IN VARCHAR2 := FND_API.G_FALSE,

592: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
593: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
594: --
595: --
596: /*PROCEDURE Move_CI_Lnk_For_subproj_step2(p_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
598: p_validation_level IN VARCHAR2 := 100,
599: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
600: p_debug_mode IN VARCHAR2 := 'N',

Line 597: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

593: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
594: --
595: --
596: /*PROCEDURE Move_CI_Lnk_For_subproj_step2(p_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
598: p_validation_level IN VARCHAR2 := 100,
599: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
600: p_debug_mode IN VARCHAR2 := 'N',
601: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 619: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

615: -- Pre-reqs : None
616: -- Return Value : N/A
617: -- Parameters
618: -- p_api_version IN NUMBER := 1.0
619: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
620: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
621: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
622: -- p_validation_level IN VARCHAR2 := 100
623: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 620: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

616: -- Return Value : N/A
617: -- Parameters
618: -- p_api_version IN NUMBER := 1.0
619: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
620: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
621: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
622: -- p_validation_level IN VARCHAR2 := 100
623: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
624: -- p_debug_mode IN VARCHAR2 := 'N'

Line 621: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

617: -- Parameters
618: -- p_api_version IN NUMBER := 1.0
619: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
620: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
621: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
622: -- p_validation_level IN VARCHAR2 := 100
623: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
624: -- p_debug_mode IN VARCHAR2 := 'N'
625: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 645: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

641:
642: procedure UPDATE_PARENT_WBS_FLAG_DIRTY
643: (
644: p_api_version IN NUMBER := 1.0
645: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
646: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
647: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
648: ,p_validation_level IN VARCHAR2 := 100
649: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

642: procedure UPDATE_PARENT_WBS_FLAG_DIRTY
643: (
644: p_api_version IN NUMBER := 1.0
645: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
646: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
647: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
648: ,p_validation_level IN VARCHAR2 := 100
649: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
650: ,p_debug_mode IN VARCHAR2 := 'N'

Line 647: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

643: (
644: p_api_version IN NUMBER := 1.0
645: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
646: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
647: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
648: ,p_validation_level IN VARCHAR2 := 100
649: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
650: ,p_debug_mode IN VARCHAR2 := 'N'
651: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM