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

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

Line 864: FROM gmd_operations

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

Line 971: FROM gmd_operations_b

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

Line 1294: FROM gmd_operations

1290: V_entity_status IN VARCHAR2) RETURN BOOLEAN IS
1291:
1292: CURSOR Cur_get_def_oprn_status IS
1293: SELECT operation_status
1294: FROM gmd_operations
1295: WHERE oprn_id = V_entity_id
1296: AND operation_status >= V_entity_status;
1297: CURSOR Cur_get_def_formula_status IS
1298: SELECT formula_status FROM fm_form_mst

Line 1307: l_operation_status gmd_operations.operation_status%TYPE;

1303: FROM fm_rout_hdr
1304: WHERE routing_id = V_entity_id
1305: AND routing_status >= V_entity_status;
1306: /* do we need this-not used*/
1307: l_operation_status gmd_operations.operation_status%TYPE;
1308: l_formula_status fm_form_mst.formula_status%TYPE;
1309: l_routing_status fm_rout_hdr.routing_status%TYPE;
1310: BEGIN
1311: /*Check all the operations inserted are of status APFLU or APFGU*/