eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CONFIG_SCHEDULE_PVT dependencies on OE_GLOBALS

Line 105: OE_GLOBALS.G_GROUP_SCHEDULE

101: WHILE K is not null
102: LOOP
103:
104: IF (OE_Delayed_Requests_PVT.G_Delayed_Requests(K).request_type =
105: OE_GLOBALS.G_GROUP_SCHEDULE
106: OR (OE_Delayed_Requests_PVT.G_Delayed_Requests(K).request_type =
107: OE_GLOBALS.G_SCHEDULE_LINE
108: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(K).entity_id = p_ato_line_id))
109: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(K).param1 = p_set_id

Line 107: OE_GLOBALS.G_SCHEDULE_LINE

103:
104: IF (OE_Delayed_Requests_PVT.G_Delayed_Requests(K).request_type =
105: OE_GLOBALS.G_GROUP_SCHEDULE
106: OR (OE_Delayed_Requests_PVT.G_Delayed_Requests(K).request_type =
107: OE_GLOBALS.G_SCHEDULE_LINE
108: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(K).entity_id = p_ato_line_id))
109: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(K).param1 = p_set_id
110: THEN
111: RETURN TRUE;

Line 307: NOT OE_GLOBALS.EQUAL(p_line_rec.reserved_quantity,

303:
304:
305: -- log Reservation / ord qty changes
306: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE OR
307: NOT OE_GLOBALS.EQUAL(p_line_rec.reserved_quantity,
308: p_old_line_rec.reserved_quantity)) AND
309: p_line_rec.top_model_line_id <> nvl(p_line_rec.ato_line_id, -1)
310:
311: THEN

Line 322: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

318:
319: -- ato_line_id can be incorrect rarely
320:
321: IF OE_Config_Util.G_Config_UI_Used = 'N' AND
322: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
323: p_line_rec.ship_model_complete_flag = 'N' AND
324: p_line_rec.ato_line_id is not NULL
325: THEN
326: IF p_line_rec.item_type_code = 'CLASS' OR

Line 346: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

342: END IF;
343:
344: -- 4052648 : Parameters p_param14 - 17 are added
345: OE_Delayed_Requests_Pvt.Log_Request
346: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
347: p_entity_id => p_line_rec.top_model_line_id,
348: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
349: p_requesting_entity_id => p_line_rec.line_id,
350: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC,

Line 348: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

344: -- 4052648 : Parameters p_param14 - 17 are added
345: OE_Delayed_Requests_Pvt.Log_Request
346: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
347: p_entity_id => p_line_rec.top_model_line_id,
348: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
349: p_requesting_entity_id => p_line_rec.line_id,
350: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC,
351: p_param1 => l_sch_action,
352: p_param2 => p_line_rec.top_model_line_id,

Line 350: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC,

346: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
347: p_entity_id => p_line_rec.top_model_line_id,
348: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
349: p_requesting_entity_id => p_line_rec.line_id,
350: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC,
351: p_param1 => l_sch_action,
352: p_param2 => p_line_rec.top_model_line_id,
353: p_param3 => p_line_rec.ship_from_org_id,
354: p_param4 => p_line_rec.ship_to_org_id,

Line 391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

387: END IF;
388:
389: -- 4052648 : Parameters p_param14 - 17 are added
390: OE_Delayed_Requests_Pvt.Log_Request
391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
392: p_entity_id => p_line_rec.ato_line_id,
393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
394: p_requesting_entity_id => p_line_rec.line_id,
395: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,

Line 393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

389: -- 4052648 : Parameters p_param14 - 17 are added
390: OE_Delayed_Requests_Pvt.Log_Request
391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
392: p_entity_id => p_line_rec.ato_line_id,
393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
394: p_requesting_entity_id => p_line_rec.line_id,
395: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,
396: p_param1 => l_sch_action,
397: p_param2 => p_line_rec.top_model_line_id,

Line 395: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,

391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
392: p_entity_id => p_line_rec.ato_line_id,
393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
394: p_requesting_entity_id => p_line_rec.line_id,
395: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,
396: p_param1 => l_sch_action,
397: p_param2 => p_line_rec.top_model_line_id,
398: p_param3 => p_line_rec.ship_from_org_id,
399: p_param4 => p_line_rec.ship_to_org_id,

