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(
106: RETURN boolean;
107:
108: PROCEDURE vld_item_ctrl_changes (
109: p_api_version IN NUMBER
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
112: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
113: ,p_inventory_item_id IN NUMBER
114: ,p_organization_id IN NUMBER
107:
108: PROCEDURE vld_item_ctrl_changes (
109: p_api_version IN NUMBER
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
112: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
113: ,p_inventory_item_id IN NUMBER
114: ,p_organization_id IN NUMBER
115: ,p_item_attr_name IN VARCHAR2
108: PROCEDURE vld_item_ctrl_changes (
109: p_api_version IN NUMBER
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
112: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
113: ,p_inventory_item_id IN NUMBER
114: ,p_organization_id IN NUMBER
115: ,p_item_attr_name IN VARCHAR2
116: ,p_new_item_attr_value IN VARCHAR2
203:
204: PROCEDURE get_impacted_item_instances
205: (
206: p_api_version IN NUMBER
207: ,p_commit IN VARCHAR2 := fnd_api.g_false
208: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
209: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
210: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
211: ,p_txn_oks_rec IN txn_oks_rec
204: PROCEDURE get_impacted_item_instances
205: (
206: p_api_version IN NUMBER
207: ,p_commit IN VARCHAR2 := fnd_api.g_false
208: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
209: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
210: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
211: ,p_txn_oks_rec IN txn_oks_rec
212: ,x_return_status OUT NOCOPY VARCHAR2
205: (
206: p_api_version IN NUMBER
207: ,p_commit IN VARCHAR2 := fnd_api.g_false
208: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
209: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
210: ,x_txn_inst_tbl OUT NOCOPY txn_inst_tbl
211: ,p_txn_oks_rec IN txn_oks_rec
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ,x_msg_count OUT NOCOPY NUMBER
241:
242: --start bug no. 7135052, new api added to get install location
243: PROCEDURE get_instance_install_location (
244: p_api_version IN NUMBER
245: ,p_commit IN VARCHAR2 := fnd_api.g_false
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
247: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
248: ,p_instance_id IN NUMBER
249: ,x_install_address_rec OUT NOCOPY install_address_rec
242: --start bug no. 7135052, new api added to get install location
243: PROCEDURE get_instance_install_location (
244: p_api_version IN NUMBER
245: ,p_commit IN VARCHAR2 := fnd_api.g_false
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
247: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
248: ,p_instance_id IN NUMBER
249: ,x_install_address_rec OUT NOCOPY install_address_rec
250: ,x_return_status OUT NOCOPY VARCHAR2
243: PROCEDURE get_instance_install_location (
244: p_api_version IN NUMBER
245: ,p_commit IN VARCHAR2 := fnd_api.g_false
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
247: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
248: ,p_instance_id IN NUMBER
249: ,x_install_address_rec OUT NOCOPY install_address_rec
250: ,x_return_status OUT NOCOPY VARCHAR2
251: ,x_msg_count OUT NOCOPY NUMBER