DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_GLOBALS

Line 910: l_control_rec OE_GLOBALS.Control_Rec_Type;

906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
910: l_control_rec OE_GLOBALS.Control_Rec_Type;
911:
912: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
913: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
914:

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

1602: END IF;
1603:
1604: --If its new Shipment Request setting action_request_table to book sales order.
1605: IF nvl(l_header_rec.header_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
1606: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
1607: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1608: END IF;
1609:
1610: l_header_doc_ref := l_header_rec.orig_sys_document_ref;

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

1603:
1604: --If its new Shipment Request setting action_request_table to book sales order.
1605: IF nvl(l_header_rec.header_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
1606: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
1607: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1608: END IF;
1609:
1610: l_header_doc_ref := l_header_rec.orig_sys_document_ref;
1611:

Line 1861: IF x_action_request_tbl(1).request_type = OE_GLOBALS.G_BOOK_ORDER and

1857: ', Return_status: ' || x_action_request_tbl(i).return_status);
1858: END IF;
1859: --
1860:
1861: IF x_action_request_tbl(1).request_type = OE_GLOBALS.G_BOOK_ORDER and
1862: x_action_request_tbl(1).entity_code = OE_GLOBALS.G_ENTITY_HEADER and
1863: x_action_request_tbl(i).return_status <> 'S'
1864: THEN
1865: --

Line 1862: x_action_request_tbl(1).entity_code = OE_GLOBALS.G_ENTITY_HEADER and

1858: END IF;
1859: --
1860:
1861: IF x_action_request_tbl(1).request_type = OE_GLOBALS.G_BOOK_ORDER and
1862: x_action_request_tbl(1).entity_code = OE_GLOBALS.G_ENTITY_HEADER and
1863: x_action_request_tbl(i).return_status <> 'S'
1864: THEN
1865: --
1866: IF l_debug_on THEN

Line 5245: IF x_line_tbl(i).operation = OE_GLOBALS.G_OPR_UPDATE THEN

5241: x_line_tbl.count > 0
5242: THEN -- {
5243: FOR i in x_line_tbl.first..x_line_tbl.last
5244: LOOP
5245: IF x_line_tbl(i).operation = OE_GLOBALS.G_OPR_UPDATE THEN
5246: IF nvl(x_header_rec.sold_to_customer_ref, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
5247: x_line_tbl(i).sold_to_customer_ref := x_header_rec.sold_to_customer_ref;
5248: END IF;
5249:

Line 5407: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

5403: END IF;
5404:
5405: IF p_action_type = 'D' -- { Action Type 'CANCEL'
5406: THEN
5407: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5408: x_header_rec.header_id := l_header_id;
5409: x_header_rec.change_reason := 'Not provided';
5410: x_header_rec.cancelled_flag := 'Y';
5411: ELSE

Line 5415: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

5411: ELSE
5412: --Populating header record
5413:
5414: IF l_header_id is NOT NULL THEN -- { Header Id not null
5415: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5416: x_header_rec.header_id := l_header_id;
5417: x_header_rec.order_type_id := p_om_header_rec.order_type_id;
5418: ELSE -- Going to create new Sales Order
5419: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

Line 5419: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

5415: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5416: x_header_rec.header_id := l_header_id;
5417: x_header_rec.order_type_id := p_om_header_rec.order_type_id;
5418: ELSE -- Going to create new Sales Order
5419: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
5420: x_header_rec.order_number := p_del_interface_rec.order_number;
5421:
5422: x_header_rec.order_type_id := p_om_header_rec.order_type_id;
5423: x_header_rec.price_list_id := p_om_header_rec.price_list_id;

Line 6440: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_UPDATE;

6436: x_line_details_tbl(p_details_interface_rec_tab(i).line_number) := p_details_interface_rec_tab(i).delivery_detail_interface_id; */
6437:
6438: IF (l_line_id is not null) THEN /* Line Update Mode */
6439: x_line_tbl(l_line_cnt).line_id := l_line_id;
6440: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_UPDATE;
6441: x_line_tbl(l_line_cnt).calculate_price_flag := 'N';
6442:
6443: IF nvl(p_details_interface_rec_tab(i).requested_quantity, FND_API.G_MISS_NUM) <>
6444: nvl(p_om_line_tbl_type(i).ordered_quantity, FND_API.G_MISS_NUM)

Line 6559: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_CREATE;

6555: -- LSP PROJECT.
6556: SELECT oe_order_lines_S.NEXTVAL into l_line_id from dual;
6557: x_line_tbl(l_line_cnt).line_id := l_line_id;
6558: -- LSP PROJECT : end
6559: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_CREATE;
6560: x_line_tbl(l_line_cnt).calculate_price_flag := 'N';
6561: x_line_tbl(l_line_cnt).line_number := p_details_interface_rec_tab(i).line_number;
6562: x_line_tbl(l_line_cnt).shipment_number := 1;
6563: x_line_tbl(l_line_cnt).inventory_item_id := p_details_interface_rec_tab(i).inventory_item_id;

Line 6611: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_UPDATE;

6607: || ', Line Number => ' || l_non_interface_rec.line_number );
6608: END IF;
6609: l_line_cnt := l_line_cnt + 1;
6610: x_line_tbl(l_line_cnt) := OE_ORDER_PUB.G_MISS_LINE_REC;
6611: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_UPDATE;
6612: x_line_tbl(l_line_cnt).line_id := l_non_interface_rec.line_id;
6613: x_line_tbl(l_line_cnt).calculate_price_flag := 'N';
6614: -- LSP PROJECT: commented the following after discussion with UMA.
6615: -- No need to change these values on the existing lines.