Line 434: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

430: END IF;
431:
432: -- 4052648 : Parameters p_param14 - 17 are added
433: OE_Delayed_Requests_Pvt.Log_Request
434: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
435: p_entity_id => p_line_rec.line_id,
436: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
437: p_requesting_entity_id => p_line_rec.line_id,
438: p_request_type => OE_GLOBALS.G_SCHEDULE_NONSMC,

Line 436: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

432: -- 4052648 : Parameters p_param14 - 17 are added
433: OE_Delayed_Requests_Pvt.Log_Request
434: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
435: p_entity_id => p_line_rec.line_id,
436: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
437: p_requesting_entity_id => p_line_rec.line_id,
438: p_request_type => OE_GLOBALS.G_SCHEDULE_NONSMC,
439: p_param1 => l_sch_action,
440: p_param2 => p_line_rec.top_model_line_id,

Line 438: p_request_type => OE_GLOBALS.G_SCHEDULE_NONSMC,

434: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
435: p_entity_id => p_line_rec.line_id,
436: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
437: p_requesting_entity_id => p_line_rec.line_id,
438: p_request_type => OE_GLOBALS.G_SCHEDULE_NONSMC,
439: p_param1 => l_sch_action,
440: p_param2 => p_line_rec.top_model_line_id,
441: p_param3 => p_line_rec.ship_from_org_id,
442: p_param4 => p_line_rec.ship_to_org_id,

Line 474: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

470: oe_debug_pub.add( 'CALLER IS EXTERNAL' , 1 ) ;
471: END IF;
472:
473: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
474: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
475: ,p_delete => FND_API.G_TRUE
476: ,x_return_status => x_return_status );
477:
478:

Line 557: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,

553: x_unreserve_flag := 'N';
554: l_index := p_line_rec.line_id;
555:
556: -- 1. ordered qty
557: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,
558: p_old_line_rec.ordered_quantity)
559: THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'NEW ORD QTY '|| P_LINE_REC.ORDERED_QUANTITY , 4 ) ;

Line 596: IF NOT OE_GLOBALS.Equal(p_line_rec.ship_from_org_id,

592: END IF;
593:
594:
595: -- 3. ship from org
596: IF NOT OE_GLOBALS.Equal(p_line_rec.ship_from_org_id,
597: p_old_line_rec.ship_from_org_id)
598: THEN
599:
600: IF p_old_line_rec.ship_from_org_id is NOT NULL THEN

Line 778: l_control_rec OE_GLOBALS.control_rec_type;

774: l_msg_count NUMBER;
775: l_msg_data VARCHAR2(2000);
776: l_line_tbl OE_ORDER_PUB.line_tbl_type;
777: l_old_line_tbl OE_Order_PUB.line_tbl_type;
778: l_control_rec OE_GLOBALS.control_rec_type;
779: I NUMBER;
780: l_send_cancel_lines VARCHAR2(1); -- 2882255
781: --
782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 989: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

985: ELSIF p_request_rec.param15 = 'Y' THEN
986:
987: l_request_search_rslt :=
988: OE_Delayed_Requests_PVT.Check_For_Request
989: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
990: p_entity_id => p_request_rec.param2,
991: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC);
992:
993: IF l_request_search_rslt THEN

Line 991: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC);

987: l_request_search_rslt :=
988: OE_Delayed_Requests_PVT.Check_For_Request
989: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
990: p_entity_id => p_request_rec.param2,
991: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC);
992:
993: IF l_request_search_rslt THEN
994: l_request := 'NONE';
995: Return;

Line 1017: --,p_source_type => OE_Globals.G_SOURCE_INTERNAL --3998413

1013: IF l_request = 'ATO' THEN
1014: OE_Config_Util.Query_ATO_Options
1015: ( p_ato_line_id => p_request_rec.entity_id
1016: ,p_send_cancel_lines => l_send_cancel_lines --'Y' 2882255
1017: --,p_source_type => OE_Globals.G_SOURCE_INTERNAL --3998413
1018: ,x_line_tbl => l_line_tbl);
1019: END IF;
1020:
1021: l_old_line_tbl := l_line_tbl;

