DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_ASSET_PVT

Line 27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);

Line 27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;

27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;

Line 27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27930: l_obj_id NUMBER;

Line 27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27930: l_obj_id NUMBER;
27931: --

Line 28180: csi_asset_pvt.get_instance_assets

28176: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
28177: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
28178: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
28179: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
28180: csi_asset_pvt.get_instance_assets
28181: ( p_api_version => p_api_version
28182: ,p_commit => p_commit
28183: ,p_init_msg_list => p_init_msg_list
28184: ,p_validation_level => p_validation_level

Line 29268: csi_asset_pvt.create_instance_asset

29264: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
29265: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
29266: -- Trap the row in a record and create assets row by row
29267: l_instance_asset_rec := l_asset_tbl(tab_row);
29268: csi_asset_pvt.create_instance_asset
29269: ( p_api_version => p_api_version
29270: ,p_commit => p_commit
29271: ,p_init_msg_list => p_init_msg_list
29272: ,p_validation_level => p_validation_level

Line 32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);

Line 32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;

32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;

Line 32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

Line 32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 33048: csi_asset_pvt.get_instance_assets

33044: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
33045: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
33046: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
33047: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
33048: csi_asset_pvt.get_instance_assets
33049: ( p_api_version => p_api_version
33050: ,p_commit => p_commit
33051: ,p_init_msg_list => p_init_msg_list
33052: ,p_validation_level => p_validation_level

Line 34081: csi_asset_pvt.create_instance_asset

34077: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
34078: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
34079: -- Trap the row in a record and create assets row by row
34080: l_instance_asset_rec := l_asset_tbl(tab_row);
34081: csi_asset_pvt.create_instance_asset
34082: ( p_api_version => p_api_version
34083: ,p_commit => p_commit
34084: ,p_init_msg_list => p_init_msg_list
34085: ,p_validation_level => p_validation_level