APPS.GMD_API_GRP dependencies on GMD_STATUS_B

Line 769: RETURN GMD_STATUS_B.status_type%TYPE IS

765: * *********************************************************************** */
766: FUNCTION get_object_status_type
767: ( pObject_Name VARCHAR2
768: , pObject_Id NUMBER)
769: RETURN GMD_STATUS_B.status_type%TYPE IS
770: l_status_type GMD_STATUS_B.status_type%TYPE;
771:
772: CURSOR Cur_get_fsttyp(pobject_id NUMBER) IS
773: SELECT s.status_type

Line 770: l_status_type GMD_STATUS_B.status_type%TYPE;

766: FUNCTION get_object_status_type
767: ( pObject_Name VARCHAR2
768: , pObject_Id NUMBER)
769: RETURN GMD_STATUS_B.status_type%TYPE IS
770: l_status_type GMD_STATUS_B.status_type%TYPE;
771:
772: CURSOR Cur_get_fsttyp(pobject_id NUMBER) IS
773: SELECT s.status_type
774: FROM fm_form_mst_b f,gmd_Status_b s

Line 774: FROM fm_form_mst_b f,gmd_Status_b s

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

Line 780: FROM gmd_recipes_b r,gmd_Status_b s

776: f.formula_status = s.status_code;
777:
778: CURSOR Cur_get_rsttyp(pobject_id NUMBER) IS
779: SELECT s.status_type
780: FROM gmd_recipes_b r,gmd_Status_b s
781: WHERE r.recipe_id = pobject_id AND
782: r.recipe_status = s.status_code;
783:
784: CURSOR Cur_get_osttyp(pobject_id NUMBER) IS

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 792: FROM gmd_routings_b r,gmd_Status_b s

788: o.operation_status = s.status_code;
789:
790: CURSOR Cur_get_rtsttyp(pobject_id NUMBER) IS
791: SELECT s.status_type
792: FROM gmd_routings_b r,gmd_Status_b s
793: WHERE r.routing_id = pobject_id AND
794: r.routing_status = s.status_code;
795:
796: CURSOR Cur_get_vrttyp(pobject_id NUMBER) IS

Line 798: FROM gmd_recipe_validity_rules v,gmd_Status_b s

794: r.routing_status = s.status_code;
795:
796: CURSOR Cur_get_vrttyp(pobject_id NUMBER) IS
797: SELECT s.status_type
798: FROM gmd_recipe_validity_rules v,gmd_Status_b s
799: WHERE v.recipe_validity_rule_id = pobject_id AND
800: v.validity_rule_status = s.status_code;
801: BEGIN
802: IF (pObject_id IS NOT NULL) THEN

Line 1242: FROM gmd_status b

1238:
1239:
1240: CURSOR Cur_get_def_new_status IS
1241: SELECT b.status_code, b.description,b.status_type
1242: FROM gmd_status b
1243: WHERE b.status_code = 100;
1244:
1245: BEGIN
1246: IF (V_entity_type = 'ROUTING') THEN