Line 1412: l_control_rec OE_GLOBALS.control_rec_type;

1408: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1409: IS
1410: l_msg_count NUMBER;
1411: l_msg_data VARCHAR2(2000);
1412: l_control_rec OE_GLOBALS.control_rec_type;
1413: l_sch_action VARCHAR2(30);
1414: --
1415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1416: --

Line 1735: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1731: ELSE
1732: -- this row must have been a part of the Call_ATP call that
1733: -- failed, so set the operator flag.
1734:
1735: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1736:
1737: END IF;
1738:
1739: END LOOP;

Line 2214: AND NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,

2210: WHILE I is NOT NULL
2211: LOOP
2212:
2213: IF nvl(p_x_line_tbl(I).shipping_interfaced_flag,'N') = 'N'
2214: AND NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2215: p_old_line_tbl(I).inventory_item_id)
2216: AND p_old_line_tbl(I).reserved_quantity > 0 THEN
2217:
2218: OE_SCHEDULE_UTIL.Unreserve_Line

Line 2358: p_x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

2354: IF l_debug_level > 0 THEN
2355: oe_debug_pub.add( '-------ACTION ' || P_REQUEST_REC.PARAM1 , 4 ) ;
2356: END IF;
2357:
2358: p_x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2359: p_x_line_rec.change_reason := 'SYSTEM';
2360: p_x_line_rec.change_comments := 'Scheduling Action';
2361: p_x_line_rec.schedule_action_code := p_request_rec.param1;
2362: p_x_line_rec.ship_from_org_id := p_request_rec.param3;

Line 2389: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC

2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC
2390: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO
2391: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
2392: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 )
2393:

Line 2390: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO

2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC
2390: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO
2391: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
2392: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 )
2393:
2394: THEN

Line 2427: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)) THEN

2423: oe_debug_pub.add( 'ASSIGN OVERRIDE FLAG' , 3 ) ;
2424: END IF;
2425: IF (p_x_line_rec.ato_line_id is not null AND
2426: NOT (p_x_line_rec.ato_line_id = p_x_line_rec.line_id AND
2427: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)) THEN
2428:
2429: IF p_x_line_rec.ship_model_complete_flag = 'Y'
2430: AND nvl(p_x_line_rec.override_atp_date_code,'N') = 'N' THEN
2431:

Line 2458: ELSIF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN

2454: p_x_line_rec.override_atp_date_code := p_request_rec.param11;
2455:
2456: END IF;
2457:
2458: ELSIF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
2459:
2460:
2461: -- 2722692
2462: -- IF p_x_line_rec.ship_model_complete_flag = 'Y'

Line 2537: l_control_rec OE_GLOBALS.control_rec_type;

2533: l_call_po VARCHAR2(1) := 'N';
2534: l_direct_update VARCHAR2(1) := 'N';
2535: l_process_requests BOOLEAN;
2536: l_redo_security_check VARCHAR2(1) := 'N';
2537: l_control_rec OE_GLOBALS.control_rec_type;
2538: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917
2539:
2540: l_po_NeedByDate_Update VARCHAR2(10); -- Added for IR ISO CMS project
2541: l_return_status VARCHAR2(1); -- Added for IR ISO CMS project

Line 2562: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN

2558: I := p_x_line_tbl.FIRST;
2559: WHILE I is NOT NULL
2560: LOOP
2561:
2562: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN
2563: IF l_debug_level > 0 THEN
2564: oe_debug_pub.add( 'OPERATION IS NONE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2565: END IF;
2566: goto end_of_loop;

Line 2574: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'F' THEN

2570: p_old_line_tbl(I).ship_set := null; -- 3878491
2571:
2572: --Added the below IF condition for bug 4587506
2573: --Added IS_MASS_CHANGE condition for bug 4911340
2574: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'F' THEN
2575: p_x_line_tbl(I).change_reason := 'SYSTEM';
2576: END IF;
2577:
2578:

Line 2618: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

2614:
2615: IF l_debug_level > 0 THEN
2616: oe_debug_pub.add( 'LINE IS CLOSED '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2617: END IF;
2618: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2621: END IF;
2622: IF l_debug_level > 0 THEN

Line 2680: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,

2676: END IF;
2677:
2678:
2679: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2680: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2681: p_old_line_tbl(I).request_date) OR
2682:
2683: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2684: p_old_line_tbl(I).schedule_ship_date) OR

