[Home] [Help]
PACKAGE: APPS.CSI_T_UI_PVT
Source
1 package csi_t_ui_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivtuis.pls 115.8 2004/05/12 00:17:41 brmanesh ship $*/
3
4 g_pkg_name varchar2(30) := 'csi_t_ui_pkg';
5
6 -- Name : txn_source_rec
7 -- Description : To hold the source information of the txn details
8
9 TYPE txn_source_rec IS RECORD(
10 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12 INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14 SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15 SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16 SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17 FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19 PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20 BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21 SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22 PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23 SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24 LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25 NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
26
27
28 -- Name : txn_source_param_rec
29 -- Description : To hold the source information of the txn details
30
31 TYPE txn_source_param_rec IS RECORD(
32 STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33 SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34 SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35 SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37 INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38 ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39 TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40 TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42 ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43 SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44 SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45 INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46 INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
47
48 FUNCTION g_miss_num RETURN number;
49 FUNCTION g_miss_char RETURN varchar2;
50 FUNCTION g_miss_date RETURN date;
51 FUNCTION g_valid_level(p_level varchar2) RETURN number;
52 FUNCTION g_boolean(p_FLAG varchar2) RETURN varchar2;
53 FUNCTION get_error_constant(err_msg varchar2) RETURN varchar2;
54 FUNCTION ui_txn_source_rec RETURN csi_t_ui_pvt.txn_source_rec;
55 FUNCTION ui_txn_source_param_rec RETURN csi_t_ui_pvt.txn_source_param_rec;
56 FUNCTION ui_txn_line_rec RETURN csi_t_datastructures_grp.txn_line_rec;
57 -- Included for partner ordering changes
58 FUNCTION ui_partner_order_rec RETURN oe_install_base_util.partner_order_rec;
59 -- End Changes for Partner Ordering
60
61 PROCEDURE get_src_txn_type_id(
62 p_order_line_id IN number,
63 px_txn_type_id IN OUT nocopy number,
64 x_return_status OUT nocopy varchar2);
65
66 END csi_t_ui_pvt;