DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_ASSET_PVT

Line 27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);

Line 27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;

27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;

Line 27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27353: l_obj_id NUMBER;

Line 27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27353: l_obj_id NUMBER;
27354: --

Line 27603: csi_asset_pvt.get_instance_assets

27599: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
27600: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
27601: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
27602: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
27603: csi_asset_pvt.get_instance_assets
27604: ( p_api_version => p_api_version
27605: ,p_commit => p_commit
27606: ,p_init_msg_list => p_init_msg_list
27607: ,p_validation_level => p_validation_level

Line 28691: csi_asset_pvt.create_instance_asset

28687: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
28688: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
28689: -- Trap the row in a record and create assets row by row
28690: l_instance_asset_rec := l_asset_tbl(tab_row);
28691: csi_asset_pvt.create_instance_asset
28692: ( p_api_version => p_api_version
28693: ,p_commit => p_commit
28694: ,p_init_msg_list => p_init_msg_list
28695: ,p_validation_level => p_validation_level

Line 32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);

Line 32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;

32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;

Line 32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

Line 32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 32427: csi_asset_pvt.get_instance_assets

32423: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
32424: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
32425: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
32426: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
32427: csi_asset_pvt.get_instance_assets
32428: ( p_api_version => p_api_version
32429: ,p_commit => p_commit
32430: ,p_init_msg_list => p_init_msg_list
32431: ,p_validation_level => p_validation_level

Line 33453: csi_asset_pvt.create_instance_asset

33449: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
33450: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
33451: -- Trap the row in a record and create assets row by row
33452: l_instance_asset_rec := l_asset_tbl(tab_row);
33453: csi_asset_pvt.create_instance_asset
33454: ( p_api_version => p_api_version
33455: ,p_commit => p_commit
33456: ,p_init_msg_list => p_init_msg_list
33457: ,p_validation_level => p_validation_level