DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_PVT dependencies on OE_ORDER_UTIL

Line 260: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

256: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
257: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
258:
259: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
260: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
261: p_line_id => l_line_id,
262: x_index => l_notify_index,
263: x_return_status => l_notify_status);
264:

Line 270: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
267: END IF;
268:
269: IF l_notify_index IS NOT NULL THEN
270: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
271: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
272: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
273: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
274: ELSE

Line 272: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

268:
269: IF l_notify_index IS NOT NULL THEN
270: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
271: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
272: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
273: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
274: ELSE
275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
276: END IF;

Line 275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

271: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
272: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
273: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
274: ELSE
275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
276: END IF;
277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

273: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
274: ELSE
275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
276: END IF;
277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

274: ELSE
275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
276: END IF;
277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
276: END IF;
277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
283: END IF;

Line 280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

276: END IF;
277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
283: END IF;
284:

Line 281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

277: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
283: END IF;
284:
285: END IF;

Line 282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

278: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
279: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
280: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
281: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
282: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
283: END IF;
284:
285: END IF;
286: ELSE -- system param on

Line 325: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

321: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
322: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
323:
324: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
325: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
326: p_line_id => l_line_id,
327: x_index => l_notify_index,
328: x_return_status => l_notify_status);
329:

Line 335: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: IF l_notify_index IS NOT NULL THEN
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
336: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
338: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
339: ELSE

Line 337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

333:
334: IF l_notify_index IS NOT NULL THEN
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
336: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
338: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
339: ELSE
340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
341: END IF;

Line 340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

336: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
338: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
339: ELSE
340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
341: END IF;
342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

338: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
339: ELSE
340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
341: END IF;
342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

339: ELSE
340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
341: END IF;
342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
341: END IF;
342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
348: END IF;

Line 345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

341: END IF;
342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
348: END IF;
349: END IF;

Line 346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

342: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
348: END IF;
349: END IF;
350:

Line 347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

343: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
344: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
345: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
346: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
347: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
348: END IF;
349: END IF;
350:
351: OPEN c_service_lines ;

Line 374: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

370: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
371: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
372:
373: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
374: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
375: p_line_id => l_line_id,
376: x_index => l_notify_index,
377: x_return_status => l_notify_status);
378:

Line 384: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: IF l_notify_index IS NOT NULL THEN
384: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
385: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
386: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
387: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
388: ELSE

Line 386: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

382:
383: IF l_notify_index IS NOT NULL THEN
384: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
385: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
386: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
387: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
388: ELSE
389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
390: END IF;

Line 389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

385: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
386: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
387: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
388: ELSE
389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
390: END IF;
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

387: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
388: ELSE
389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
390: END IF;
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

388: ELSE
389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
390: END IF;
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
390: END IF;
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
397: END IF;

Line 394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

390: END IF;
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
397: END IF;
398: END IF;

Line 395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

391: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
397: END IF;
398: END IF;
399: END LOOP;

Line 396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

392: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
394: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
395: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
397: END IF;
398: END IF;
399: END LOOP;
400: close c_service_lines;

Line 421: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

417: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
418: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
419:
420: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
421: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
422: p_line_id => l_line_id,
423: x_index => l_notify_index,
424: x_return_status => l_notify_status);
425:

Line 431: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: IF l_notify_index IS NOT NULL THEN
431: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
432: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
433: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
434: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
435: nvl(l_ordered_quantity,0)));

Line 433: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

429:
430: IF l_notify_index IS NOT NULL THEN
431: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
432: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
433: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
434: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
435: nvl(l_ordered_quantity,0)));
436: ELSE
437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

433: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
434: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
435: nvl(l_ordered_quantity,0)));
436: ELSE
437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
438: END IF;
439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

435: nvl(l_ordered_quantity,0)));
436: ELSE
437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
438: END IF;
439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

436: ELSE
437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
438: END IF;
439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

437: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
438: END IF;
439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
445: END IF;

Line 442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

438: END IF;
439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
445: END IF;
446:

Line 443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

439: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
445: END IF;
446:
447: END IF;

Line 444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

440: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
441: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
443: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
444: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
445: END IF;
446:
447: END IF;
448: --Entering service lines for parent line

Line 471: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

467: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
468: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
469:
470: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
471: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
472: p_line_id => l_line_id,
473: x_index => l_notify_index,
474: x_return_status => l_notify_status);
475:

Line 481: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: IF l_notify_index IS NOT NULL THEN
481: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
482: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
483: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
484: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
485: ELSE

Line 483: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

479:
480: IF l_notify_index IS NOT NULL THEN
481: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
482: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
483: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
484: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
485: ELSE
486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
487: END IF;

Line 486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

482: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
483: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
484: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
485: ELSE
486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
487: END IF;
488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

484: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
485: ELSE
486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
487: END IF;
488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

485: ELSE
486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
487: END IF;
488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
487: END IF;
488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
494:

Line 491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

487: END IF;
488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
494:
495: END IF;

Line 492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

488: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
494:
495: END IF;
496: END IF;

Line 493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
490: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
491: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
492: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
494:
495: END IF;
496: END IF;
497: END LOOP;