eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_API_GRP dependencies on GMD_STATUS

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 871: l_status gmd_status.status_code%TYPE;

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;
872: l_parent_check BOOLEAN := FALSE;
873: BEGIN
874: IF (V_entity_id IS NULL) THEN
875: RETURN;

Line 892: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

888: gmd_debug.put_line('In GMD_API_GRP.validate_with_dep_entities - '||
889: 'About to check for Recipe - Vr dep status = '||l_status);
890: END IF;
891: IF (Cur_get_recp_sts%FOUND) THEN
892: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
893: IF (l_debug = 'Y') THEN
894: gmd_debug.put_line('In GMD_API_GRP.validate_with_dep_entities - '||
895: ' There is VR dependency for this Recipe = '||v_entity_Id);
896: END IF;

Line 907: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

903: ELSIF(v_type = 'ROUTING') THEN
904: OPEN Cur_get_rout_sts(v_entity_id);
905: FETCH Cur_get_rout_sts INTO l_status;
906: IF (Cur_get_rout_sts%FOUND) THEN
907: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
908: l_parent_check := TRUE;
909: FND_MESSAGE.SET_NAME('GMD','GMD_ROUTING_RECIPE_DEP');
910: END IF;
911: END IF;

Line 917: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

913: ELSIF(V_type = 'FORMULA') THEN
914: OPEN Cur_get_form_sts(v_entity_id);
915: FETCH Cur_get_form_sts INTO l_status;
916: IF (Cur_get_form_sts%FOUND) THEN
917: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
918: l_parent_check := TRUE;
919: FND_MESSAGE.SET_NAME('GMD','GMD_FORMULA_RECIPE_DEP');
920: END IF;
921: END IF;

Line 927: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

923: ELSIF(v_type = 'OPERATION') THEN
924: OPEN Cur_get_oprn_sts(v_entity_id);
925: FETCH Cur_get_oprn_sts INTO l_status;
926: IF (Cur_get_oprn_sts%FOUND) THEN
927: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
928: l_parent_check := TRUE;
929: FND_MESSAGE.SET_NAME('GMD','GMD_OPERATION_ROUT_DEP');
930: END IF;
931: END IF;

Line 1195: FROM gmd_status

1191: -------------------------------------------------------------------
1192: FUNCTION get_status_desc (V_entity_status IN VARCHAR2 ) RETURN VARCHAR2 IS
1193: CURSOR Cur_get_status_desc IS
1194: SELECT description
1195: FROM gmd_status
1196: WHERE status_code = V_entity_status;
1197: X_description VARCHAR2(240);
1198: BEGIN
1199: IF (V_entity_status IS NOT NULL) THEN

Line 1232: ,gmd_status st

1228: ,st.description
1229: ,st.status_type
1230: FROM gmd_parameters_hdr h
1231: ,gmd_parameters_dtl d
1232: ,gmd_status st
1233: WHERE (h.organization_id = cp_orgn_id OR h.organization_id IS NULL)
1234: AND h.parameter_id = d.parameter_id
1235: AND d.parameter_name = cp_parameter_name
1236: AND st.status_code = parameter_value

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