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_OEOL_SCH dependencies on OE_BULK_WF_UTIL

Line 291: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN

287: SAVEPOINT Before_Lock;
288:
289: -- If it is BULK Mode then no need to query these values from Database
290:
291: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'SCH BULK MODE' , 5 ) ;
294: END IF;
295:

Line 296: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'SCH BULK MODE' , 5 ) ;
294: END IF;
295:
296: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
297:
298: l_top_model_line_id :=
299: OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
300:

Line 299: OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

295:
296: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
297:
298: l_top_model_line_id :=
299: OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
300:
301: l_item_type_code :=
302: OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
303:

Line 302: OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);

298: l_top_model_line_id :=
299: OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
300:
301: l_item_type_code :=
302: OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
303:
304: l_line_category_code :=
305: OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
306:

Line 305: OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code(OE_BULK_WF_UTIL.G_LINE_INDEX);

301: l_item_type_code :=
302: OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
303:
304: l_line_category_code :=
305: OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
306:
307: l_schedule_status_code :=
308: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
309:

Line 308: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code(OE_BULK_WF_UTIL.G_LINE_INDEX);

304: l_line_category_code :=
305: OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
306:
307: l_schedule_status_code :=
308: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
309:
310: l_ship_model_complete_flag :=
311: OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag(OE_BULK_WF_UTIL.G_LINE_INDEX);
312:

Line 311: OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag(OE_BULK_WF_UTIL.G_LINE_INDEX);

307: l_schedule_status_code :=
308: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
309:
310: l_ship_model_complete_flag :=
311: OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag(OE_BULK_WF_UTIL.G_LINE_INDEX);
312:
313: l_ato_line_id :=
314: OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
315:

Line 314: OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

310: l_ship_model_complete_flag :=
311: OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag(OE_BULK_WF_UTIL.G_LINE_INDEX);
312:
313: l_ato_line_id :=
314: OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
315:
316: l_source_type_code :=
317: OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
318:

Line 317: OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);

313: l_ato_line_id :=
314: OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
315:
316: l_source_type_code :=
317: OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
318:
319: l_request_date :=
320: OE_BULK_ORDER_PVT.G_LINE_REC.request_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
321:

Line 320: OE_BULK_ORDER_PVT.G_LINE_REC.request_date(OE_BULK_WF_UTIL.G_LINE_INDEX);

316: l_source_type_code :=
317: OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code(OE_BULK_WF_UTIL.G_LINE_INDEX);
318:
319: l_request_date :=
320: OE_BULK_ORDER_PVT.G_LINE_REC.request_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
321:
322: l_sch_ship_date :=
323: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
324:

Line 323: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date(OE_BULK_WF_UTIL.G_LINE_INDEX);

319: l_request_date :=
320: OE_BULK_ORDER_PVT.G_LINE_REC.request_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
321:
322: l_sch_ship_date :=
323: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
324:
325: l_ship_from_org_id :=
326: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
327:

Line 326: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

322: l_sch_ship_date :=
323: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date(OE_BULK_WF_UTIL.G_LINE_INDEX);
324:
325: l_ship_from_org_id :=
326: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
327:
328: -- Locking of top model not needed for BULK create as model(kit) and child
329: -- (included items) are created in the same DB session
330: -- Handle external lines call not needed as BULK does not support external

Line 335: IF OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl.EXISTS(OE_BULK_WF_UTIL.G_LINE_INDEX)

331: -- lines
332: -- If the mode is BULK from Order Import Then check globals to find out
333: -- if line on activity specific hold
334:
335: IF OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl.EXISTS(OE_BULK_WF_UTIL.G_LINE_INDEX)
336: AND OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl(OE_BULK_WF_UTIL.G_LINE_INDEX).On_Scheduling_Hold = 'Y'
337: THEN
338: l_result := FND_API.G_TRUE;
339: END IF;

Line 336: AND OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl(OE_BULK_WF_UTIL.G_LINE_INDEX).On_Scheduling_Hold = 'Y'

332: -- If the mode is BULK from Order Import Then check globals to find out
333: -- if line on activity specific hold
334:
335: IF OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl.EXISTS(OE_BULK_WF_UTIL.G_LINE_INDEX)
336: AND OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl(OE_BULK_WF_UTIL.G_LINE_INDEX).On_Scheduling_Hold = 'Y'
337: THEN
338: l_result := FND_API.G_TRUE;
339: END IF;
340:

Line 1027: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN

1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.add('-- bulk mode set results on global record', 5);
1025: END IF;
1026:
1027: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
1028: -- shippable flag need to be checked based on ship from org.
1029:
1030: IF p_line_rec.inventory_item_id is NULL THEN
1031: p_line_rec.inventory_item_id := OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 1031: p_line_rec.inventory_item_id := OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

