eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCE_PVT

Line 2369: p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl

2365: END Build_Acct_Hist_Rec_of_Table;
2366: --
2367: PROCEDURE Build_Owner_Pty_Acct_Rec_Table
2368: (
2369: p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
2370: ,p_owner_pty_acct_rec_tab IN OUT NOCOPY csi_item_instance_pvt.owner_pty_acct_rec_tab
2371: ) IS
2372: BEGIN
2373: FOR i in p_owner_pty_acct_tbl.FIRST .. p_owner_pty_acct_tbl.LAST LOOP

Line 2370: ,p_owner_pty_acct_rec_tab IN OUT NOCOPY csi_item_instance_pvt.owner_pty_acct_rec_tab

2366: --
2367: PROCEDURE Build_Owner_Pty_Acct_Rec_Table
2368: (
2369: p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
2370: ,p_owner_pty_acct_rec_tab IN OUT NOCOPY csi_item_instance_pvt.owner_pty_acct_rec_tab
2371: ) IS
2372: BEGIN
2373: FOR i in p_owner_pty_acct_tbl.FIRST .. p_owner_pty_acct_tbl.LAST LOOP
2374: p_owner_pty_acct_rec_tab.instance_id(i) := p_owner_pty_acct_tbl(i).instance_id;

Line 3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl

3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl

Line 3121: l_owner_pty_acct_rec_tab csi_item_instance_pvt.owner_pty_acct_rec_tab;

3117: l_party_hist_rec_tab csi_item_instance_grp.party_history_rec_tab;
3118: l_account_rec_tab csi_item_instance_grp.account_rec_tab;
3119: l_acct_hist_rec_tab csi_item_instance_grp.account_history_rec_tab;
3120: l_txn_rec_tab csi_item_instance_grp.transaction_rec_tab;
3121: l_owner_pty_acct_rec_tab csi_item_instance_pvt.owner_pty_acct_rec_tab;
3122: l_ext_attr_rec_tab csi_item_instance_grp.extend_attrib_values_rec_tab;
3123: l_ext_attr_hist_rec_tab csi_item_instance_grp.ext_attrib_val_hist_rec_tab;
3124: l_asset_rec_tab csi_item_instance_grp.instance_asset_rec_tab;
3125: l_asset_hist_rec_tab csi_item_instance_grp.ins_asset_history_rec_tab;

Line 5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

5837: l_asset_count NUMBER;
5838: l_ext_count NUMBER;
5839: l_iface_id NUMBER;
5840: l_iface_error_text VARCHAR2(2000);
5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5842: l_location_tbl csi_item_instance_pvt.location_tbl;
5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 5842: l_location_tbl csi_item_instance_pvt.location_tbl;

5838: l_ext_count NUMBER;
5839: l_iface_id NUMBER;
5840: l_iface_error_text VARCHAR2(2000);
5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5842: l_location_tbl csi_item_instance_pvt.location_tbl;
5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;

Line 5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

5839: l_iface_id NUMBER;
5840: l_iface_error_text VARCHAR2(2000);
5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5842: l_location_tbl csi_item_instance_pvt.location_tbl;
5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;

Line 5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

5840: l_iface_error_text VARCHAR2(2000);
5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5842: l_location_tbl csi_item_instance_pvt.location_tbl;
5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;

Line 5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

5841: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5842: l_location_tbl csi_item_instance_pvt.location_tbl;
5843: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;

Line 5862: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 5863: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;

5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 5864: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;

5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 5865: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;

5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;

5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;

Line 6298: csi_item_instance_pvt.create_item_instance

6294: p_instance_tbl(inst_tab_row).instance_condition_id := 1;
6295: END IF;
6296:
6297:
6298: csi_item_instance_pvt.create_item_instance
6299: (
6300: p_api_version => p_api_version
6301: ,p_commit => fnd_api.g_false
6302: ,p_init_msg_list => p_init_msg_list

Line 6320: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');

6316: ,p_called_from_grp => fnd_api.g_true
6317: ,p_internal_party_id => l_internal_party_id
6318: );
6319: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6320: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
6321: l_msg_index := 1;
6322: l_msg_count := x_msg_count;
6323: WHILE l_msg_count > 0 LOOP
6324: x_msg_data := FND_MSG_PUB.GET

Line 6809: csi_item_instance_pvt.create_extended_attrib_values

