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 1706: l_meaning GMD_STATUS.Meaning%TYPE ;

1702: FUNCTION UPDATE_ALLOWED(Entity VARCHAR2
1703: ,Entity_id NUMBER
1704: ,Update_Column_Name VARCHAR2 Default Null)
1705: RETURN BOOLEAN IS
1706: l_meaning GMD_STATUS.Meaning%TYPE ;
1707: l_desc GMD_STATUS.Description%TYPE ;
1708: l_return_status VARCHAR2(1);
1709: l_bool BOOLEAN := TRUE;
1710: l_status_code GMD_STATUS.Status_Code%TYPE;

Line 1707: l_desc GMD_STATUS.Description%TYPE ;

1703: ,Entity_id NUMBER
1704: ,Update_Column_Name VARCHAR2 Default Null)
1705: RETURN BOOLEAN IS
1706: l_meaning GMD_STATUS.Meaning%TYPE ;
1707: l_desc GMD_STATUS.Description%TYPE ;
1708: l_return_status VARCHAR2(1);
1709: l_bool BOOLEAN := TRUE;
1710: l_status_code GMD_STATUS.Status_Code%TYPE;
1711: l_delete_mark NUMBER := 0;

Line 1710: l_status_code GMD_STATUS.Status_Code%TYPE;

1706: l_meaning GMD_STATUS.Meaning%TYPE ;
1707: l_desc GMD_STATUS.Description%TYPE ;
1708: l_return_status VARCHAR2(1);
1709: l_bool BOOLEAN := TRUE;
1710: l_status_code GMD_STATUS.Status_Code%TYPE;
1711: l_delete_mark NUMBER := 0;
1712:
1713: l_resp_id NUMBER(15) DEFAULT FND_PROFILE.VALUE('RESP_ID');
1714: l_owner_orgn_id GMD_RECIPES_B.owner_organization_id%TYPE;

Line 1838: From fm_form_mst f, gmd_status s

1834: FETCH get_formula_owner_orgn_id INTO l_orgn_id;
1835: CLOSE get_formula_owner_orgn_id;
1836: OPEN Status_cur FOR
1837: Select f.formula_status, s.version_enabled
1838: From fm_form_mst f, gmd_status s
1839: Where f.formula_id = Entity_id
1840: And f.formula_status = s.status_code;
1841: FETCH Status_cur INTO l_status, l_version_enabled;
1842: ClOSE Status_cur;

Line 1863: From gmd_recipes r, gmd_status s

1859: FETCH get_recipe_owner_orgn_id INTO l_orgn_id;
1860: CLOSE get_recipe_owner_orgn_id;
1861: OPEN Status_cur FOR
1862: Select r.recipe_status, s.version_enabled
1863: From gmd_recipes r, gmd_status s
1864: Where r.recipe_id = Entity_id
1865: And r.recipe_status = s.status_code;
1866: FETCH Status_cur INTO l_status, l_version_enabled;
1867: ClOSE Status_cur;

Line 1888: From fm_rout_hdr r, gmd_status s

1884: FETCH get_routing_owner_orgn_id INTO l_orgn_id;
1885: CLOSE get_routing_owner_orgn_id;
1886: OPEN Status_cur FOR
1887: Select r.routing_status, s.version_enabled
1888: From fm_rout_hdr r, gmd_status s
1889: Where r.routing_id = Entity_id
1890: And r.routing_status = s.status_code;
1891: FETCH Status_cur INTO l_status, l_version_enabled;
1892: ClOSE Status_cur;

Line 1913: From gmd_operations r, gmd_status s

1909: FETCH get_operation_owner_orgn_id INTO l_orgn_id;
1910: CLOSE get_operation_owner_orgn_id;
1911: OPEN Status_cur FOR
1912: Select r.operation_status, s.version_enabled
1913: From gmd_operations r, gmd_status s
1914: Where r.oprn_id = Entity_id
1915: And r.operation_status = s.status_code;
1916: FETCH Status_cur INTO l_status, l_version_enabled;
1917: ClOSE Status_cur;

Line 1942: From gmd_item_substitution_hdr_b r, gmd_status s

1938: CLOSE get_substitution_owner_orgn_id;
1939:
1940: OPEN Status_cur FOR
1941: Select r.substitution_status, s.version_enabled
1942: From gmd_item_substitution_hdr_b r, gmd_status s
1943: Where r.substitution_id = Entity_id
1944: And r.substitution_status = s.status_code;
1945: FETCH Status_cur INTO l_status, l_version_enabled;
1946: ClOSE Status_cur;