1027: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
1028: -- shippable flag need to be checked based on ship from org.
1029:
1030: IF p_line_rec.inventory_item_id is NULL THEN
1031: p_line_rec.inventory_item_id := OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
1032: END IF;
1033:
1034: l_key := OE_BULK_CACHE.Load_Item
1035: ( p_key1 => p_line_rec.inventory_item_id

Line 1043: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

1039: -- compare and assign.
1040: -- this load item will serve at the time if wf shipping call.
1041:
1042: OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
1043: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
1044: OE_BULK_CACHE.G_ITEM_TBL(l_key).shippable_item_flag;
1045:
1046: IF OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1047: (OE_BULK_WF_UTIL.G_LINE_INDEX) is NULL AND

Line 1047: (OE_BULK_WF_UTIL.G_LINE_INDEX) is NULL AND

1043: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
1044: OE_BULK_CACHE.G_ITEM_TBL(l_key).shippable_item_flag;
1045:
1046: IF OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1047: (OE_BULK_WF_UTIL.G_LINE_INDEX) is NULL AND
1048: p_line_rec.schedule_status_code is not NULL
1049: THEN
1050: oe_debug_pub.add('2 sch bulk mode, set results wf sch',5);
1051: -- need not put original item

Line 1054: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;

1050: oe_debug_pub.add('2 sch bulk mode, set results wf sch',5);
1051: -- need not put original item
1052:
1053: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1054: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;
1055: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date
1056: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_ship_date;
1057: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_arrival_date
1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;

Line 1056: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_ship_date;

1052:
1053: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1054: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;
1055: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date
1056: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_ship_date;
1057: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_arrival_date
1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;
1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;

Line 1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;

1054: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;
1055: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date
1056: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_ship_date;
1057: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_arrival_date
1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;
1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;
1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code
1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;

Line 1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;

1056: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_ship_date;
1057: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_arrival_date
1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;
1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;
1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code
1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;
1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time
1064: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.delivery_lead_time;

Line 1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;

1058: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_arrival_date;
1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;
1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code
1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;
1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time
1064: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.delivery_lead_time;
1065: OE_BULK_ORDER_PVT.G_LINE_REC.visible_demand_flag
1066: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.visible_demand_flag;

Line 1064: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.delivery_lead_time;

1060: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.ship_from_org_id;
1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code
1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;
1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time
1064: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.delivery_lead_time;
1065: OE_BULK_ORDER_PVT.G_LINE_REC.visible_demand_flag
1066: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.visible_demand_flag;
1067:
1068: --OE_BULK_ORDER_PVT.G_LINE_REC.PLANNING_PRIORITY.extend(l_count);

Line 1066: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.visible_demand_flag;

1062: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.shipping_method_code;
1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time
1064: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.delivery_lead_time;
1065: OE_BULK_ORDER_PVT.G_LINE_REC.visible_demand_flag
1066: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.visible_demand_flag;
1067:
1068: --OE_BULK_ORDER_PVT.G_LINE_REC.PLANNING_PRIORITY.extend(l_count);
1069: --OE_BULK_ORDER_PVT.G_LINE_REC.planning_priority
1070: --(OE_BULK_WF_UTIL.G_LINE_INDEX) := l_line_rec.planning_priority;

Line 1070: --(OE_BULK_WF_UTIL.G_LINE_INDEX) := l_line_rec.planning_priority;

1066: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.visible_demand_flag;
1067:
1068: --OE_BULK_ORDER_PVT.G_LINE_REC.PLANNING_PRIORITY.extend(l_count);
1069: --OE_BULK_ORDER_PVT.G_LINE_REC.planning_priority
1070: --(OE_BULK_WF_UTIL.G_LINE_INDEX) := l_line_rec.planning_priority;
1071:
1072: OE_BULK_ORDER_PVT.G_LINE_REC.re_source_flag
1073: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.re_source_flag;
1074: OE_BULK_ORDER_PVT.G_LINE_REC.mfg_lead_time

Line 1073: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.re_source_flag;

1069: --OE_BULK_ORDER_PVT.G_LINE_REC.planning_priority
1070: --(OE_BULK_WF_UTIL.G_LINE_INDEX) := l_line_rec.planning_priority;
1071:
1072: OE_BULK_ORDER_PVT.G_LINE_REC.re_source_flag
1073: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.re_source_flag;
1074: OE_BULK_ORDER_PVT.G_LINE_REC.mfg_lead_time
1075: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.mfg_lead_time;
1076: END IF;
1077:

Line 1075: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.mfg_lead_time;

1071:
1072: OE_BULK_ORDER_PVT.G_LINE_REC.re_source_flag
1073: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.re_source_flag;
1074: OE_BULK_ORDER_PVT.G_LINE_REC.mfg_lead_time
1075: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.mfg_lead_time;
1076: END IF;
1077:
1078: END IF; -- bulk mode.
1079: