APPS.GMD_API_GRP dependencies on GMD_OPERATIONS

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 786: FROM gmd_operations_b o,gmd_Status_b s

782: r.recipe_status = s.status_code;
783:
784: CURSOR Cur_get_osttyp(pobject_id NUMBER) IS
785: SELECT s.status_type
786: FROM gmd_operations_b o,gmd_Status_b s
787: WHERE o.oprn_id = pobject_id AND
788: o.operation_status = s.status_code;
789:
790: CURSOR Cur_get_rtsttyp(pobject_id NUMBER) IS

Line 867: FROM gmd_operations

863: OR routing_status between 400 and 499));
864:
865: CURSOR Cur_get_oprn_sts(entity_id NUMBER) IS
866: SELECT operation_status
867: FROM gmd_operations
868: WHERE oprn_id = entity_id
869: AND ((operation_status between 700 and 799
870: OR operation_status between 400 and 499));
871: l_status gmd_status.status_code%TYPE;

Line 974: FROM gmd_operations_b

970: WHere routing_id = vEntity_id;
971: ELSIF (vEntity = 'OPERATION') THEN
972: Select oprn_no, oprn_vers, oprn_no||' - '||oprn_vers
973: INTO l_object_name, l_object_version, l_object_name_and_version
974: FROM gmd_operations_b
975: WHere oprn_id = vEntity_id;
976: ELSIF (vEntity = 'RECIPE') THEN
977: Select recipe_no, recipe_version, recipe_no||' - '||recipe_version
978: INTO l_object_name, l_object_version, l_object_name_and_version

Line 1300: FROM gmd_operations

1296: V_entity_status IN VARCHAR2) RETURN BOOLEAN IS
1297:
1298: CURSOR Cur_get_def_oprn_status IS
1299: SELECT operation_status
1300: FROM gmd_operations
1301: WHERE oprn_id = V_entity_id
1302: AND operation_status >= V_entity_status;
1303: CURSOR Cur_get_def_formula_status IS
1304: SELECT formula_status FROM fm_form_mst

Line 1313: l_operation_status gmd_operations.operation_status%TYPE;

1309: FROM fm_rout_hdr
1310: WHERE routing_id = V_entity_id
1311: AND routing_status >= V_entity_status;
1312: /* do we need this-not used*/
1313: l_operation_status gmd_operations.operation_status%TYPE;
1314: l_formula_status fm_form_mst.formula_status%TYPE;
1315: l_routing_status fm_rout_hdr.routing_status%TYPE;
1316: BEGIN
1317: /*Check all the operations inserted are of status APFLU or APFGU*/