Line 2683: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,

2679: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2680: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2681: p_old_line_tbl(I).request_date) OR
2682:
2683: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2684: p_old_line_tbl(I).schedule_ship_date) OR
2685:
2686: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2687: p_old_line_tbl(I).schedule_arrival_date) OR

Line 2686: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,

2682:
2683: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2684: p_old_line_tbl(I).schedule_ship_date) OR
2685:
2686: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2687: p_old_line_tbl(I).schedule_arrival_date) OR
2688:
2689: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2690: p_old_line_tbl(I).ship_from_org_id) OR

Line 2689: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,

2685:
2686: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2687: p_old_line_tbl(I).schedule_arrival_date) OR
2688:
2689: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2690: p_old_line_tbl(I).ship_from_org_id) OR
2691:
2692: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2693: p_old_line_tbl(I).ship_to_org_id) OR

Line 2692: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,

2688:
2689: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2690: p_old_line_tbl(I).ship_from_org_id) OR
2691:
2692: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2693: p_old_line_tbl(I).ship_to_org_id) OR
2694:
2695: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2696: p_old_line_tbl(I).shipping_method_code) OR

Line 2695: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,

2691:
2692: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2693: p_old_line_tbl(I).ship_to_org_id) OR
2694:
2695: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2696: p_old_line_tbl(I).shipping_method_code) OR
2697:
2698: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2699: p_old_line_tbl(I).demand_class_code) OR

Line 2698: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,

2694:
2695: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2696: p_old_line_tbl(I).shipping_method_code) OR
2697:
2698: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2699: p_old_line_tbl(I).demand_class_code) OR
2700:
2701: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2702: p_old_line_tbl(I).planning_priority) OR

Line 2701: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,

2697:
2698: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2699: p_old_line_tbl(I).demand_class_code) OR
2700:
2701: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2702: p_old_line_tbl(I).planning_priority) OR
2703:
2704: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2705: p_old_line_tbl(I).delivery_lead_time) OR

Line 2704: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,

2700:
2701: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2702: p_old_line_tbl(I).planning_priority) OR
2703:
2704: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2705: p_old_line_tbl(I).delivery_lead_time) OR
2706:
2707: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2708: p_old_line_tbl(I).inventory_item_id)

Line 2707: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,

