93: -- Parameters :
94: --
95: -- Standard IN Parameters :
96: -- p_api_version IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
98: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
100: -- Based on this flag, the API will set the default attributes.
101: -- p_module_type In VARCHAR2 Default NULL
94: --
95: -- Standard IN Parameters :
96: -- p_api_version IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
98: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
100: -- Based on this flag, the API will set the default attributes.
101: -- p_module_type In VARCHAR2 Default NULL
102: -- This will be null.
95: -- Standard IN Parameters :
96: -- p_api_version IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
98: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
100: -- Based on this flag, the API will set the default attributes.
101: -- p_module_type In VARCHAR2 Default NULL
102: -- This will be null.
103: -- Standard OUT Parameters :
110: -- List of item attributes associated to visit task
111: --
112: PROCEDURE Check_Material_Aval (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: p_module_type IN VARCHAR2 := 'JSP',
118: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,
111: --
112: PROCEDURE Check_Material_Aval (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: p_module_type IN VARCHAR2 := 'JSP',
118: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,
119: x_return_status OUT NOCOPY VARCHAR2,
112: PROCEDURE Check_Material_Aval (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: p_module_type IN VARCHAR2 := 'JSP',
118: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
130: -- Parameters :
131: --
132: -- Standard IN Parameters :
133: -- p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
135: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
137: -- Based on this flag, the API will set the default attributes.
138: -- p_module_type In VARCHAR2 Default NULL
131: --
132: -- Standard IN Parameters :
133: -- p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
135: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
137: -- Based on this flag, the API will set the default attributes.
138: -- p_module_type In VARCHAR2 Default NULL
139: -- This will be null.
132: -- Standard IN Parameters :
133: -- p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
135: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
137: -- Based on this flag, the API will set the default attributes.
138: -- p_module_type In VARCHAR2 Default NULL
139: -- This will be null.
140: -- Standard OUT Parameters :
147: -- x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
148: --
149: PROCEDURE Get_Visit_Task_Materials (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
154: p_module_type IN VARCHAR2 := 'JSP',
155: p_visit_id IN NUMBER,
148: --
149: PROCEDURE Get_Visit_Task_Materials (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
154: p_module_type IN VARCHAR2 := 'JSP',
155: p_visit_id IN NUMBER,
156: x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
149: PROCEDURE Get_Visit_Task_Materials (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
154: p_module_type IN VARCHAR2 := 'JSP',
155: p_visit_id IN NUMBER,
156: x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
157: x_return_status OUT NOCOPY VARCHAR2,
168: -- Parameters :
169: --
170: -- Standard IN Parameters :
171: -- p_api_version IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
169: --
170: -- Standard IN Parameters :
171: -- p_api_version IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
177: -- This will be null.
170: -- Standard IN Parameters :
171: -- p_api_version IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
177: -- This will be null.
178: -- Standard OUT Parameters :
186: -- List of item attributes associated to visit task
187: --
188: PROCEDURE Check_Materials_For_All (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_module_type IN VARCHAR2 := 'JSP',
194: p_visit_id IN NUMBER,
187: --
188: PROCEDURE Check_Materials_For_All (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_module_type IN VARCHAR2 := 'JSP',
194: p_visit_id IN NUMBER,
195: x_task_matrl_aval_tbl OUT NOCOPY Material_Availability_Tbl,
188: PROCEDURE Check_Materials_For_All (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_module_type IN VARCHAR2 := 'JSP',
194: p_visit_id IN NUMBER,
195: x_task_matrl_aval_tbl OUT NOCOPY Material_Availability_Tbl,
196: x_return_status OUT NOCOPY VARCHAR2,
207: -- Parameters :
208: --
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
208: --
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
216: -- This will be null.
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
216: -- This will be null.
217: -- Standard OUT Parameters :
224: -- List of item attributes associated to visit task
225: --
226: PROCEDURE Schedule_Planned_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,
225: --
226: PROCEDURE Schedule_Planned_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,
233: x_return_status OUT NOCOPY VARCHAR2,
226: PROCEDURE Schedule_Planned_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
244: -- Parameters :
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
253: -- This will be null.
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
253: -- This will be null.
254: -- Standard OUT Parameters :
261: -- List of item attributes associated to visit task
262: --
263: PROCEDURE Schedule_All_Materials (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_module_type IN VARCHAR2 := 'JSP',
269: p_visit_id IN NUMBER,
262: --
263: PROCEDURE Schedule_All_Materials (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_module_type IN VARCHAR2 := 'JSP',
269: p_visit_id IN NUMBER,
270: x_planned_matrl_tbl OUT NOCOPY Planned_Matrl_Tbl,
263: PROCEDURE Schedule_All_Materials (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_module_type IN VARCHAR2 := 'JSP',
269: p_visit_id IN NUMBER,
270: x_planned_matrl_tbl OUT NOCOPY Planned_Matrl_Tbl,
271: x_return_status OUT NOCOPY VARCHAR2,