DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on OE_GLOBALS

Line 467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;
467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
468:
469: l_oe_header_id NUMBER;
470: j number := 0;
471: l_msg VARCHAR2(2000);

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

578:
579: /* l_oe_header_rec.cancelled_flag := 'Y';
580: l_oe_header_rec.flow_status_code := 'CANCELLED';
581: l_oe_header_rec.open_flag := 'N';
582: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
583: l_oe_header_rec.change_reason := p_header_rec.change_reason;
584: l_oe_header_rec.change_comments := p_header_rec.change_comments;
585: */
586: oe_line_util.Query_Rows

Line 601: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;

597: l_oe_line_tbl(J).db_flag := FND_API.G_TRUE;
598: l_oe_line_tbl(J).cancelled_quantity := l_oe_line_old_tbl(J).ordered_quantity;
599:
600: l_oe_line_tbl(j).ordered_quantity :=0;
601: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
602: l_oe_line_tbl(j).change_reason := p_header_rec.change_reason;
603:
604:
605: l_oe_line_tbl(j).change_comments := p_header_Rec.change_comments;

Line 654: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;

650: l_oe_line_tbl(J).db_flag := FND_API.G_TRUE;
651: l_oe_line_tbl(J).cancelled_quantity := l_oe_line_tbl(J).ordered_quantity;
652:
653: l_oe_line_tbl(j).ordered_quantity :=0;
654: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
655: l_oe_line_tbl(j).change_reason := p_line_table(i).change_reason;
656:
657: l_oe_line_tbl(j).change_comments := p_line_table(i).change_comments;
658:

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

810:
811: l_oe_header_rec.cancelled_flag := 'Y';
812: l_oe_header_rec.flow_status_code := 'CANCELLED';
813: l_oe_header_rec.open_flag := 'N';
814: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
815: l_oe_header_rec.change_reason := p_header_rec.change_reason;
816: l_oe_header_rec.change_comments := p_header_rec.change_comments;
817:
818: l_oe_control_rec.controlled_operation := TRUE;

Line 1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1048:
1049: CURSOR rowid_cur IS
1050: SELECT rowid FROM PO_REQUISITION_HEADERS
1051: WHERE requisition_header_id = l_header_rec.requisition_header_id;

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

1874: l_oe_header_rec.price_list_id := l_price_list_id;
1875: END IF;
1876:
1877: -- Indicates to process order that a new header is being created
1878: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1879:
1880: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
1881: IF (l_header_rec.order_header_id is null) THEN
1882: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

1890: p_header_id => l_header_rec.order_header_id,
1891: x_header_rec => l_oe_header_rec);
1892:
1893: -- Indicates to process order that header is to be updated
1894: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1895: l_oe_header_rec.booked_flag := l_line_tbl(1).booked_flag;
1896:
1897: END IF;
1898:

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

2355: l_oe_line_Rec.unit_Selling_price := l_item_cost;
2356: l_oe_line_Rec.open_flag := 'Y';
2357: l_oe_line_rec.ordered_quantity := l_line_tbl(i).ordered_quantity;
2358: l_oe_line_rec.booked_flag := l_line_tbl(i).booked_Flag; --N;
2359: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2360: END IF;
2361:
2362: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
2363: IF (p_process_Type = 'REQUISITION') THEN

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

2411: -- l_oe_line_Rec := oe_line_util.Query_Row(l_line_tbl(i).order_line_id);
2412:
2413: l_oe_line_rec.line_id := l_line_tbl(i).order_line_id;
2414: l_oe_line_rec.booked_flag := l_line_tbl(i).booked_Flag;
2415: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2416: END If;
2417:
2418: END IF;
2419:

Line 2608: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN

2604: || l_oe_header_rec.operation);
2605: end if;
2606:
2607: -- CALL TO PROCESS ORDER
2608: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2609: -- CALL TO PROCESS ORDER
2610: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2611: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
2612: OE_Order_PUB.Process_Order(

Line 2610: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

2606:
2607: -- CALL TO PROCESS ORDER
2608: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2609: -- CALL TO PROCESS ORDER
2610: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2611: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
2612: OE_Order_PUB.Process_Order(
2613: p_org_id => l_source_operating_unit
2614: ,p_api_version_number => l_api_version_number

Line 2611: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;

2607: -- CALL TO PROCESS ORDER
2608: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2609: -- CALL TO PROCESS ORDER
2610: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2611: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
2612: OE_Order_PUB.Process_Order(
2613: p_org_id => l_source_operating_unit
2614: ,p_api_version_number => l_api_version_number
2615: ,p_init_msg_list => FND_API.G_TRUE