APPS.GMD_API_GRP dependencies on MTL_PARAMETERS

Line 599: FROM fm_form_mst_b a, mtl_parameters b

595: BEGIN
596: IF (Entity = 'FORMULA') THEN
597: SELECT b.organization_code, b.organization_id
598: INTO l_owner_orgn_code, l_orgn_id
599: FROM fm_form_mst_b a, mtl_parameters b
600: WHERE a.formula_id = Entity_id
601: AND a.owner_organization_id = b.organization_id;
602:
603: /* Check if user has access to this formula orgn */

Line 615: FROM gmd_recipes_b a, mtl_parameters b

611:
612: ELSIF (Entity = 'RECIPE') THEN
613: SELECT b.organization_code, b.organization_id
614: INTO l_owner_orgn_code, l_orgn_id
615: FROM gmd_recipes_b a, mtl_parameters b
616: WHERE recipe_id = Entity_id
617: AND a.owner_organization_id = b.organization_id;
618:
619: /* Check if user has access to this Recipe orgn */

Line 631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c

627:
628: ELSIF (Entity = 'VALIDITY') THEN
629: SELECT c.organization_code , a.owner_organization_id
630: INTO l_owner_orgn_code, l_orgn_id
631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c
632: WHERE b.recipe_validity_rule_id = Entity_id
633: AND a.recipe_id = b.recipe_id
634: AND a.owner_organization_id = c.organization_id ;
635:

Line 653: FROM gmd_routings_b a, mtl_parameters b

649:
650: ELSIF (Entity = 'ROUTING') THEN
651: SELECT b.organization_code, b.organization_id
652: INTO l_Owner_orgn_code, l_orgn_id
653: FROM gmd_routings_b a, mtl_parameters b
654: WHERE a.routing_id = Entity_id
655: AND a.owner_organization_id = b.organization_id;
656:
657: /* Check if user has access to this formula orgn */

Line 668: FROM gmd_operations_b a, mtl_parameters b

664: END IF;
665: ELSIF (Entity = 'OPERATION') THEN
666: SELECT b.organization_code, b.organization_id
667: INTO l_Owner_orgn_code, l_orgn_id
668: FROM gmd_operations_b a, mtl_parameters b
669: WHERE a.oprn_id = Entity_id
670: AND a.owner_organization_id = b.organization_id;
671:
672: /* Check if user has access to this formula orgn */

Line 711: from org_access_view a, mtl_parameters b

707: CURSOR Cur_ownerorgn_id IS
708: SELECT 1
709: FROM SYS.DUAL
710: WHERE EXISTS (SELECT 1
711: from org_access_view a, mtl_parameters b
712: where a.organization_id = b.organization_id
713: and b.organization_id = powner_orgn_id
714: and a.responsibility_id = l_responsibility_id --Bug 14000659
715: and b.process_enabled_flag = 'Y');

Line 719: FROM mtl_parameters

715: and b.process_enabled_flag = 'Y');
716:
717: CURSOR Cur_get_orgn (V_organization_id NUMBER) IS
718: SELECT organization_code
719: FROM mtl_parameters
720: WHERE organization_id = V_organization_id;
721:
722: /* Local variables. */
723: /* ================ */

Line 1888: FROM mtl_parameters

1884:
1885: FUNCTION check_orgn_status (V_organization_id IN NUMBER) RETURN BOOLEAN IS
1886: CURSOR Check_orgn_exists IS
1887: SELECT 1
1888: FROM mtl_parameters
1889: WHERE organization_id = V_organization_id
1890: AND process_enabled_flag = 'Y';
1891:
1892: l_temp NUMBER;

Line 1999: FROM mtl_parameters

1995: WHERE inventory_item_id = V_inventory_item_id;
1996:
1997: CURSOR Cur_get_org_id (V_org_code VARCHAR2) IS
1998: SELECT organization_id
1999: FROM mtl_parameters
2000: WHERE organization_code = V_org_code;
2001:
2002: CURSOR Cur_get_org_code (V_org_id NUMBER) IS
2003: SELECT organization_code

Line 2004: FROM mtl_parameters

2000: WHERE organization_code = V_org_code;
2001:
2002: CURSOR Cur_get_org_code (V_org_id NUMBER) IS
2003: SELECT organization_code
2004: FROM mtl_parameters
2005: WHERE organization_id = V_org_id;
2006:
2007: ORGN_MISSING EXCEPTION;
2008: FORMULA_MISSING EXCEPTION;

Line 2600: FROM mtl_parameters

2596: CURSOR Cur_get_master_org IS
2597: SELECT 1
2598: FROM sys.dual
2599: WHERE EXISTS (SELECT 1
2600: FROM mtl_parameters
2601: WHERE master_organization_id = p_organization_id);
2602: BEGIN
2603: /* First lets check if there is a value setup at org parameters level */
2604: GMD_API_GRP.fetch_parm_values(p_orgn_id => p_organization_id