DBA Data[Home] [Help]

APPS.MRP_CREATE_SCHEDULE_ISO dependencies on OE_GLOBALS

Line 434: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

430: log_message('l_org_trans_rel_cur.load_type :'||l_org_trans_rel_cur.load_type);
431: IF (l_org_trans_rel_cur.load_type = DRP_REQ_LOAD) THEN
432: v_load_type := 'Release';
433:
434: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
435: l_oe_header_rec.org_id := l_org_trans_rel_cur.src_operating_unit;
436: l_oe_header_rec.order_type_id := l_order_type_id;
437:
438: -- requisition number

Line 450: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

446: l_oe_header_rec.shipping_method_code := l_org_trans_rel_cur.ship_method;
447:
448:
449: /* For the line */
450: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
451: l_oe_line_rec.ORIG_SYS_DOCUMENT_REF := l_req_header_rec.segment1;
452: l_oe_line_rec.SOURCE_DOCUMENT_ID := l_req_header_rec.requisition_header_id;
453: l_oe_line_rec.source_document_type_id := l_order_source_id;
454: l_oe_line_rec.order_source_id := l_order_source_id;

Line 471: lv_action_rec.request_type := OE_GLOBALS.G_BOOK_ORDER;

467: l_org_trans_rel_cur.firm_demand_flag;
468: l_oe_line_rec.Earliest_ship_date := l_org_trans_rel_cur.Earliest_ship_date; -- Bug# 4306515
469:
470: l_oe_line_rec.shipping_method_code := l_org_trans_rel_cur.ship_method;
471: lv_action_rec.request_type := OE_GLOBALS.G_BOOK_ORDER;
472: lv_action_rec.entity_code := OE_GLOBALS.G_ENTITY_HEADER;
473:
474: If (l_org_trans_rel_cur.plan_type = 8) Then
475: l_oe_line_rec.subinventory := lv_source_subinv; -- for bug 8407184

Line 472: lv_action_rec.entity_code := OE_GLOBALS.G_ENTITY_HEADER;

468: l_oe_line_rec.Earliest_ship_date := l_org_trans_rel_cur.Earliest_ship_date; -- Bug# 4306515
469:
470: l_oe_line_rec.shipping_method_code := l_org_trans_rel_cur.ship_method;
471: lv_action_rec.request_type := OE_GLOBALS.G_BOOK_ORDER;
472: lv_action_rec.entity_code := OE_GLOBALS.G_ENTITY_HEADER;
473:
474: If (l_org_trans_rel_cur.plan_type = 8) Then
475: l_oe_line_rec.subinventory := lv_source_subinv; -- for bug 8407184
476: END IF;

Line 603: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

599: l_sch_rec.line_id := l_line_tbl(1).line_id;
600:
601: ELSE /* For Re-Schedule ISO */
602: v_load_type := 'Reschedule';
603: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
604:
605: OPEN c_header_id(l_org_trans_rel_cur.sales_order_number);
606: FETCH c_header_id INTO l_header_id;
607: CLOSE c_header_id;

Line 618: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

614:
615: l_oe_header_rec.header_id := l_header_id;
616: l_oe_header_rec.order_number := l_org_trans_rel_cur.sales_order_number;
617:
618: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
619: l_oe_line_rec.line_id := l_org_trans_rel_cur.sales_order_line_id;
620: l_oe_line_rec.ordered_quantity := l_org_trans_rel_cur.quantity;
621: l_oe_line_rec.schedule_ship_date := l_org_trans_rel_cur.ship_date;
622: l_oe_line_rec.change_reason := 'SYSTEM';