2703:
2704: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2705: p_old_line_tbl(I).delivery_lead_time) OR
2706:
2707: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2708: p_old_line_tbl(I).inventory_item_id)
2709: THEN
2710: IF l_debug_level > 0 THEN
2711: oe_debug_pub.add( 'THERE IS A CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

Line 2717: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

2713: ELSE
2714: IF l_debug_level > 0 THEN
2715: oe_debug_pub.add( 'NO CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2716: END IF;
2717: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2718: goto direct_update;
2719: END IF;
2720: END IF; -- end if reschedule
2721:

Line 2741: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

2737: l_redo_security_check := 'Y';
2738: END IF;
2739:
2740: IF l_direct_update = 'Y' THEN
2741: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2742: END IF;
2743:
2744: <>
2745: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN

Line 2745: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN

2741: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2742: END IF;
2743:
2744: <>
2745: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN
2746: Handle_Direct_Update
2747: ( p_x_line_rec => p_x_line_tbl(I)
2748: ,p_old_line_rec => p_old_line_tbl(I)
2749: ,p_caller => p_caller);

Line 2781: NOT OE_GLOBALS.EQUAL(p_x_line_tbl(I).schedule_arrival_date,

2777:
2778: /* Loop Back*/
2779: IF nvl(p_x_line_tbl(I).open_flag,'Y') = 'Y' AND
2780: p_x_line_tbl(I).source_document_type_id = 10 AND
2781: NOT OE_GLOBALS.EQUAL(p_x_line_tbl(I).schedule_arrival_date,
2782: p_old_line_tbl(I).schedule_arrival_date)
2783:
2784: THEN
2785: IF l_debug_level > 0 THEN

Line 2796: -- a new delayed request of type OE_Globals.G_UPDATE_REQUISITION, which

2792: -- MTL_Supply record for the corresponding internal requisition line
2793: -- We now be calling PO_RCO_Validation_GRP.Update_ReqChange_from_SO
2794: -- Purchasing product new API to update both the internal requisition
2795: -- line and the MTL_Supply. This will be achieved via the logging of
2796: -- a new delayed request of type OE_Globals.G_UPDATE_REQUISITION, which
2797: -- is added as part of this project
2798: --
2799: /*
2800: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,

Line 2835: -- In this project it can be OE_Globals.G_Entity_Line

2831: -- Please refer to following delayed request params with their meaning
2832: -- useful while logging the delayed request -
2833: --
2834: -- P_entity_code Entity for which delayed request has to be logged.
2835: -- In this project it can be OE_Globals.G_Entity_Line
2836: -- or OE_Globals.G_Entity_Header
2837: -- P_entity_id Primary key of the entity record. In this project,
2838: -- it can be Order Line_id or Header_id
2839: -- P_requesting_entity_code Which entity has requested this delayed request to

Line 2836: -- or OE_Globals.G_Entity_Header

2832: -- useful while logging the delayed request -
2833: --
2834: -- P_entity_code Entity for which delayed request has to be logged.
2835: -- In this project it can be OE_Globals.G_Entity_Line
2836: -- or OE_Globals.G_Entity_Header
2837: -- P_entity_id Primary key of the entity record. In this project,
2838: -- it can be Order Line_id or Header_id
2839: -- P_requesting_entity_code Which entity has requested this delayed request to
2840: -- be logged! In this project it will be OE_Globals.

Line 2840: -- be logged! In this project it will be OE_Globals.

2836: -- or OE_Globals.G_Entity_Header
2837: -- P_entity_id Primary key of the entity record. In this project,
2838: -- it can be Order Line_id or Header_id
2839: -- P_requesting_entity_code Which entity has requested this delayed request to
2840: -- be logged! In this project it will be OE_Globals.
2841: -- G_Entity_Line or OE_Globals.G_Entity_Header
2842: -- P_requesting_entity_id Primary key of the requesting entity. In this
2843: -- project, it is Line_id or Header_id
2844: -- P_request_type Indicates which business logic (or which procedure)

Line 2841: -- G_Entity_Line or OE_Globals.G_Entity_Header

2837: -- P_entity_id Primary key of the entity record. In this project,
2838: -- it can be Order Line_id or Header_id
2839: -- P_requesting_entity_code Which entity has requested this delayed request to
2840: -- be logged! In this project it will be OE_Globals.
2841: -- G_Entity_Line or OE_Globals.G_Entity_Header
2842: -- P_requesting_entity_id Primary key of the requesting entity. In this
2843: -- project, it is Line_id or Header_id
2844: -- P_request_type Indicates which business logic (or which procedure)
2845: -- should be executed. In this project, it is OE_Global

Line 2901: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE

2897: -- Purchasing profile option does not allow update of Need By Date when
2898: -- Schedule Ship Date changes on internal sales order line
2899:
2900: OE_delayed_requests_Pvt.log_request
2901: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2902: , p_entity_id => p_x_line_tbl(I).line_id
2903: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
2904: , p_requesting_entity_id => p_x_line_tbl(I).line_id
2905: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id

Line 2903: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

2899:
2900: OE_delayed_requests_Pvt.log_request
2901: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2902: , p_entity_id => p_x_line_tbl(I).line_id
2903: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
2904: , p_requesting_entity_id => p_x_line_tbl(I).line_id
2905: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id
2906: , p_request_unique_key2 => p_x_line_tbl(I).source_document_id -- Req Hdr_id
2907: , p_request_unique_key3 => p_x_line_tbl(I).source_document_line_id -- Req Line_id

Line 2909: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION

2905: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id
2906: , p_request_unique_key2 => p_x_line_tbl(I).source_document_id -- Req Hdr_id
2907: , p_request_unique_key3 => p_x_line_tbl(I).source_document_line_id -- Req Line_id
2908: , p_date_param1 => p_x_line_tbl(I).schedule_arrival_date
2909: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
2910: , x_return_status => l_return_status
2911: );
2912:
2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3035: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

3031: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3032: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3033: IS
3034: l_sec_result NUMBER;
3035: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
3036: l_return_status VARCHAR2(1);
3037: --
3038: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3039: --

Line 3075: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,

3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:
3074:
3075: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3076: p_old_line_rec.ship_from_org_id) OR
3077: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3078: p_old_line_rec.ship_to_org_id) OR
3079: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,

Line 3077: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,

3073:
3074:
3075: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3076: p_old_line_rec.ship_from_org_id) OR
3077: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3078: p_old_line_rec.ship_to_org_id) OR
3079: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
3080: p_old_line_rec.inventory_item_id)
3081:

Line 3079: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,

3075: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3076: p_old_line_rec.ship_from_org_id) OR
3077: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3078: p_old_line_rec.ship_to_org_id) OR
3079: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
3080: p_old_line_rec.inventory_item_id)
3081:
3082: THEN
3083: IF l_debug_level > 0 THEN

Line 3087: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';

3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add( 'SHIP FROM/TO/ITEM CHANGED ON LINE CALL PO' , 1 ) ;
3085: END IF;
3086: ELSE
3087: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
3088:
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'OLD SHIP :' || P_OLD_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3091: END IF;

Line 3096: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_ship_date,

3092: IF l_debug_level > 0 THEN
3093: oe_debug_pub.add( 'NEW SHIP :' || P_X_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3094: END IF;
3095:
3096: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_ship_date,
3097: p_old_line_rec.schedule_ship_date)
3098: THEN
3099:
3100: IF l_debug_level > 0 THEN

Line 3112: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;

3108: p_x_line_rec => p_x_line_rec,
3109: p_old_line_rec => p_old_line_rec);
3110:
3111: IF l_debug_level > 0 THEN
3112: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;
3113: END IF;
3114:
3115: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN
3116: x_direct_update := 'Y';

Line 3115: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN

3111: IF l_debug_level > 0 THEN
3112: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;
3113: END IF;
3114:
3115: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN
3116: x_direct_update := 'Y';
3117: END IF;
3118:
3119: END IF;

Line 3202: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code

3198:
3199: -- Start 2806483
3200: IF (p_x_line_rec.shipping_method_code IS NOT NULL
3201: AND p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
3202: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code
3203: ,p_old_line_rec.shipping_method_code)
3204: THEN
3205:
3206: p_x_line_rec.freight_carrier_code :=

Line 3332: IF OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,

3328: Print_Time('entering Update_Reservation');
3329:
3330: x_return_status := FND_API.G_RET_STS_SUCCESS;
3331:
3332: IF OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
3333: p_old_line_rec.schedule_ship_date) OR
3334: p_line_rec.schedule_ship_date IS NULL OR -- bug 3542464
3335: p_line_rec.reserved_quantity <= 0 OR
3336: p_line_rec.ordered_quantity = 0

Line 3584: p_source_type => OE_Globals.G_SOURCE_INTERNAL,

3580:
3581: OE_Config_Util.Query_Options
3582: (p_top_model_line_id => p_model_line_id,
3583: p_send_cancel_lines => p_send_cancel_lines,
3584: p_source_type => OE_Globals.G_SOURCE_INTERNAL,
3585: x_line_tbl => x_line_tbl);
3586:
3587: ELSIF p_link_to_line_id <> FND_API.G_MISS_NUM THEN
3588: IF l_debug_level > 0 THEN

Line 3595: p_source_type => OE_Globals.G_SOURCE_INTERNAL,

3591:
3592: OE_Config_Util.Query_Included_Items
3593: (p_line_id => p_link_to_line_id,
3594: p_send_cancel_lines => p_send_cancel_lines,
3595: p_source_type => OE_Globals.G_SOURCE_INTERNAL,
3596: x_line_tbl => x_line_tbl);
3597:
3598: END IF;
3599: