[Home] [Help]
420: FROM bom_small_expl_temp bet
421: ,bom_bill_of_materials bom
422: ,mtl_system_items msi
423: ,mtl_system_items msip
424: ,mtl_parameters mp
425: WHERE bet.group_id = p_group_id
426: AND bet.plan_level > 0 -- Ignore Top Most
427: AND bet.component_item_id = msi.inventory_item_id
428: AND bet.organization_id = msi.organization_id
2731: -- Maintenance organization
2732: BEGIN
2733: SELECT maint_organization_id
2734: INTO l_maint_organization_id
2735: FROM mtl_parameters
2736: WHERE organization_id = p_instance_header_tbl(tab_row).vld_organization_id;
2737: EXCEPTION
2738: WHEN NO_DATA_FOUND THEN
2739: NULL;
2743: THEN
2744: BEGIN
2745: SELECT organization_code
2746: INTO p_instance_header_tbl(tab_row).maintenance_organization
2747: FROM mtl_parameters
2748: WHERE organization_id = l_maint_organization_id;
2749: EXCEPTION
2750: WHEN NO_DATA_FOUND THEN
2751: NULL;
4706: --
4707:
4708: --Validations for the Create Item Instance
4709: --If vld_organization_id is passed and inv_master_organization_id is
4710: --not passed then derive master_organization_id from mtl_parameters.
4711: -- Start of modifications by sk on 02/19/02 for bug 2198575
4712: IF ((p_instance_rec.vld_organization_id IS NOT NULL) AND
4713: (p_instance_rec.vld_organization_id <> FND_API.G_MISS_NUM)) AND
4714: ((p_instance_rec.inv_master_organization_id IS NULL) OR
4716: THEN
4717: BEGIN
4718: SELECT master_organization_id
4719: INTO p_instance_rec.inv_master_organization_id
4720: FROM mtl_parameters
4721: WHERE organization_id = p_instance_rec.vld_organization_id;
4722: EXCEPTION
4723: WHEN OTHERS THEN
4724: NULL;
4746: THEN
4747: BEGIN
4748: SELECT 'x'
4749: INTO l_temp
4750: FROM mtl_parameters
4751: WHERE organization_id = p_instance_rec.vld_organization_id
4752: AND master_organization_id = p_instance_rec.inv_master_organization_id;
4753: EXCEPTION
4754: WHEN NO_DATA_FOUND THEN
12357: l_curr_instance_rec.inv_master_organization_id)) THEN
12358: BEGIN
12359: SELECT 'x'
12360: INTO l_temp
12361: FROM mtl_parameters
12362: WHERE organization_id = p_instance_rec.vld_organization_id
12363: AND master_organization_id = p_instance_rec.inv_master_organization_id;
12364: EXCEPTION
12365: WHEN NO_DATA_FOUND THEN
14536: IF l_cur_instance_rec.last_vld_organization_id <> l_get_instance_rec.vld_organization_id
14537: THEN
14538: SELECT maint_organization_id
14539: INTO l_curr_maint_org_id
14540: FROM mtl_parameters
14541: WHERE organization_id = l_cur_instance_rec.last_vld_organization_id;
14542:
14543: SELECT maint_organization_id
14544: INTO l_latest_maint_org_id
14541: WHERE organization_id = l_cur_instance_rec.last_vld_organization_id;
14542:
14543: SELECT maint_organization_id
14544: INTO l_latest_maint_org_id
14545: FROM mtl_parameters
14546: WHERE organization_id = l_get_instance_rec.vld_organization_id;
14547: l_ctr:=1;
14548: csi_gen_utility_pvt.put_line('There is a change in vld organization...');
14549: csi_gen_utility_pvt.put_line('Value of current maint org is :'||l_curr_maint_org_id);
29257: FROM bom_small_expl_temp bet
29258: ,bom_bill_of_materials bom
29259: ,mtl_system_items msi
29260: ,mtl_system_items msip
29261: ,mtl_parameters mp
29262: WHERE bet.group_id = p_group_id
29263: AND bet.plan_level > 0 -- Ignore Top Most
29264: AND bet.component_item_id = msi.inventory_item_id
29265: AND bet.organization_id = msi.organization_id
29330: -- Get the Master Organization ID
29331: BEGIN
29332: select master_organization_id
29333: into l_master_organization_id
29334: from MTL_PARAMETERS
29335: where organization_id = p_source_instance_rec.VLD_ORGANIZATION_ID;
29336: EXCEPTION
29337: when others then
29338: csi_gen_utility_pvt.put_line('Unable to get the Master organization ID for '