DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ASSET_PVT

Line 5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --

Line 5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;

5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;

Line 5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;

Line 5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;

Line 7249: csi_asset_pvt.set_fa_sync_flag (

7245: l_location_id := p_instance_tbl(inst_tab_row).location_id;
7246: END IF;
7247: -- Pass this Location ID to Set_Sync_Flag and validate against CSI_A_LOCATIONS
7248: IF l_location_id IS NOT NULL THEN
7249: csi_asset_pvt.set_fa_sync_flag (
7250: px_instance_asset_rec => p_asset_assignment_tbl(tab_row),
7251: p_location_id => l_location_id,
7252: x_return_status => x_return_status,
7253: x_error_msg => x_msg_data);

Line 7259: csi_asset_pvt.create_instance_asset

7255: --
7256: -- The above routine just tries to set the FA Sync Flag. It doesn't retun any error
7257: END IF; -- Validation_reqd check
7258: --
7259: csi_asset_pvt.create_instance_asset
7260: (
7261: p_api_version => p_api_version
7262: ,p_commit => fnd_api.g_false
7263: ,p_init_msg_list => p_init_msg_list

Line 7277: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');

7273: ,p_called_from_grp => fnd_api.g_true
7274: );
7275:
7276: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7277: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
7278: l_msg_index := 1;
7279: l_msg_count := x_msg_count;
7280: WHILE l_msg_count > 0 LOOP
7281: x_msg_data := FND_MSG_PUB.GET

Line 8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
8291: --

Line 8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;

8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
8291: --
8292: CURSOR instance_csr(p_ins_id IN NUMBER) is

Line 8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
8291: --
8292: CURSOR instance_csr(p_ins_id IN NUMBER) is
8293: SELECT

Line 8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
8291: --
8292: CURSOR instance_csr(p_ins_id IN NUMBER) is
8293: SELECT
8294: INSTANCE_ID

Line 9202: csi_asset_pvt.create_instance_asset

9198: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
9199: IF ((p_asset_assignment_tbl(tab_row).instance_asset_id IS NULL)
9200: OR
9201: (p_asset_assignment_tbl(tab_row).instance_asset_id = FND_API.G_MISS_NUM)) THEN
9202: csi_asset_pvt.create_instance_asset
9203: (p_api_version => p_api_version
9204: ,p_commit => fnd_api.g_false
9205: ,p_init_msg_list => p_init_msg_list
9206: ,p_validation_level => p_validation_level

Line 9219: csi_asset_pvt.update_instance_asset

9215: ,p_asset_loc_tbl => l_asset_loc_tbl
9216: );
9217: ELSE
9218: --call the update assets api
9219: csi_asset_pvt.update_instance_asset
9220: (p_api_version => p_api_version
9221: ,p_commit => fnd_api.g_false
9222: ,p_init_msg_list => p_init_msg_list
9223: ,p_validation_level => p_validation_level

Line 9236: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');

9232: ,p_asset_loc_tbl => l_asset_loc_tbl
9233: );
9234: END IF;
9235: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9236: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
9237: l_msg_index := 1;
9238: l_msg_count := x_msg_count;
9239: WHILE l_msg_count > 0 LOOP
9240: x_msg_data := FND_MSG_PUB.GET