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

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

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

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

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

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

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

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

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

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

Line 1189: FROM gmd_status

1185: -------------------------------------------------------------------
1186: FUNCTION get_status_desc (V_entity_status IN VARCHAR2 ) RETURN VARCHAR2 IS
1187: CURSOR Cur_get_status_desc IS
1188: SELECT description
1189: FROM gmd_status
1190: WHERE status_code = V_entity_status;
1191: X_description VARCHAR2(240);
1192: BEGIN
1193: IF (V_entity_status IS NOT NULL) THEN

Line 1226: ,gmd_status st

1222: ,st.description
1223: ,st.status_type
1224: FROM gmd_parameters_hdr h
1225: ,gmd_parameters_dtl d
1226: ,gmd_status st
1227: WHERE (h.organization_id = cp_orgn_id OR h.organization_id IS NULL)
1228: AND h.parameter_id = d.parameter_id
1229: AND d.parameter_name = cp_parameter_name
1230: AND st.status_code = parameter_value

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