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 2372: p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl

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

Line 2373: ,p_owner_pty_acct_rec_tab IN OUT NOCOPY csi_item_instance_pvt.owner_pty_acct_rec_tab

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

Line 3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl

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

Line 3124: l_owner_pty_acct_rec_tab csi_item_instance_pvt.owner_pty_acct_rec_tab;

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

Line 5844: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

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

Line 5845: l_location_tbl csi_item_instance_pvt.location_tbl;

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

Line 5846: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

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

Line 5847: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

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

Line 5848: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

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

Line 5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

5861: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5862: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5863: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5864: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;

5862: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5863: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5864: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;

Line 5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;

5863: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5864: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;

5864: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5866: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
5867: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5868: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5869: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;

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

Line 6560: csi_item_instance_pvt.create_item_instance

6556: RAISE FND_API.G_EXC_ERROR;
6557: END;
6558:
6559: -- End of PRE User Hooks
6560: csi_item_instance_pvt.create_item_instance
6561: (
6562: p_api_version => p_api_version
6563: ,p_commit => fnd_api.g_false
6564: ,p_init_msg_list => p_init_msg_list

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

6578: ,p_called_from_grp => fnd_api.g_true
6579: ,p_internal_party_id => l_internal_party_id
6580: );
6581: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6582: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
6583: l_msg_index := 1;
6584: l_msg_count := x_msg_count;
6585: WHILE l_msg_count > 0 LOOP
6586: x_msg_data := FND_MSG_PUB.GET

Line 7147: csi_item_instance_pvt.create_extended_attrib_values

