8: TYPE T_NUM is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9: TYPE T_V3 is TABLE OF VARCHAR(03) INDEX BY BINARY_INTEGER;
10:
11: TYPE OM_TXN_INFO_REC IS RECORD
12: ( LINE_ID NUMBER := FND_API.G_MISS_NUM,
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
9: TYPE T_V3 is TABLE OF VARCHAR(03) INDEX BY BINARY_INTEGER;
10:
11: TYPE OM_TXN_INFO_REC IS RECORD
12: ( LINE_ID NUMBER := FND_API.G_MISS_NUM,
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
10:
11: TYPE OM_TXN_INFO_REC IS RECORD
12: ( LINE_ID NUMBER := FND_API.G_MISS_NUM,
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
18: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM);
11: TYPE OM_TXN_INFO_REC IS RECORD
12: ( LINE_ID NUMBER := FND_API.G_MISS_NUM,
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
18: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM);
19:
12: ( LINE_ID NUMBER := FND_API.G_MISS_NUM,
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
18: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM);
19:
20: TYPE OM_TXN_INFO_TBL is TABLE OF OM_TXN_INFO_REC INDEX BY BINARY_INTEGER;
13: SHIP_FROM_ORG_ID NUMBER := FND_API.G_MISS_NUM,
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
18: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM);
19:
20: TYPE OM_TXN_INFO_TBL is TABLE OF OM_TXN_INFO_REC INDEX BY BINARY_INTEGER;
21:
14: INV_VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: HEADER_ID NUMBER := FND_API.G_MISS_NUM,
16: REQUEST_DATE DATE := FND_API.G_MISS_DATE,
17: SCHEDULE_SHIP_DATE DATE := FND_API.G_MISS_DATE,
18: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM);
19:
20: TYPE OM_TXN_INFO_TBL is TABLE OF OM_TXN_INFO_REC INDEX BY BINARY_INTEGER;
21:
22: -- This Function can be used to check if Oracle Installed Base
45:
46: --
47: -- This procedure checks if the installation parameters are in
48: -- a frozen state and populates an error message in the message queue
49: -- if not frozen. It also raises the fnd_api.g_exc_error exception
50: --
51: PROCEDURE check_ib_active;
52:
53: TYPE config_session_key IS RECORD(
83: RETURN boolean;
84:
85: PROCEDURE vld_item_ctrl_changes (
86: p_api_version IN NUMBER
87: ,p_commit IN VARCHAR2 := fnd_api.g_false
88: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
89: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
90: ,p_inventory_item_id IN NUMBER
91: ,p_organization_id IN NUMBER
84:
85: PROCEDURE vld_item_ctrl_changes (
86: p_api_version IN NUMBER
87: ,p_commit IN VARCHAR2 := fnd_api.g_false
88: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
89: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
90: ,p_inventory_item_id IN NUMBER
91: ,p_organization_id IN NUMBER
92: ,p_item_attr_name IN VARCHAR2
85: PROCEDURE vld_item_ctrl_changes (
86: p_api_version IN NUMBER
87: ,p_commit IN VARCHAR2 := fnd_api.g_false
88: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
89: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
90: ,p_inventory_item_id IN NUMBER
91: ,p_organization_id IN NUMBER
92: ,p_item_attr_name IN VARCHAR2
93: ,p_new_item_attr_value IN VARCHAR2
180:
181: PROCEDURE get_impacted_item_instances
182: (
183: p_api_version IN NUMBER
184: ,p_commit IN VARCHAR2 := fnd_api.g_false
185: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
187: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
188: ,p_txn_oks_rec IN txn_oks_rec
181: PROCEDURE get_impacted_item_instances
182: (
183: p_api_version IN NUMBER
184: ,p_commit IN VARCHAR2 := fnd_api.g_false
185: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
187: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
188: ,p_txn_oks_rec IN txn_oks_rec
189: ,x_return_status OUT NOCOPY VARCHAR2
182: (
183: p_api_version IN NUMBER
184: ,p_commit IN VARCHAR2 := fnd_api.g_false
185: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
187: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
188: ,p_txn_oks_rec IN txn_oks_rec
189: ,x_return_status OUT NOCOPY VARCHAR2
190: ,x_msg_count OUT NOCOPY NUMBER