APPS.GMD_API_GRP dependencies on GMD_STATUS_B

Line 766: RETURN GMD_STATUS_B.status_type%TYPE IS

762: * *********************************************************************** */
763: FUNCTION get_object_status_type
764: ( pObject_Name VARCHAR2
765: , pObject_Id NUMBER)
766: RETURN GMD_STATUS_B.status_type%TYPE IS
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

Line 767: l_status_type GMD_STATUS_B.status_type%TYPE;

763: FUNCTION get_object_status_type
764: ( pObject_Name VARCHAR2
765: , pObject_Id NUMBER)
766: RETURN GMD_STATUS_B.status_type%TYPE IS
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

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 777: FROM gmd_recipes_b r,gmd_Status_b s

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

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

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

Line 795: FROM gmd_recipe_validity_rules v,gmd_Status_b s

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

Line 1236: FROM gmd_status b

1232:
1233:
1234: CURSOR Cur_get_def_new_status IS
1235: SELECT b.status_code, b.description,b.status_type
1236: FROM gmd_status b
1237: WHERE b.status_code = 100;
1238:
1239: BEGIN
1240: IF (V_entity_type = 'ROUTING') THEN