APPS.AHL_MC_ITEMGROUP_PVT dependencies on MTL_PARAMETERS

Line 337: CURSOR mtl_parameters_csr(p_inventory_org_id IN NUMBER) IS

333: FROM ahl_mtl_items_non_ou_v
334: WHERE inventory_item_id = p_inventory_item_id
335: AND inventory_org_id = p_inventory_org_id;
336:
337: CURSOR mtl_parameters_csr(p_inventory_org_id IN NUMBER) IS
338: SELECT organization_code,
339: master_organization_id
340: FROM mtl_parameters
341: WHERE organization_id = p_inventory_org_id;

Line 340: FROM mtl_parameters

336:
337: CURSOR mtl_parameters_csr(p_inventory_org_id IN NUMBER) IS
338: SELECT organization_code,
339: master_organization_id
340: FROM mtl_parameters
341: WHERE organization_id = p_inventory_org_id;
342:
343: l_instance_track VARCHAR2(1);
344: l_segment1 ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

Line 347: l_organization_code mtl_parameters.organization_code%TYPE;

343: l_instance_track VARCHAR2(1);
344: l_segment1 ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
345: l_serial_number_control NUMBER;
346: l_revision_qty_control_code NUMBER;
347: l_organization_code mtl_parameters.organization_code%TYPE;
348:
349: BEGIN
350:
351: IF (p_inventory_item_id IS NULL)

Line 363: OPEN mtl_parameters_csr(p_inventory_org_id);

359: RETURN;
360: END IF;
361:
362: -- For organization code
363: OPEN mtl_parameters_csr(p_inventory_org_id);
364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;
365: IF (mtl_parameters_csr%NOTFOUND) THEN
366: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);

Line 364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;

360: END IF;
361:
362: -- For organization code
363: OPEN mtl_parameters_csr(p_inventory_org_id);
364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;
365: IF (mtl_parameters_csr%NOTFOUND) THEN
366: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
368: FND_MSG_PUB.ADD;

Line 365: IF (mtl_parameters_csr%NOTFOUND) THEN

361:
362: -- For organization code
363: OPEN mtl_parameters_csr(p_inventory_org_id);
364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;
365: IF (mtl_parameters_csr%NOTFOUND) THEN
366: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
368: FND_MSG_PUB.ADD;
369: --dbms_output.put_line('Organization does not exist');

Line 371: CLOSE mtl_parameters_csr;

367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
368: FND_MSG_PUB.ADD;
369: --dbms_output.put_line('Organization does not exist');
370: END IF;
371: CLOSE mtl_parameters_csr;
372:
373:
374: OPEN mtl_system_items_csr(p_inventory_item_id,p_inventory_org_id);
375: FETCH mtl_system_items_csr INTO l_instance_track, l_segment1, l_serial_number_control,

Line 525: from mtl_parameters

521: SELECT REVISION
522: FROM AHL_ITEM_ASSOCIATIONS_VL
523: WHERE item_group_id = p_item_group_id
524: AND inventory_org_id = ( Select master_organization_id
525: from mtl_parameters
526: where organization_id = p_inventory_org_id)
527: AND inventory_item_id = p_inventory_item_id;
528:
529: -- This cursor checks if a record of the same Item with Null revision as the one passed from the UI, exists..

Line 540: from mtl_parameters

536: WHERE item_group_id = p_item_group_id
537: --AND (REVISION IS NULL OR REVISION = p_item_revision)
538: AND (REVISION IS NULL)
539: AND inventory_org_id = ( Select master_organization_id
540: from mtl_parameters
541: where organization_id = p_inventory_org_id)
542: AND inventory_item_id = p_inventory_item_id;
543:
544:

Line 555: from mtl_parameters

551: FROM AHL_ITEM_ASSOCIATIONS_VL
552: WHERE item_group_id = p_item_group_id
553: AND (REVISION = p_item_revision)
554: AND inventory_org_id = (Select master_organization_id
555: from mtl_parameters
556: where organization_id = p_inventory_org_id)
557: AND inventory_item_id = p_inventory_item_id;
558:
559: l_junk VARCHAR2(30);

Line 622: from mtl_parameters

618: AHL_ITEM_ASSOCIATIONS_VL
619: WHERE
620: item_group_id = p_item_group_id
621: AND inventory_org_id = (Select master_organization_id
622: from mtl_parameters
623: where organization_id = p_inventory_org_id)
624: AND inventory_item_id = p_inventory_item_id;
625:
626: EXCEPTION

Line 675: from mtl_parameters

671: FROM AHL_ITEM_ASSOCIATIONS_VL
672: WHERE item_group_id = p_item_group_id
673: AND NVL(REVISION,'000') = p_item_revision
674: AND inventory_org_id = ( Select master_organization_id
675: from mtl_parameters
676: where organization_id = p_inventory_org_id)
677: AND inventory_item_id = p_inventory_item_id;
678: BEGIN
679: -- Bug Number 4069855