DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ASSET_PVT

Line 5866: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

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

Line 5867: l_asset_count_rec csi_asset_pvt.asset_count_rec;

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

Line 5868: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

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

Line 5869: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

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

Line 6911: csi_asset_pvt.set_fa_sync_flag (

6907: l_location_id := p_instance_tbl(inst_tab_row).location_id;
6908: END IF;
6909: -- Pass this Location ID to Set_Sync_Flag and validate against CSI_A_LOCATIONS
6910: IF l_location_id IS NOT NULL THEN
6911: csi_asset_pvt.set_fa_sync_flag (
6912: px_instance_asset_rec => p_asset_assignment_tbl(tab_row),
6913: p_location_id => l_location_id,
6914: x_return_status => x_return_status,
6915: x_error_msg => x_msg_data);

Line 6921: csi_asset_pvt.create_instance_asset

6917: --
6918: -- The above routine just tries to set the FA Sync Flag. It doesn't retun any error
6919: END IF; -- Validation_reqd check
6920: --
6921: csi_asset_pvt.create_instance_asset
6922: (
6923: p_api_version => p_api_version
6924: ,p_commit => fnd_api.g_false
6925: ,p_init_msg_list => p_init_msg_list

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

6935: ,p_called_from_grp => fnd_api.g_true
6936: );
6937:
6938: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6939: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
6940: l_msg_index := 1;
6941: l_msg_count := x_msg_count;
6942: WHILE l_msg_count > 0 LOOP
6943: x_msg_data := FND_MSG_PUB.GET

Line 7750: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

7746: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
7747: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
7748: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
7749: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
7750: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
7751: l_asset_count_rec csi_asset_pvt.asset_count_rec;
7752: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
7753: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
7754: --

Line 7751: l_asset_count_rec csi_asset_pvt.asset_count_rec;

7747: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
7748: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
7749: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
7750: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
7751: l_asset_count_rec csi_asset_pvt.asset_count_rec;
7752: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
7753: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
7754: --
7755: CURSOR instance_csr(p_ins_id IN NUMBER) is

Line 7752: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

7748: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
7749: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
7750: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
7751: l_asset_count_rec csi_asset_pvt.asset_count_rec;
7752: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
7753: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
7754: --
7755: CURSOR instance_csr(p_ins_id IN NUMBER) is
7756: SELECT

Line 7753: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

7749: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
7750: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
7751: l_asset_count_rec csi_asset_pvt.asset_count_rec;
7752: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
7753: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
7754: --
7755: CURSOR instance_csr(p_ins_id IN NUMBER) is
7756: SELECT
7757: INSTANCE_ID

Line 8656: csi_asset_pvt.create_instance_asset

8652: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
8653: IF ((p_asset_assignment_tbl(tab_row).instance_asset_id IS NULL)
8654: OR
8655: (p_asset_assignment_tbl(tab_row).instance_asset_id = FND_API.G_MISS_NUM)) THEN
8656: csi_asset_pvt.create_instance_asset
8657: (p_api_version => p_api_version
8658: ,p_commit => fnd_api.g_false
8659: ,p_init_msg_list => p_init_msg_list
8660: ,p_validation_level => p_validation_level

Line 8673: csi_asset_pvt.update_instance_asset

8669: ,p_asset_loc_tbl => l_asset_loc_tbl
8670: );
8671: ELSE
8672: --call the update assets api
8673: csi_asset_pvt.update_instance_asset
8674: (p_api_version => p_api_version
8675: ,p_commit => fnd_api.g_false
8676: ,p_init_msg_list => p_init_msg_list
8677: ,p_validation_level => p_validation_level

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

8686: ,p_asset_loc_tbl => l_asset_loc_tbl
8687: );
8688: END IF;
8689: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8690: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
8691: l_msg_index := 1;
8692: l_msg_count := x_msg_count;
8693: WHILE l_msg_count > 0 LOOP
8694: x_msg_data := FND_MSG_PUB.GET