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 622: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

618:
619: /* l_oe_header_rec.cancelled_flag := 'Y';
620: l_oe_header_rec.flow_status_code := 'CANCELLED';
621: l_oe_header_rec.open_flag := 'N';
622: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
623: l_oe_header_rec.change_reason := p_header_rec.change_reason;
624: l_oe_header_rec.change_comments := p_header_rec.change_comments;
625: */
626: oe_line_util.Query_Rows

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

637: l_oe_line_tbl(J).db_flag := FND_API.G_TRUE;
638: l_oe_line_tbl(J).cancelled_quantity := l_oe_line_old_tbl(J).ordered_quantity;
639:
640: l_oe_line_tbl(j).ordered_quantity :=0;
641: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
642: l_oe_line_tbl(j).change_reason := p_header_rec.change_reason;
643:
644:
645: l_oe_line_tbl(j).change_comments := p_header_Rec.change_comments;

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

707: l_oe_line_tbl(J).db_flag := FND_API.G_TRUE;
708: l_oe_line_tbl(J).cancelled_quantity := l_oe_line_tbl(J).ordered_quantity;
709:
710: l_oe_line_tbl(j).ordered_quantity :=0;
711: l_oe_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
712: l_oe_line_tbl(j).change_reason := p_line_table(i).change_reason;
713:
714: l_oe_line_tbl(j).change_comments := p_line_table(i).change_comments;
715:

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

890:
891: l_oe_header_rec.cancelled_flag := 'Y';
892: l_oe_header_rec.flow_status_code := 'CANCELLED';
893: l_oe_header_rec.open_flag := 'N';
894: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
895: l_oe_header_rec.change_reason := p_header_rec.change_reason;
896: l_oe_header_rec.change_comments := p_header_rec.change_comments;
897:
898: l_oe_control_rec.controlled_operation := TRUE;

Line 1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1170:
1171: CURSOR rowid_cur IS
1172: SELECT rowid FROM PO_REQUISITION_HEADERS
1173: WHERE requisition_header_id = l_header_rec.requisition_header_id;

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

3029: l_oe_header_rec.price_list_id := l_price_list_id;
3030: END IF;
3031:
3032: -- Indicates to process order that a new header is being created
3033: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3034:
3035: ELSIF (l_header_rec.operation = G_OPR_UPDATE) THEN
3036: IF (l_header_rec.order_header_id is null) THEN
3037: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

3045: p_header_id => l_header_rec.order_header_id,
3046: x_header_rec => l_oe_header_rec);
3047:
3048: -- Indicates to process order that header is to be updated
3049: l_oe_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3050: l_oe_header_rec.booked_flag := l_line_tbl(1).booked_flag;
3051:
3052: END IF;
3053:

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

3620: l_oe_line_rec.booked_flag := 'N';
3621: end if;
3622: */
3623:
3624: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3625: END IF;
3626:
3627: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
3628: IF (p_process_Type = 'REQUISITION') THEN

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

3676: -- l_oe_line_Rec := oe_line_util.Query_Row(l_line_tbl(i).order_line_id);
3677:
3678: l_oe_line_rec.line_id := l_line_tbl(i).order_line_id;
3679: l_oe_line_rec.booked_flag := l_line_tbl(i).booked_Flag;
3680: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3681: END If;
3682:
3683: END IF;
3684:

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

3879: || l_oe_header_rec.operation);
3880: end if;
3881:
3882: -- CALL TO PROCESS ORDER
3883: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
3884:
3885: -- CALL TO PROCESS ORDER
3886: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
3887:

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

3882: -- CALL TO PROCESS ORDER
3883: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
3884:
3885: -- CALL TO PROCESS ORDER
3886: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
3887:
3888: if nvl(p_book_order, 'Y') = 'Y' then
3889: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3890: end if;

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

3885: -- CALL TO PROCESS ORDER
3886: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
3887:
3888: if nvl(p_book_order, 'Y') = 'Y' then
3889: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3890: end if;
3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');

Line 4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;

4806: po_moac_utils_pvt.set_org_context(l_org_id);
4807: end if;
4808:
4809: l_action_request_tbl := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;
4811: l_action_request_tbl(1).entity_code := oe_globals.g_entity_header;
4812: l_action_request_tbl(1).entity_id := p_oe_header_id;
4813:
4814: OE_ORDER_PUB.process_order(

Line 4811: l_action_request_tbl(1).entity_code := oe_globals.g_entity_header;

4807: end if;
4808:
4809: l_action_request_tbl := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;
4811: l_action_request_tbl(1).entity_code := oe_globals.g_entity_header;
4812: l_action_request_tbl(1).entity_id := p_oe_header_id;
4813:
4814: OE_ORDER_PUB.process_order(
4815: p_api_version_number => 1.0,

Line 4967: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

4963: end if;
4964:
4965: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
4966: l_line_tbl(1).line_id := p_oe_line_id;
4967: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4968: l_line_tbl(1).shipping_method_code := p_ship_method;
4969:
4970: -- bug # 12664116
4971: select ship_from_org_id into l_ship_from_org_id from oe_order_lines_all where line_id = p_oe_line_id;