6805: l_iface_error_text := substr(x_msg_data,1,2000);
6806: RAISE SKIP_ERROR;
6807: END IF;
6808: --
6809: csi_item_instance_pvt.create_extended_attrib_values
6810: (
6811: p_api_version => p_api_version
6812: ,p_commit => fnd_api.g_false
6813: ,p_init_msg_list => p_init_msg_list

Line 7426: csi_item_instance_pvt.Call_to_Contracts(

7422: l_owner_party_id <> FND_API.G_MISS_NUM AND
7423: l_owner_party_id <> l_internal_party_id THEN
7424: -- Call API
7425: l_transaction_type:= 'NEW';
7426: csi_item_instance_pvt.Call_to_Contracts(
7427: p_transaction_type => l_transaction_type
7428: ,p_instance_id => p_instance_tbl(inst_row).instance_id
7429: ,p_new_instance_id => NULL
7430: ,p_vld_org_id => p_instance_tbl(inst_row).vld_organization_id

Line 7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

7734: l_internal_party_id NUMBER;
7735: l_party_id NUMBER;
7736: l_active_end_date DATE;
7737: l_dummy VARCHAR2(1);
7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
7739: l_location_tbl csi_item_instance_pvt.location_tbl;
7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 7739: l_location_tbl csi_item_instance_pvt.location_tbl;

7735: l_party_id NUMBER;
7736: l_active_end_date DATE;
7737: l_dummy VARCHAR2(1);
7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
7739: l_location_tbl csi_item_instance_pvt.location_tbl;
7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

Line 7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

7736: l_active_end_date DATE;
7737: l_dummy VARCHAR2(1);
7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
7739: l_location_tbl csi_item_instance_pvt.location_tbl;
7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

Line 7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

7737: l_dummy VARCHAR2(1);
7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
7739: l_location_tbl csi_item_instance_pvt.location_tbl;
7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

Line 7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

7738: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
7739: l_location_tbl csi_item_instance_pvt.location_tbl;
7740: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7741: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
7746: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

Line 7746: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

7742: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 7747: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;

7743: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 7748: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;

7744: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 7749: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;

7745: l_ou_id_tbl csi_organization_unit_pvt.ou_id_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;

Line 8080: IF (csi_Item_Instance_Pvt.Anything_To_Update(p_instance_rec => l_new_instance_rec)) THEN

8076: l_new_instance_rec.instance_status_id := fnd_api.g_miss_num;
8077: END IF;
8078: --
8079: -- If any of the attribute values are different from the DB value then call Update API.
8080: IF (csi_Item_Instance_Pvt.Anything_To_Update(p_instance_rec => l_new_instance_rec)) THEN
8081: l_child_exists := 'N';
8082: IF px_child_inst_tbl.count > 0 THEN
8083: FOR k IN px_child_inst_tbl.FIRST .. px_child_inst_tbl.LAST LOOP
8084: IF l_new_instance_rec.instance_id = px_child_inst_tbl(k) THEN

Line 8099: csi_item_instance_pvt.update_item_instance

8095: where instance_id = l_new_instance_rec.instance_id;
8096: END IF;
8097: -- Call the update_item_instance private API to update the instances
8098: l_iface_error_text := NULL;
8099: csi_item_instance_pvt.update_item_instance
8100: (
8101: p_api_version => p_api_version
8102: ,p_commit => fnd_api.g_false
8103: ,p_init_msg_list => p_init_msg_list

Line 8594: csi_item_instance_pvt.create_extended_attrib_values

8590: IF ((p_ext_attrib_values_tbl(tab_row).attribute_value_id IS NULL)
8591: OR
8592: (p_ext_attrib_values_tbl(tab_row).attribute_value_id = FND_API.G_MISS_NUM))
8593: THEN
8594: csi_item_instance_pvt.create_extended_attrib_values
8595: ( p_api_version => p_api_version
8596: ,p_commit => fnd_api.g_false
8597: ,p_init_msg_list => p_init_msg_list
8598: ,p_validation_level => p_validation_level

Line 8611: csi_item_instance_pvt.update_extended_attrib_values

8607: ,p_ext_cat_tbl => l_ext_cat_tbl
8608: );
8609: ELSE
8610: -- call the update extended attributes api
8611: csi_item_instance_pvt.update_extended_attrib_values
8612: ( p_api_version => p_api_version
8613: ,p_commit => fnd_api.g_false
8614: ,p_init_msg_list => p_init_msg_list
8615: ,p_validation_level => p_validation_level

Line 8624: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');

8620: ,x_msg_data => x_msg_data
8621: );
8622: END IF;
8623: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8624: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');
8625: l_msg_index := 1;
8626: l_msg_count := x_msg_count;
8627: WHILE l_msg_count > 0 LOOP
8628: x_msg_data := FND_MSG_PUB.GET

Line 8744: csi_item_instance_pvt.update_item_instance

8740: l_new_instance_rec.instance_status_id := l_exp_tbl(k).instance_status_id;
8741: --
8742: -- Call the update_item_instance private API to update the instances
8743: l_iface_error_text := NULL;
8744: csi_item_instance_pvt.update_item_instance
8745: (
8746: p_api_version => p_api_version
8747: ,p_commit => fnd_api.g_false
8748: ,p_init_msg_list => p_init_msg_list

Line 8840: csi_item_instance_pvt.create_version_label

8836: l_version_label_rec.version_label := p_instance_tbl(ins_row).version_label;
8837: l_version_label_rec.description := p_instance_tbl(ins_row).version_label_description;
8838: l_version_label_rec.date_time_stamp := SYSDATE;
8839: -- calling create version label api
8840: csi_item_instance_pvt.create_version_label
8841: ( p_api_version => p_api_version
8842: ,p_commit => p_commit
8843: ,p_init_msg_list => p_init_msg_list
8844: ,p_validation_level => p_validation_level

Line 8852: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');

8848: ,x_msg_count => x_msg_count
8849: ,x_msg_data => x_msg_data );
8850:
8851: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8852: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
8853: l_msg_index := 1;
8854: l_msg_count := x_msg_count;
8855: WHILE l_msg_count > 0 LOOP
8856: x_msg_data := FND_MSG_PUB.GET

Line 8905: csi_item_instance_pvt.Call_to_Contracts

8901: p_instance_tbl(ins_row).quantity <> l_old_instance_tbl(ins_row).quantity THEN
8902: IF l_party_id IS NOT NULL AND
8903: l_party_id <> l_internal_party_id THEN
8904: IF p_txn_rec.transaction_type_id <> 7 THEN -- Added for bug 3973706
8905: csi_item_instance_pvt.Call_to_Contracts
8906: ( p_transaction_type => 'UPD'
8907: ,p_instance_id => p_instance_tbl(ins_row).instance_id
8908: ,p_new_instance_id => NULL
8909: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 8956: csi_item_instance_pvt.Call_to_Contracts

8952: nvl(l_old_instance_tbl(ins_row).install_date,fnd_api.g_miss_date) THEN
8953: IF l_party_id IS NOT NULL AND
8954: l_party_id <> l_internal_party_id THEN
8955: IF p_txn_rec.transaction_type_id <> 7 THEN -- Added for bug 3973706
8956: csi_item_instance_pvt.Call_to_Contracts
8957: ( p_transaction_type => 'IDC'
8958: ,p_instance_id => p_instance_tbl(ins_row).instance_id
8959: ,p_new_instance_id => NULL
8960: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 9046: csi_item_instance_pvt.Call_to_Contracts

9042: END IF;
9043: --
9044: IF l_transaction_type IS NOT NULL
9045: THEN
9046: csi_item_instance_pvt.Call_to_Contracts
9047: ( p_transaction_type => l_transaction_type
9048: ,p_instance_id => p_instance_tbl(ins_row).instance_id
9049: ,p_new_instance_id => NULL
9050: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 9323: csi_item_instance_pvt.expire_item_instance

9319: l_grp_error_tbl(ins_row).process_status := 'S';
9320: l_grp_error_tbl(ins_row).error_message := NULL;
9321: l_instance_rec := p_instance_tbl(ins_row);
9322: l_instance_rec.grp_call_contracts := FND_API.G_TRUE;
9323: csi_item_instance_pvt.expire_item_instance
9324: (
9325: p_api_version => p_api_version
9326: ,p_commit => fnd_api.g_false
9327: ,p_init_msg_list => p_init_msg_list

Line 10160: csi_item_instance_pvt.Explode_Bom

10156: IF l_prev_item = -9999 OR
10157: l_prev_item <> p_source_instance_tbl(src_rec).inventory_item_id THEN
10158: l_prev_item := p_source_instance_tbl(src_rec).inventory_item_id;
10159: -- Call Explode BOM
10160: csi_item_instance_pvt.Explode_Bom
10161: (
10162: p_api_version => 1.0
10163: ,p_commit => p_commit
10164: ,p_init_msg_list => p_init_msg_list

Line 10574: csi_item_instance_pvt.lock_item_instances

10570: -- Dump the records in the log file
10571: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
10572: END IF;
10573:
10574: csi_item_instance_pvt.lock_item_instances
10575: (p_api_version => p_api_version
10576: ,p_commit => fnd_api.g_false
10577: ,p_init_msg_list => p_init_msg_list
10578: ,p_validation_level => p_validation_level

Line 10701: csi_item_instance_pvt.unlock_item_instances

10697: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
10698: END IF;
10699:
10700:
10701: csi_item_instance_pvt.unlock_item_instances
10702: (p_api_version => p_api_version
10703: ,p_commit => fnd_api.g_false
10704: ,p_init_msg_list => p_init_msg_list
10705: ,p_validation_level => p_validation_level

Line 10775: l_return_value:= csi_item_instance_pvt.check_item_instance_lock

10771: l_return_value BOOLEAN := TRUE;
10772: l_lock_id NUMBER;
10773: l_lock_status NUMBER :=0;
10774: BEGIN
10775: l_return_value:= csi_item_instance_pvt.check_item_instance_lock
10776: ( p_instance_id => p_instance_id
10777: ,p_config_inst_hdr_id => p_config_inst_hdr_id
10778: ,p_config_inst_item_id => p_config_inst_item_id
10779: ,p_config_inst_rev_num => p_config_inst_rev_num