7143: l_iface_error_text := substr(x_msg_data,1,2000);
7144: RAISE SKIP_ERROR;
7145: END IF;
7146: --
7147: csi_item_instance_pvt.create_extended_attrib_values
7148: (
7149: p_api_version => p_api_version
7150: ,p_commit => fnd_api.g_false
7151: ,p_init_msg_list => p_init_msg_list

Line 7962: csi_item_instance_pvt.Call_to_Contracts(

7958:
7959: IF (p_instance_tbl(inst_row).call_contracts <> fnd_api.g_false AND p_instance_tbl(inst_row).call_contracts <> 'N') --added by HYONLEE on 01/19/10
7960: THEN
7961:
7962: csi_item_instance_pvt.Call_to_Contracts(
7963: p_transaction_type => l_transaction_type
7964: ,p_instance_id => p_instance_tbl(inst_row).instance_id
7965: ,p_new_instance_id => NULL
7966: ,p_vld_org_id => p_instance_tbl(inst_row).vld_organization_id

Line 8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

8271: l_internal_party_id NUMBER;
8272: l_party_id NUMBER;
8273: l_active_end_date DATE;
8274: l_dummy VARCHAR2(1);
8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
8276: l_location_tbl csi_item_instance_pvt.location_tbl;
8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 8276: l_location_tbl csi_item_instance_pvt.location_tbl;

8272: l_party_id NUMBER;
8273: l_active_end_date DATE;
8274: l_dummy VARCHAR2(1);
8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
8276: l_location_tbl csi_item_instance_pvt.location_tbl;
8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

Line 8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

8273: l_active_end_date DATE;
8274: l_dummy VARCHAR2(1);
8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
8276: l_location_tbl csi_item_instance_pvt.location_tbl;
8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

Line 8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

8274: l_dummy VARCHAR2(1);
8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
8276: l_location_tbl csi_item_instance_pvt.location_tbl;
8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

Line 8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

8275: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
8276: l_location_tbl csi_item_instance_pvt.location_tbl;
8277: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
8278: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

Line 8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;

8279: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;

8280: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;

Line 8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;

8281: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;

8282: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
8283: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
8284: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
8285: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
8286: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
8287: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
8288: l_asset_count_rec csi_asset_pvt.asset_count_rec;
8289: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
8290: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

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

8613: l_new_instance_rec.instance_status_id := fnd_api.g_miss_num;
8614: END IF;
8615: --
8616: -- If any of the attribute values are different from the DB value then call Update API.
8617: IF (csi_Item_Instance_Pvt.Anything_To_Update(p_instance_rec => l_new_instance_rec)) THEN
8618: l_child_exists := 'N';
8619: IF px_child_inst_tbl.count > 0 THEN
8620: FOR k IN px_child_inst_tbl.FIRST .. px_child_inst_tbl.LAST LOOP
8621: IF l_new_instance_rec.instance_id = px_child_inst_tbl(k) THEN

Line 8636: csi_item_instance_pvt.update_item_instance

8632: where instance_id = l_new_instance_rec.instance_id;
8633: END IF;
8634: -- Call the update_item_instance private API to update the instances
8635: l_iface_error_text := NULL;
8636: csi_item_instance_pvt.update_item_instance
8637: (
8638: p_api_version => p_api_version
8639: ,p_commit => fnd_api.g_false
8640: ,p_init_msg_list => p_init_msg_list

Line 9140: csi_item_instance_pvt.create_extended_attrib_values

9136: IF ((p_ext_attrib_values_tbl(tab_row).attribute_value_id IS NULL)
9137: OR
9138: (p_ext_attrib_values_tbl(tab_row).attribute_value_id = FND_API.G_MISS_NUM))
9139: THEN
9140: csi_item_instance_pvt.create_extended_attrib_values
9141: ( p_api_version => p_api_version
9142: ,p_commit => fnd_api.g_false
9143: ,p_init_msg_list => p_init_msg_list
9144: ,p_validation_level => p_validation_level

Line 9157: csi_item_instance_pvt.update_extended_attrib_values

9153: ,p_ext_cat_tbl => l_ext_cat_tbl
9154: );
9155: ELSE
9156: -- call the update extended attributes api
9157: csi_item_instance_pvt.update_extended_attrib_values
9158: ( p_api_version => p_api_version
9159: ,p_commit => fnd_api.g_false
9160: ,p_init_msg_list => p_init_msg_list
9161: ,p_validation_level => p_validation_level

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

9166: ,x_msg_data => x_msg_data
9167: );
9168: END IF;
9169: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9170: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');
9171: l_msg_index := 1;
9172: l_msg_count := x_msg_count;
9173: WHILE l_msg_count > 0 LOOP
9174: x_msg_data := FND_MSG_PUB.GET

Line 9290: csi_item_instance_pvt.update_item_instance

9286: l_new_instance_rec.instance_status_id := l_exp_tbl(k).instance_status_id;
9287: --
9288: -- Call the update_item_instance private API to update the instances
9289: l_iface_error_text := NULL;
9290: csi_item_instance_pvt.update_item_instance
9291: (
9292: p_api_version => p_api_version
9293: ,p_commit => fnd_api.g_false
9294: ,p_init_msg_list => p_init_msg_list

Line 9386: csi_item_instance_pvt.create_version_label

9382: l_version_label_rec.version_label := p_instance_tbl(ins_row).version_label;
9383: l_version_label_rec.description := p_instance_tbl(ins_row).version_label_description;
9384: l_version_label_rec.date_time_stamp := SYSDATE;
9385: -- calling create version label api
9386: csi_item_instance_pvt.create_version_label
9387: ( p_api_version => p_api_version
9388: ,p_commit => p_commit
9389: ,p_init_msg_list => p_init_msg_list
9390: ,p_validation_level => p_validation_level

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

9394: ,x_msg_count => x_msg_count
9395: ,x_msg_data => x_msg_data );
9396:
9397: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9398: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
9399: l_msg_index := 1;
9400: l_msg_count := x_msg_count;
9401: WHILE l_msg_count > 0 LOOP
9402: x_msg_data := FND_MSG_PUB.GET

Line 9458: csi_item_instance_pvt.Call_to_Contracts

9454: p_instance_tbl(ins_row).quantity <> l_old_instance_tbl(ins_row).quantity THEN
9455: IF l_party_id IS NOT NULL AND
9456: l_party_id <> l_internal_party_id THEN
9457: IF p_txn_rec.transaction_type_id <> 7 THEN -- Added for bug 3973706
9458: csi_item_instance_pvt.Call_to_Contracts
9459: ( p_transaction_type => 'UPD'
9460: ,p_instance_id => p_instance_tbl(ins_row).instance_id
9461: ,p_new_instance_id => NULL
9462: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 9509: csi_item_instance_pvt.Call_to_Contracts

9505: nvl(l_old_instance_tbl(ins_row).install_date,fnd_api.g_miss_date) THEN
9506: IF l_party_id IS NOT NULL AND
9507: l_party_id <> l_internal_party_id THEN
9508: IF p_txn_rec.transaction_type_id <> 7 THEN -- Added for bug 3973706
9509: csi_item_instance_pvt.Call_to_Contracts
9510: ( p_transaction_type => 'IDC'
9511: ,p_instance_id => p_instance_tbl(ins_row).instance_id
9512: ,p_new_instance_id => NULL
9513: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 9599: csi_item_instance_pvt.Call_to_Contracts

9595: END IF;
9596: --
9597: IF l_transaction_type IS NOT NULL
9598: THEN
9599: csi_item_instance_pvt.Call_to_Contracts
9600: ( p_transaction_type => l_transaction_type
9601: ,p_instance_id => p_instance_tbl(ins_row).instance_id
9602: ,p_new_instance_id => NULL
9603: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 9878: csi_item_instance_pvt.expire_item_instance

9874: l_grp_error_tbl(ins_row).process_status := 'S';
9875: l_grp_error_tbl(ins_row).error_message := NULL;
9876: l_instance_rec := p_instance_tbl(ins_row);
9877: l_instance_rec.grp_call_contracts := FND_API.G_TRUE;
9878: csi_item_instance_pvt.expire_item_instance
9879: (
9880: p_api_version => p_api_version
9881: ,p_commit => fnd_api.g_false
9882: ,p_init_msg_list => p_init_msg_list

Line 10725: csi_item_instance_pvt.Explode_Bom

10721: IF l_prev_item = -9999 OR
10722: l_prev_item <> p_source_instance_tbl(src_rec).inventory_item_id THEN
10723: l_prev_item := p_source_instance_tbl(src_rec).inventory_item_id;
10724: -- Call Explode BOM
10725: csi_item_instance_pvt.Explode_Bom
10726: (
10727: p_api_version => 1.0
10728: ,p_commit => p_commit
10729: ,p_init_msg_list => p_init_msg_list

Line 11149: csi_item_instance_pvt.lock_item_instances

11145: -- Dump the records in the log file
11146: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
11147: END IF;
11148:
11149: csi_item_instance_pvt.lock_item_instances
11150: (p_api_version => p_api_version
11151: ,p_commit => fnd_api.g_false
11152: ,p_init_msg_list => p_init_msg_list
11153: ,p_validation_level => p_validation_level

Line 11276: csi_item_instance_pvt.unlock_item_instances

11272: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
11273: END IF;
11274:
11275:
11276: csi_item_instance_pvt.unlock_item_instances
11277: (p_api_version => p_api_version
11278: ,p_commit => fnd_api.g_false
11279: ,p_init_msg_list => p_init_msg_list
11280: ,p_validation_level => p_validation_level

Line 11350: l_return_value:= csi_item_instance_pvt.check_item_instance_lock

11346: l_return_value BOOLEAN := TRUE;
11347: l_lock_id NUMBER;
11348: l_lock_status NUMBER :=0;
11349: BEGIN
11350: l_return_value:= csi_item_instance_pvt.check_item_instance_lock
11351: ( p_instance_id => p_instance_id
11352: ,p_config_inst_hdr_id => p_config_inst_hdr_id
11353: ,p_config_inst_item_id => p_config_inst_item_id
11354: ,p_config_inst_rev_num => p_config_inst_rev_num