[Home] [Help]
797: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
798: AND (p_instance_rec.config_inst_rev_num IS NOT NULL AND p_instance_rec.config_inst_rev_num <> fnd_api.g_miss_num)
799: THEN
800:
801: IF NOT csi_item_instance_vld_pvt.is_unique_config_key ( p_config_inst_hdr_id => p_instance_rec.config_inst_hdr_id
802: ,p_config_inst_item_id => p_instance_rec.config_inst_item_id
803: ,p_instance_id => p_instance_rec.instance_id
804: ,p_validation_mode => 'CREATE'
805: )
831: END;
832:
833: IF l_component_ins_type='I'
834: THEN
835: Csi_item_instance_vld_pvt.Call_batch_validate
836: ( p_instance_rec => p_instance_rec
837: ,p_config_hdr_id => l_config_hdr_id
838: ,p_config_rev_nbr => l_config_rev_nbr
839: ,x_config_hdr_id => l_batch_hdr_id
2756: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
2757: AND (p_instance_rec.config_inst_rev_num IS NOT NULL AND p_instance_rec.config_inst_rev_num <> fnd_api.g_miss_num)
2758: THEN
2759:
2760: IF NOT csi_item_instance_vld_pvt.is_unique_config_key ( p_config_inst_hdr_id => p_instance_rec.config_inst_hdr_id
2761: ,p_config_inst_item_id => p_instance_rec.config_inst_item_id
2762: ,p_instance_id => p_instance_rec.instance_id
2763: ,p_validation_mode => 'UPDATE'
2764: )
2792:
2793: IF l_component_ins_type='I'
2794: THEN
2795:
2796: Csi_item_instance_vld_pvt.Call_batch_validate
2797: ( p_instance_rec => p_instance_rec
2798: ,p_config_hdr_id => l_config_hdr_id
2799: ,p_config_rev_nbr => l_config_rev_nbr
2800: ,x_config_hdr_id => l_batch_hdr_id
3120: if ((l_party_id is not null and
3121: l_party_id <> l_internal_party_id) or
3122: (l_instance_csr.instance_usage_code = 'IN_RELATIONSHIP' OR l_old_ins_csr.instance_usage_code = 'IN_RELATIONSHIP')) THEN --modified for bug 13057871
3123: IF l_old_ins_csr.instance_status_id <> l_instance_csr.instance_status_id THEN
3124: IF csi_item_instance_vld_pvt.termination_status
3125: ( p_instance_status_id => l_instance_csr.instance_status_id )
3126: THEN
3127: IF p_txn_rec.transaction_type_id in (53,54) THEN -- RMA
3128: l_transaction_type := 'RET';
3793: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
3794: AND (p_instance_rec.config_inst_rev_num IS NOT NULL AND p_instance_rec.config_inst_rev_num <> fnd_api.g_miss_num)
3795: THEN
3796:
3797: IF NOT csi_item_instance_vld_pvt.is_unique_config_key ( p_config_inst_hdr_id => p_instance_rec.config_inst_hdr_id
3798: ,p_config_inst_item_id => p_instance_rec.config_inst_item_id
3799: ,p_instance_id => p_instance_rec.instance_id
3800: ,p_validation_mode => 'UPDATE'
3801: )
3829:
3830: IF l_component_ins_type='I'
3831: THEN
3832:
3833: Csi_item_instance_vld_pvt.Call_batch_validate
3834: ( p_instance_rec => p_instance_rec
3835: ,p_config_hdr_id => l_config_hdr_id
3836: ,p_config_rev_nbr => l_config_rev_nbr
3837: ,x_config_hdr_id => l_batch_hdr_id
4337: csi_item_instance_pvt.resolve_id_columns
4338: (p_instance_header_tbl => x_instance_header_tbl);
4339:
4340: -- Added by sguthiva for att enhancements
4341: csi_Item_Instance_Vld_pvt.get_link_locations
4342: (p_instance_header_tbl => x_instance_header_tbl,
4343: x_return_status => x_return_status
4344: );
4345: IF NOT x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4614: END IF;
4615: END IF;
4616: --
4617: -- srramakr Bug 4558115
4618: p_instance_rec.version_label := csi_item_instance_vld_pvt.Get_Version_Label
4619: ( p_instance_id => p_instance_rec.instance_id,
4620: p_time_stamp => p_time_stamp
4621: );
4622: --Resolve the id columns, get the corresponding descriptions for the passed ids