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 708: from org_access_view a, mtl_parameters b

704: CURSOR Cur_ownerorgn_id IS
705: SELECT 1
706: FROM SYS.DUAL
707: WHERE EXISTS (SELECT 1
708: from org_access_view a, mtl_parameters b
709: where a.organization_id = b.organization_id
710: and b.organization_id = powner_orgn_id
711: and a.responsibility_id = l_resp_id
712: and b.process_enabled_flag = 'Y');

Line 716: FROM mtl_parameters

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

Line 1868: FROM mtl_parameters

1864:
1865: FUNCTION check_orgn_status (V_organization_id IN NUMBER) RETURN BOOLEAN IS
1866: CURSOR Check_orgn_exists IS
1867: SELECT 1
1868: FROM mtl_parameters
1869: WHERE organization_id = V_organization_id
1870: AND process_enabled_flag = 'Y';
1871:
1872: l_temp NUMBER;

Line 1979: FROM mtl_parameters

1975: WHERE inventory_item_id = V_inventory_item_id;
1976:
1977: CURSOR Cur_get_org_id (V_org_code VARCHAR2) IS
1978: SELECT organization_id
1979: FROM mtl_parameters
1980: WHERE organization_code = V_org_code;
1981:
1982: CURSOR Cur_get_org_code (V_org_id NUMBER) IS
1983: SELECT organization_code

Line 1984: FROM mtl_parameters

1980: WHERE organization_code = V_org_code;
1981:
1982: CURSOR Cur_get_org_code (V_org_id NUMBER) IS
1983: SELECT organization_code
1984: FROM mtl_parameters
1985: WHERE organization_id = V_org_id;
1986:
1987: ORGN_MISSING EXCEPTION;
1988: FORMULA_MISSING EXCEPTION;

Line 2580: FROM mtl_parameters

2576: CURSOR Cur_get_master_org IS
2577: SELECT 1
2578: FROM sys.dual
2579: WHERE EXISTS (SELECT 1
2580: FROM mtl_parameters
2581: WHERE master_organization_id = p_organization_id);
2582: BEGIN
2583: /* First lets check if there is a value setup at org parameters level */
2584: GMD_API_GRP.fetch_parm_values(p_orgn_id => p_organization_id