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 6: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; --7827737;

2: /* $Header: OEXVCSCB.pls 120.21.12020000.4 2013/05/09 18:35:10 gabhatia ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30):='Oe_Config_Schedule_Pvt';
6: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; --7827737;
7:
8: /*--------------------------------------------------------------
9: Forward Declarations
10: ---------------------------------------------------------------*/

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 393: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 395: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 397: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,

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

Line 436: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 438: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 440: p_request_type => OE_GLOBALS.G_SCHEDULE_NONSMC,

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

Line 476: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

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

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

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

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

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

Line 780: l_control_rec OE_GLOBALS.control_rec_type;

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

Line 991: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 993: p_request_type => OE_GLOBALS.G_SCHEDULE_SMC);

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

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

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

Line 1414: l_control_rec OE_GLOBALS.control_rec_type;

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

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

1737: ELSE
1738: -- this row must have been a part of the Call_ATP call that
1739: -- failed, so set the operator flag.
1740:
1741: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1742:
1743: END IF;
1744:
1745: END LOOP;

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

2247: WHILE I is NOT NULL
2248: LOOP
2249:
2250: IF nvl(p_x_line_tbl(I).shipping_interfaced_flag,'N') = 'N'
2251: AND NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2252: p_old_line_tbl(I).inventory_item_id)
2253: AND p_old_line_tbl(I).reserved_quantity > 0 THEN
2254:
2255: OE_SCHEDULE_UTIL.Unreserve_Line

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

2405: IF l_debug_level > 0 THEN
2406: oe_debug_pub.add( '-------ACTION ' || P_REQUEST_REC.PARAM1 , 4 ) ;
2407: END IF;
2408:
2409: p_x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2410: p_x_line_rec.change_reason := 'SYSTEM';
2411: p_x_line_rec.change_comments := 'Scheduling Action';
2412: p_x_line_rec.schedule_action_code := p_request_rec.param1;
2413: -- 13250883 : Cascade warehouse only if the model is of type SMC

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

2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:
2447: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC
2448: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO
2449: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
2450: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 )
2451:

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

2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:
2447: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC
2448: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO
2449: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
2450: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 )
2451:
2452: THEN

Line 2486: IN (OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)))

2482: END IF;
2483: IF (p_x_line_rec.ato_line_id is not null AND
2484: NOT (p_x_line_rec.ato_line_id = p_x_line_rec.line_id AND
2485: p_x_line_rec.item_type_code
2486: IN (OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)))
2487: THEN --9775352
2488:
2489: IF p_x_line_rec.ship_model_complete_flag = 'Y'
2490: AND nvl(p_x_line_rec.override_atp_date_code,'N') = 'N' THEN

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

2514: p_x_line_rec.override_atp_date_code := p_request_rec.param11;
2515:
2516: END IF;
2517:
2518: ELSIF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
2519:
2520:
2521: -- 2722692
2522: -- IF p_x_line_rec.ship_model_complete_flag = 'Y'

Line 2597: l_control_rec OE_GLOBALS.control_rec_type;

2593: l_call_po VARCHAR2(1) := 'N';
2594: l_direct_update VARCHAR2(1) := 'N';
2595: l_process_requests BOOLEAN;
2596: l_redo_security_check VARCHAR2(1) := 'N';
2597: l_control_rec OE_GLOBALS.control_rec_type;
2598: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917
2599:
2600: l_po_NeedByDate_Update VARCHAR2(10); -- Added for IR ISO CMS project
2601: l_return_status VARCHAR2(1); -- Added for IR ISO CMS project

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

2618: I := p_x_line_tbl.FIRST;
2619: WHILE I is NOT NULL
2620: LOOP
2621:
2622: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN
2623: IF l_debug_level > 0 THEN
2624: oe_debug_pub.add( 'OPERATION IS NONE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2625: END IF;
2626: goto end_of_loop;

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

2630: p_old_line_tbl(I).ship_set := null; -- 3878491
2631:
2632: --Added the below IF condition for bug 4587506
2633: --Added IS_MASS_CHANGE condition for bug 4911340
2634: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'F' THEN
2635: p_x_line_tbl(I).change_reason := 'SYSTEM';
2636: END IF;
2637:
2638:

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

2674:
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'LINE IS CLOSED '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2677: END IF;
2678: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2679: IF l_debug_level > 0 THEN
2680: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2681: END IF;
2682: IF l_debug_level > 0 THEN

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

2736: END IF;
2737:
2738:
2739: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2740: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2741: p_old_line_tbl(I).request_date) OR
2742:
2743: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2744: p_old_line_tbl(I).schedule_ship_date) OR

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

