APPS.GMD_API_GRP dependencies on FM_FORM_MST

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 771: FROM fm_form_mst_b f,gmd_Status_b s

767: l_status_type GMD_STATUS_B.status_type%TYPE;
768:
769: CURSOR Cur_get_fsttyp(pobject_id NUMBER) IS
770: SELECT s.status_type
771: FROM fm_form_mst_b f,gmd_Status_b s
772: WHERE f.formula_id = pobject_id AND
773: f.formula_status = s.status_code;
774:
775: CURSOR Cur_get_rsttyp(pobject_id NUMBER) IS

Line 850: FROM fm_form_mst

846:
847:
848: CURSOR Cur_get_form_sts(entity_id NUMBER) IS
849: SELECT formula_status
850: FROM fm_form_mst
851: WHERE formula_id = entity_id
852: AND ((formula_status between 700 and 799
853: OR formula_status between 400 and 499));
854:

Line 961: FROM fm_form_mst_b

957: IF (vEntity_id IS NOT NULL) THEN
958: IF (vEntity = 'FORMULA') THEN
959: Select formula_no, formula_vers, formula_no||' - '||formula_vers
960: INTO l_object_name, l_object_version, l_object_name_and_version
961: FROM fm_form_mst_b
962: WHere formula_id = vEntity_id;
963: ELSIF (vEntity = 'ROUTING') THEN
964: Select routing_no, routing_vers, routing_no||' - '||routing_vers
965: INTO l_object_name, l_object_version, l_object_name_and_version

Line 1298: SELECT formula_status FROM fm_form_mst

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
1299: WHERE formula_id = V_entity_id
1300: AND formula_status >= V_entity_status;
1301: CURSOR Cur_get_def_routing_status IS
1302: SELECT routing_status

Line 1308: l_formula_status fm_form_mst.formula_status%TYPE;

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*/
1312: IF (V_entity_type = 'OPERATION') THEN

Line 1454: FROM fm_form_mst_b

1450: FROM FND_DUAL;
1451:
1452: CURSOR c_get_formula IS
1453: SELECT creation_date, formula_status, owner_organization_id
1454: FROM fm_form_mst_b
1455: WHERE formula_id = p_formula_id;
1456: LocalDateRecord c_get_formula%ROWTYPE;
1457:
1458: CURSOR c_get_formula_item IS

Line 1664: FROM fm_form_mst_b

1660: -- Cursors
1661: CURSOR c_get_formula_info IS
1662: SELECT formula_no, formula_vers, formula_desc1,
1663: owner_organization_id, formula_status, owner_id
1664: FROM fm_form_mst_b
1665: WHERE formula_id = p_formula_id;
1666: LocalFormRecord c_get_formula_info%ROWTYPE;
1667:
1668: -- Kapil LCF-GMO ME : Bug#5458666