DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_ASSET_PVT

Line 57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

53: l_location_tbl csi_item_instance_pvt.location_tbl;
54: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;

Line 58: l_asset_count_rec csi_asset_pvt.asset_count_rec;

54: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;

Line 59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;

Line 60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;

Line 634: csi_asset_pvt.create_instance_asset

630: FOR tab_row IN p_asset_assignment_tbl.FIRST .. p_asset_assignment_tbl.LAST
631: LOOP
632: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
633: p_asset_assignment_tbl(tab_row).instance_id := p_instance_rec.instance_id;
634: csi_asset_pvt.create_instance_asset
635: (
636: p_api_version => p_api_version
637: ,p_commit => fnd_api.g_false
638: ,p_init_msg_list => p_init_msg_list

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

653: WHILE l_msg_count > 0 LOOP
654: x_msg_data := FND_MSG_PUB.GET
655: ( l_msg_index,
656: FND_API.G_FALSE );
657: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
658: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
659: l_msg_index := l_msg_index + 1;
660: l_msg_count := l_msg_count - 1;
661: END LOOP;

Line 1290: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

1286: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
1287: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
1288: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1289: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1290: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1291: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1292: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1294: l_updated BOOLEAN := FALSE;

Line 1291: l_asset_count_rec csi_asset_pvt.asset_count_rec;

1287: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
1288: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1289: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1290: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1291: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1292: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1294: l_updated BOOLEAN := FALSE;
1295: l_date BOOLEAN := FALSE;

Line 1292: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1288: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1289: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1290: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1291: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1292: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1294: l_updated BOOLEAN := FALSE;
1295: l_date BOOLEAN := FALSE;
1296: l_curr_party_id NUMBER; -- Added for 2972082

Line 1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1289: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1290: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1291: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1292: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1294: l_updated BOOLEAN := FALSE;
1295: l_date BOOLEAN := FALSE;
1296: l_curr_party_id NUMBER; -- Added for 2972082
1297: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082

Line 2677: csi_asset_pvt.create_instance_asset

2673: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
2674: IF ((p_asset_assignment_tbl(tab_row).instance_asset_id IS NULL)
2675: OR
2676: (p_asset_assignment_tbl(tab_row).instance_asset_id = FND_API.G_MISS_NUM)) THEN
2677: csi_asset_pvt.create_instance_asset
2678: (p_api_version => p_api_version
2679: ,p_commit => fnd_api.g_false
2680: ,p_init_msg_list => p_init_msg_list
2681: ,p_validation_level => p_validation_level

Line 2694: csi_asset_pvt.update_instance_asset

2690: ,p_asset_loc_tbl => l_asset_loc_tbl
2691: );
2692: ELSE
2693: --call the update assets api
2694: csi_asset_pvt.update_instance_asset
2695: (p_api_version => p_api_version
2696: ,p_commit => fnd_api.g_false
2697: ,p_init_msg_list => p_init_msg_list
2698: ,p_validation_level => p_validation_level

Line 4823: csi_asset_pvt.get_instance_assets

4819:
4820: IF p_get_asset_assignments = fnd_api.g_true THEN
4821:
4822: l_instance_asset_query_rec.instance_id := p_instance_rec.instance_id;
4823: csi_asset_pvt.get_instance_assets
4824: (
4825: p_api_version => p_api_version
4826: ,p_commit => fnd_api.g_false
4827: ,p_init_msg_list => fnd_api.g_false

Line 4844: csi_gen_utility_pvt.put_line( ' Error from csi_asset_pvt.get_instance_assets.. ');

4840: WHILE l_msg_count > 0 LOOP
4841: x_msg_data := FND_MSG_PUB.GET
4842: ( l_msg_index,
4843: FND_API.G_FALSE );
4844: csi_gen_utility_pvt.put_line( ' Error from csi_asset_pvt.get_instance_assets.. ');
4845: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4846: l_msg_index := l_msg_index + 1;
4847: l_msg_count := l_msg_count - 1;
4848: END LOOP;