2739: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2740: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2741: p_old_line_tbl(I).request_date) OR
2742:
2743: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2744: p_old_line_tbl(I).schedule_ship_date) OR
2745:
2746: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2747: p_old_line_tbl(I).schedule_arrival_date) OR

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

2742:
2743: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,
2744: p_old_line_tbl(I).schedule_ship_date) OR
2745:
2746: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2747: p_old_line_tbl(I).schedule_arrival_date) OR
2748:
2749: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2750: p_old_line_tbl(I).ship_from_org_id) OR

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

2745:
2746: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_arrival_date,
2747: p_old_line_tbl(I).schedule_arrival_date) OR
2748:
2749: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2750: p_old_line_tbl(I).ship_from_org_id) OR
2751:
2752: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2753: p_old_line_tbl(I).ship_to_org_id) OR

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

2748:
2749: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_from_org_id,
2750: p_old_line_tbl(I).ship_from_org_id) OR
2751:
2752: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2753: p_old_line_tbl(I).ship_to_org_id) OR
2754:
2755: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2756: p_old_line_tbl(I).shipping_method_code) OR

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

2751:
2752: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).ship_to_org_id,
2753: p_old_line_tbl(I).ship_to_org_id) OR
2754:
2755: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2756: p_old_line_tbl(I).shipping_method_code) OR
2757:
2758: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2759: p_old_line_tbl(I).demand_class_code) OR

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

2754:
2755: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).shipping_method_code,
2756: p_old_line_tbl(I).shipping_method_code) OR
2757:
2758: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2759: p_old_line_tbl(I).demand_class_code) OR
2760:
2761: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2762: p_old_line_tbl(I).planning_priority) OR

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

2757:
2758: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).demand_class_code,
2759: p_old_line_tbl(I).demand_class_code) OR
2760:
2761: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2762: p_old_line_tbl(I).planning_priority) OR
2763:
2764: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2765: p_old_line_tbl(I).delivery_lead_time) OR

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

2760:
2761: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).planning_priority,
2762: p_old_line_tbl(I).planning_priority) OR
2763:
2764: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2765: p_old_line_tbl(I).delivery_lead_time) OR
2766:
2767: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2768: p_old_line_tbl(I).inventory_item_id)

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

