DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on CSP_PLANNED_ORDERS

Line 1: PACKAGE BODY CSP_PLANNED_ORDERS AS

1: PACKAGE BODY CSP_PLANNED_ORDERS AS
2: /* $Header: cspvppob.pls 120.11 2008/03/26 17:11:46 hhaugeru ship $ */
3: --
4: -- Purpose: To create planned orders for a warehouse
5: --

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_planned_orders';

7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- phegde 6/13/2005 Created package body
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_planned_orders';
12: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvppob.pls';
13:
14: PROCEDURE create_orders
15: ( p_api_version IN NUMBER

Line 20: , px_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type

16: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
17: , p_commit IN VARCHAR2 := FND_API.G_FALSE
18: , p_organization_id NUMBER
19: , p_inventory_item_id NUMBER
20: , px_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type
21: , x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2)
24: IS

Line 30: l_line_tbl csp_planned_orders.line_tbl_type;

26: l_api_name CONSTANT VARCHAR2(30) := 'create_orders';
27: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2(2000);
30: l_line_tbl csp_planned_orders.line_tbl_type;
31: l_order_line_tbl csp_parts_requirement.line_tbl_type;
32: l_order_hdr_rec csp_parts_requirement.header_rec_type;
33: l_po_line_tbl csp_parts_requirement.line_tbl_type;
34: l_po_hdr_rec csp_parts_requirement.header_rec_type;