DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_BULK_ORDER_PVT

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 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 1042: OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

1038: -- not comparing as we have to either do a blind assign or
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

Line 1046: IF OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code

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
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);

Line 1053: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code

1049: THEN
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

Line 1055: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_ship_date

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;
1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id

Line 1057: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_arrival_date

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;
1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code

Line 1059: OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id

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;
1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time

Line 1061: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_method_code

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;
1065: OE_BULK_ORDER_PVT.G_LINE_REC.visible_demand_flag

Line 1063: OE_BULK_ORDER_PVT.G_LINE_REC.delivery_lead_time

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;
1067:

Line 1065: OE_BULK_ORDER_PVT.G_LINE_REC.visible_demand_flag

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);
1069: --OE_BULK_ORDER_PVT.G_LINE_REC.planning_priority

Line 1068: --OE_BULK_ORDER_PVT.G_LINE_REC.PLANNING_PRIORITY.extend(l_count);

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;
1071:
1072: OE_BULK_ORDER_PVT.G_LINE_REC.re_source_flag

Line 1069: --OE_BULK_ORDER_PVT.G_LINE_REC.planning_priority

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;
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;

Line 1072: OE_BULK_ORDER_PVT.G_LINE_REC.re_source_flag

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
1075: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.mfg_lead_time;
1076: END IF;

Line 1074: OE_BULK_ORDER_PVT.G_LINE_REC.mfg_lead_time

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:
1078: END IF; -- bulk mode.