2763:
2764: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).delivery_lead_time,
2765: p_old_line_tbl(I).delivery_lead_time) OR
2766:
2767: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2768: p_old_line_tbl(I).inventory_item_id)
2769: THEN
2770: IF l_debug_level > 0 THEN
2771: oe_debug_pub.add( 'THERE IS A CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

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

2773: ELSE
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add( 'NO CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2776: END IF;
2777: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2778: goto direct_update;
2779: END IF;
2780: END IF; -- end if reschedule
2781:

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

2797: l_redo_security_check := 'Y';
2798: END IF;
2799:
2800: IF l_direct_update = 'Y' THEN
2801: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2802: END IF;
2803:
2804: <>
2805: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN

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

2801: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2802: END IF;
2803:
2804: <>
2805: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN
2806: Handle_Direct_Update
2807: ( p_x_line_rec => p_x_line_tbl(I)
2808: ,p_old_line_rec => p_old_line_tbl(I)
2809: ,p_caller => p_caller);

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

2864:
2865: /* Loop Back*/
2866: IF nvl(p_x_line_tbl(I).open_flag,'Y') = 'Y' AND
2867: p_x_line_tbl(I).source_document_type_id = 10 AND
2868: NOT OE_GLOBALS.EQUAL(p_x_line_tbl(I).schedule_arrival_date,
2869: p_old_line_tbl(I).schedule_arrival_date)
2870:
2871: THEN
2872: IF l_debug_level > 0 THEN

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

2879: -- MTL_Supply record for the corresponding internal requisition line
2880: -- We now be calling PO_RCO_Validation_GRP.Update_ReqChange_from_SO
2881: -- Purchasing product new API to update both the internal requisition
2882: -- line and the MTL_Supply. This will be achieved via the logging of
2883: -- a new delayed request of type OE_Globals.G_UPDATE_REQUISITION, which
2884: -- is added as part of this project
2885: --
2886: /*
2887: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,

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

2918: -- Please refer to following delayed request params with their meaning
2919: -- useful while logging the delayed request -
2920: --
2921: -- P_entity_code Entity for which delayed request has to be logged.
2922: -- In this project it can be OE_Globals.G_Entity_Line
2923: -- or OE_Globals.G_Entity_Header
2924: -- P_entity_id Primary key of the entity record. In this project,
2925: -- it can be Order Line_id or Header_id
2926: -- P_requesting_entity_code Which entity has requested this delayed request to

Line 2923: -- or OE_Globals.G_Entity_Header

2919: -- useful while logging the delayed request -
2920: --
2921: -- P_entity_code Entity for which delayed request has to be logged.
2922: -- In this project it can be OE_Globals.G_Entity_Line
2923: -- or OE_Globals.G_Entity_Header
2924: -- P_entity_id Primary key of the entity record. In this project,
2925: -- it can be Order Line_id or Header_id
2926: -- P_requesting_entity_code Which entity has requested this delayed request to
2927: -- be logged! In this project it will be OE_Globals.

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

2923: -- or OE_Globals.G_Entity_Header
2924: -- P_entity_id Primary key of the entity record. In this project,
2925: -- it can be Order Line_id or Header_id
2926: -- P_requesting_entity_code Which entity has requested this delayed request to
2927: -- be logged! In this project it will be OE_Globals.
2928: -- G_Entity_Line or OE_Globals.G_Entity_Header
2929: -- P_requesting_entity_id Primary key of the requesting entity. In this
2930: -- project, it is Line_id or Header_id
2931: -- P_request_type Indicates which business logic (or which procedure)

Line 2928: -- G_Entity_Line or OE_Globals.G_Entity_Header

2924: -- P_entity_id Primary key of the entity record. In this project,
2925: -- it can be Order Line_id or Header_id
2926: -- P_requesting_entity_code Which entity has requested this delayed request to
2927: -- be logged! In this project it will be OE_Globals.
2928: -- G_Entity_Line or OE_Globals.G_Entity_Header
2929: -- P_requesting_entity_id Primary key of the requesting entity. In this
2930: -- project, it is Line_id or Header_id
2931: -- P_request_type Indicates which business logic (or which procedure)
2932: -- should be executed. In this project, it is OE_Global

Line 2988: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE

2984: -- Purchasing profile option does not allow update of Need By Date when
2985: -- Schedule Ship Date changes on internal sales order line
2986:
2987: OE_delayed_requests_Pvt.log_request
2988: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2989: , p_entity_id => p_x_line_tbl(I).line_id
2990: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
2991: , p_requesting_entity_id => p_x_line_tbl(I).line_id
2992: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id

Line 2990: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

2986:
2987: OE_delayed_requests_Pvt.log_request
2988: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2989: , p_entity_id => p_x_line_tbl(I).line_id
2990: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
2991: , p_requesting_entity_id => p_x_line_tbl(I).line_id
2992: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id
2993: , p_request_unique_key2 => p_x_line_tbl(I).source_document_id -- Req Hdr_id
2994: , p_request_unique_key3 => p_x_line_tbl(I).source_document_line_id -- Req Line_id

Line 2996: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION

2992: , p_request_unique_key1 => p_x_line_tbl(I).header_id -- Order Hdr_id
2993: , p_request_unique_key2 => p_x_line_tbl(I).source_document_id -- Req Hdr_id
2994: , p_request_unique_key3 => p_x_line_tbl(I).source_document_line_id -- Req Line_id
2995: , p_date_param1 => p_x_line_tbl(I).schedule_arrival_date
2996: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
2997: , x_return_status => l_return_status
2998: );
2999:
3000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3122: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

3118: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3119: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3120: IS
3121: l_sec_result NUMBER;
3122: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
3123: l_return_status VARCHAR2(1);
3124: --
3125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3126: --

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

3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:
3161:
3162: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3163: p_old_line_rec.ship_from_org_id) OR
3164: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3165: p_old_line_rec.ship_to_org_id) OR
3166: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,

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

3160:
3161:
3162: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3163: p_old_line_rec.ship_from_org_id) OR
3164: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3165: p_old_line_rec.ship_to_org_id) OR
3166: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
3167: p_old_line_rec.inventory_item_id)
3168:

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

3162: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,
3163: p_old_line_rec.ship_from_org_id) OR
3164: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_to_org_id,
3165: p_old_line_rec.ship_to_org_id) OR
3166: NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
3167: p_old_line_rec.inventory_item_id)
3168:
3169: THEN
3170: IF l_debug_level > 0 THEN

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

3170: IF l_debug_level > 0 THEN
3171: oe_debug_pub.add( 'SHIP FROM/TO/ITEM CHANGED ON LINE CALL PO' , 1 ) ;
3172: END IF;
3173: ELSE
3174: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
3175:
3176: IF l_debug_level > 0 THEN
3177: oe_debug_pub.add( 'OLD SHIP :' || P_OLD_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3178: END IF;

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

3179: IF l_debug_level > 0 THEN
3180: oe_debug_pub.add( 'NEW SHIP :' || P_X_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3181: END IF;
3182: --8706868
3183: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_ship_date,
3184: p_old_line_rec.schedule_ship_date)
3185: OR NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_arrival_date,
3186: p_old_line_rec.schedule_arrival_date)
3187:

Line 3185: OR NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_arrival_date,

3181: END IF;
3182: --8706868
3183: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_ship_date,
3184: p_old_line_rec.schedule_ship_date)
3185: OR NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_arrival_date,
3186: p_old_line_rec.schedule_arrival_date)
3187:
3188: THEN
3189:

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

3198: p_x_line_rec => p_x_line_rec,
3199: p_old_line_rec => p_old_line_rec);
3200:
3201: IF l_debug_level > 0 THEN
3202: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;
3203: END IF;
3204:
3205: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN
3206: x_direct_update := 'Y';

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

3201: IF l_debug_level > 0 THEN
3202: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;
3203: END IF;
3204:
3205: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN
3206: x_direct_update := 'Y';
3207: END IF;
3208:
3209: END IF;

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

3288:
3289: -- Start 2806483
3290: IF (p_x_line_rec.shipping_method_code IS NOT NULL
3291: AND p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
3292: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code
3293: ,p_old_line_rec.shipping_method_code)
3294: THEN
3295:
3296: p_x_line_rec.freight_carrier_code :=

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

3418: Print_Time('entering Update_Reservation');
3419:
3420: x_return_status := FND_API.G_RET_STS_SUCCESS;
3421:
3422: IF OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
3423: p_old_line_rec.schedule_ship_date) OR
3424: p_line_rec.schedule_ship_date IS NULL OR -- bug 3542464
3425: p_line_rec.reserved_quantity <= 0 OR
3426: p_line_rec.ordered_quantity = 0

Line 3678: p_source_type => OE_Globals.G_SOURCE_INTERNAL,

3674:
3675: OE_Config_Util.Query_Options
3676: (p_top_model_line_id => p_model_line_id,
3677: p_send_cancel_lines => p_send_cancel_lines,
3678: p_source_type => OE_Globals.G_SOURCE_INTERNAL,
3679: x_line_tbl => x_line_tbl);
3680:
3681: ELSIF p_link_to_line_id <> FND_API.G_MISS_NUM THEN
3682: IF l_debug_level > 0 THEN

Line 3689: p_source_type => OE_Globals.G_SOURCE_INTERNAL,

3685:
3686: OE_Config_Util.Query_Included_Items
3687: (p_line_id => p_link_to_line_id,
3688: p_send_cancel_lines => p_send_cancel_lines,
3689: p_source_type => OE_Globals.G_SOURCE_INTERNAL,
3690: x_line_tbl => x_line_tbl);
3691:
3692: END IF;
3693: