DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on FND_API

Line 24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

20: -- Parameters :
21: --
22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL

Line 25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

21: --
22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL
29: -- This will be null.

Line 26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL
29: -- This will be null.
30: -- Standard out Parameters :

Line 40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

36: --
37: --
38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,

Line 41: p_commit IN VARCHAR2 := FND_API.g_false,

37: --
38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,
45: p_org_id IN NUMBER := NULL,

Line 42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,
45: p_org_id IN NUMBER := NULL,
46: p_start_date IN DATE := NULL,

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

61: -- Parameters :
62: --
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL

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

62: --
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL
70: -- This will be null.

Line 67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL
70: -- This will be null.
71: -- Standard out Parameters :

Line 82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

78: --
79: --
80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,

Line 83: p_commit IN VARCHAR2 := FND_API.g_false,

79: --
80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,

Line 84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2);

Line 101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

97: -- Parameters :
98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.

Line 102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.
106: -- Standard out Parameters :

Line 103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.
106: -- Standard out Parameters :
107: -- x_return_status OUT VARCHAR2 Required

Line 117: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

113: -- p_visit_task_id IN NUMBER, Optional
114: --
115: PROCEDURE Unschedule_visit_Task_Items
116: (p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
119: p_visit_id IN NUMBER,
120: p_visit_task_id IN NUMBER := NULL,
121: x_return_status OUT NOCOPY VARCHAR2,

Line 118: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

114: --
115: PROCEDURE Unschedule_visit_Task_Items
116: (p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
119: p_visit_id IN NUMBER,
120: p_visit_task_id IN NUMBER := NULL,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

Line 136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

132: -- Parameters :
133: --
134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL

Line 137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

133: --
134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL
141: -- This will be null.

Line 138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL
141: -- This will be null.
142: -- Standard out Parameters :

Line 153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

149: --
150: --
151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,

Line 154: p_commit IN VARCHAR2 := FND_API.g_false,

150: --
151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,
158: p_start_time IN DATE := NULL,

Line 155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,
158: p_start_time IN DATE := NULL,
159: p_org_id IN NUMBER := NULL,

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

170: -- Parameters :
171: --
172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL

Line 175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

171: --
172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL
179: -- This will be null.

Line 176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL
179: -- This will be null.
180: -- Standard out Parameters :

Line 195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

191: --
192: --
193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,

Line 196: p_commit IN VARCHAR2 := FND_API.g_false,

192: --
193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,
200: p_start_time IN DATE := NULL,

Line 197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,
200: p_start_time IN DATE := NULL,
201: p_org_id IN NUMBER := NULL,

Line 217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

213: -- Parameters :
214: --
215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL

Line 218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

214: --
215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL
222: -- This will be null.

Line 219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL
222: -- This will be null.
223: -- Standard out Parameters :

Line 234: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

230: --
231: --
232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235: p_commit IN VARCHAR2 := FND_API.g_false,
236: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
237: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,

Line 235: p_commit IN VARCHAR2 := FND_API.g_false,

231: --
232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235: p_commit IN VARCHAR2 := FND_API.g_false,
236: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
237: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,
239: x_planned_order_flag OUT NOCOPY VARCHAR2 ,

Line 236: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235: p_commit IN VARCHAR2 := FND_API.g_false,
236: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
237: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,
239: x_planned_order_flag OUT NOCOPY VARCHAR2 ,
240: x_return_status OUT NOCOPY VARCHAR2,

Line 254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

250: -- Parameters :
251: --
252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL

Line 255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

251: --
252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL
259: -- This will be null.

Line 256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL
259: -- This will be null.
260: -- Standard out Parameters :

Line 271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

267: --
268: --
269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,

Line 272: p_commit IN VARCHAR2 := FND_API.g_false,

268: --
269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,

Line 273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2);

Line 290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

286: -- Parameters :
287: --
288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :

Line 291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

287: --
288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :
295: -- x_return_status OUT VARCHAR2 Required

Line 292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :
295: -- x_return_status OUT VARCHAR2 Required
296: -- x_msg_count OUT NUMBER Required

Line 309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

305: -------------------------------------------------------------------
306:
307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,

Line 310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

306:
307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,
314: x_return_status OUT NOCOPY VARCHAR2,

Line 311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,

Line 328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

324: -- Parameters :
325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
330: -- p_module_type IN VARCHAR2 Default Null
331: --
332: -- Standard OUT Parameters :

Line 329: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
330: -- p_module_type IN VARCHAR2 Default Null
331: --
332: -- Standard OUT Parameters :
333: -- x_return_status OUT VARCHAR2 Required

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

343: --
344: -------------------------------------------------------------------
345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,

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

344: -------------------------------------------------------------------
345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,
352: p_mr_header_id IN NUMBER,

Line 349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,
352: p_mr_header_id IN NUMBER,
353: p_instance_id IN NUMBER,

Line 368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

364: -- Parameters :
365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_module_type IN VARCHAR2 Default Null
371: --
372: -- Standard OUT Parameters :

Line 369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_module_type IN VARCHAR2 Default Null
371: --
372: -- Standard OUT Parameters :
373: -- x_return_status OUT VARCHAR2 Required

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

383: --
384: -------------------------------------------------------------------
385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,

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

384: -------------------------------------------------------------------
385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,
392: p_mr_header_id IN NUMBER,

Line 389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,
392: p_mr_header_id IN NUMBER,
393: p_instance_id IN NUMBER,

Line 410: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

406: -- Parameters :
407: --
408: -- Standard IN Parameters :
409: -- p_api_version IN NUMBER Required
410: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
411: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
412: -- p_module_type IN VARCHAR2 Default Null
413: --
414: -- Standard OUT Parameters :

Line 411: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

407: --
408: -- Standard IN Parameters :
409: -- p_api_version IN NUMBER Required
410: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
411: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
412: -- p_module_type IN VARCHAR2 Default Null
413: --
414: -- Standard OUT Parameters :
415: -- x_return_status OUT VARCHAR2 Required

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

421: --
422: -------------------------------------------------------------------
423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,

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

422: -------------------------------------------------------------------
423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,
430: x_return_status OUT NOCOPY VARCHAR2,

Line 427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,