DBA Data[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;