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_COMMON_VAL dependencies on GMD_STATUS

Line 428: Status_code IN GMD_STATUS.Status_code%TYPE ,

424: /* Return S if status code is found */
425: /* ========================================================= */
426: PROCEDURE Get_Status
427: (
428: Status_code IN GMD_STATUS.Status_code%TYPE ,
429: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
430: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
431: x_return_status OUT NOCOPY VARCHAR2
432: ) IS

Line 429: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,

425: /* ========================================================= */
426: PROCEDURE Get_Status
427: (
428: Status_code IN GMD_STATUS.Status_code%TYPE ,
429: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
430: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
431: x_return_status OUT NOCOPY VARCHAR2
432: ) IS
433: CURSOR Status_Cur(vStatus_code VARCHAR2) IS

Line 430: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,

426: PROCEDURE Get_Status
427: (
428: Status_code IN GMD_STATUS.Status_code%TYPE ,
429: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
430: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
431: x_return_status OUT NOCOPY VARCHAR2
432: ) IS
433: CURSOR Status_Cur(vStatus_code VARCHAR2) IS
434: SELECT Distinct status_code, Meaning, Description

Line 435: FROM GMD_STATUS

431: x_return_status OUT NOCOPY VARCHAR2
432: ) IS
433: CURSOR Status_Cur(vStatus_code VARCHAR2) IS
434: SELECT Distinct status_code, Meaning, Description
435: FROM GMD_STATUS
436: Where status_code = vStatus_code;
437:
438: l_status_code GMD_STATUS.Status_code%TYPE;
439: l_meaning GMD_STATUS.meaning%TYPE;

Line 438: l_status_code GMD_STATUS.Status_code%TYPE;

434: SELECT Distinct status_code, Meaning, Description
435: FROM GMD_STATUS
436: Where status_code = vStatus_code;
437:
438: l_status_code GMD_STATUS.Status_code%TYPE;
439: l_meaning GMD_STATUS.meaning%TYPE;
440: l_description GMD_STATUS.description%TYPE;
441:
442: BEGIN

Line 439: l_meaning GMD_STATUS.meaning%TYPE;

435: FROM GMD_STATUS
436: Where status_code = vStatus_code;
437:
438: l_status_code GMD_STATUS.Status_code%TYPE;
439: l_meaning GMD_STATUS.meaning%TYPE;
440: l_description GMD_STATUS.description%TYPE;
441:
442: BEGIN
443:

Line 440: l_description GMD_STATUS.description%TYPE;

436: Where status_code = vStatus_code;
437:
438: l_status_code GMD_STATUS.Status_code%TYPE;
439: l_meaning GMD_STATUS.meaning%TYPE;
440: l_description GMD_STATUS.description%TYPE;
441:
442: BEGIN
443:
444: OPEN Status_cur(Status_code);

Line 1757: l_meaning GMD_STATUS.Meaning%TYPE ;

1753: FUNCTION UPDATE_ALLOWED(Entity VARCHAR2
1754: ,Entity_id NUMBER
1755: ,Update_Column_Name VARCHAR2 Default Null)
1756: RETURN BOOLEAN IS
1757: l_meaning GMD_STATUS.Meaning%TYPE ;
1758: l_desc GMD_STATUS.Description%TYPE ;
1759: l_return_status VARCHAR2(1);
1760: l_bool BOOLEAN := TRUE;
1761: l_status_code GMD_STATUS.Status_Code%TYPE;

Line 1758: l_desc GMD_STATUS.Description%TYPE ;

1754: ,Entity_id NUMBER
1755: ,Update_Column_Name VARCHAR2 Default Null)
1756: RETURN BOOLEAN IS
1757: l_meaning GMD_STATUS.Meaning%TYPE ;
1758: l_desc GMD_STATUS.Description%TYPE ;
1759: l_return_status VARCHAR2(1);
1760: l_bool BOOLEAN := TRUE;
1761: l_status_code GMD_STATUS.Status_Code%TYPE;
1762: l_delete_mark NUMBER := 0;

Line 1761: l_status_code GMD_STATUS.Status_Code%TYPE;

1757: l_meaning GMD_STATUS.Meaning%TYPE ;
1758: l_desc GMD_STATUS.Description%TYPE ;
1759: l_return_status VARCHAR2(1);
1760: l_bool BOOLEAN := TRUE;
1761: l_status_code GMD_STATUS.Status_Code%TYPE;
1762: l_delete_mark NUMBER := 0;
1763:
1764: l_resp_id NUMBER(15) DEFAULT FND_PROFILE.VALUE('RESP_ID');
1765: l_owner_orgn_id GMD_RECIPES_B.owner_organization_id%TYPE;

Line 1896: From fm_form_mst f, gmd_status s

1892: FETCH get_formula_owner_orgn_id INTO l_orgn_id;
1893: CLOSE get_formula_owner_orgn_id;
1894: OPEN Status_cur FOR
1895: Select f.formula_status, s.version_enabled
1896: From fm_form_mst f, gmd_status s
1897: Where f.formula_id = Entity_id
1898: And f.formula_status = s.status_code;
1899: FETCH Status_cur INTO l_status, l_version_enabled;
1900: ClOSE Status_cur;

Line 1921: From gmd_recipes r, gmd_status s

1917: FETCH get_recipe_owner_orgn_id INTO l_orgn_id;
1918: CLOSE get_recipe_owner_orgn_id;
1919: OPEN Status_cur FOR
1920: Select r.recipe_status, s.version_enabled
1921: From gmd_recipes r, gmd_status s
1922: Where r.recipe_id = Entity_id
1923: And r.recipe_status = s.status_code;
1924: FETCH Status_cur INTO l_status, l_version_enabled;
1925: ClOSE Status_cur;

Line 1946: From fm_rout_hdr r, gmd_status s

1942: FETCH get_routing_owner_orgn_id INTO l_orgn_id;
1943: CLOSE get_routing_owner_orgn_id;
1944: OPEN Status_cur FOR
1945: Select r.routing_status, s.version_enabled
1946: From fm_rout_hdr r, gmd_status s
1947: Where r.routing_id = Entity_id
1948: And r.routing_status = s.status_code;
1949: FETCH Status_cur INTO l_status, l_version_enabled;
1950: ClOSE Status_cur;

Line 1971: From gmd_operations r, gmd_status s

1967: FETCH get_operation_owner_orgn_id INTO l_orgn_id;
1968: CLOSE get_operation_owner_orgn_id;
1969: OPEN Status_cur FOR
1970: Select r.operation_status, s.version_enabled
1971: From gmd_operations r, gmd_status s
1972: Where r.oprn_id = Entity_id
1973: And r.operation_status = s.status_code;
1974: FETCH Status_cur INTO l_status, l_version_enabled;
1975: ClOSE Status_cur;

Line 2000: From gmd_item_substitution_hdr_b r, gmd_status s

1996: CLOSE get_substitution_owner_orgn_id;
1997:
1998: OPEN Status_cur FOR
1999: Select r.substitution_status, s.version_enabled
2000: From gmd_item_substitution_hdr_b r, gmd_status s
2001: Where r.substitution_id = Entity_id
2002: And r.substitution_status = s.status_code;
2003: FETCH Status_cur INTO l_status, l_version_enabled;
2004: ClOSE Status_cur;