APPS.AMS_STATUS_PVT dependencies on AMS_LOOKUPS

Line 72: CURSOR c_ams_lookups IS

68: RETURN VARCHAR2 IS
69:
70: l_meaning VARCHAR2(80);
71:
72: CURSOR c_ams_lookups IS
73: SELECT meaning
74: FROM ams_lookups
75: WHERE lookup_type = p_lookup_type
76: AND lookup_code = p_lookup_code;

Line 74: FROM ams_lookups

70: l_meaning VARCHAR2(80);
71:
72: CURSOR c_ams_lookups IS
73: SELECT meaning
74: FROM ams_lookups
75: WHERE lookup_type = p_lookup_type
76: AND lookup_code = p_lookup_code;
77:
78: BEGIN

Line 80: OPEN c_ams_lookups;

76: AND lookup_code = p_lookup_code;
77:
78: BEGIN
79:
80: OPEN c_ams_lookups;
81: FETCH c_ams_lookups INTO l_meaning;
82: CLOSE c_ams_lookups;
83:
84: RETURN l_meaning;

Line 81: FETCH c_ams_lookups INTO l_meaning;

77:
78: BEGIN
79:
80: OPEN c_ams_lookups;
81: FETCH c_ams_lookups INTO l_meaning;
82: CLOSE c_ams_lookups;
83:
84: RETURN l_meaning;
85:

Line 82: CLOSE c_ams_lookups;

78: BEGIN
79:
80: OPEN c_ams_lookups;
81: FETCH c_ams_lookups INTO l_meaning;
82: CLOSE c_ams_lookups;
83:
84: RETURN l_meaning;
85:
86: END;

Line 312: l_lookup_type ams_lookups.lookup_type%type;

308:
309: l_index binary_integer;
310: l_total binary_integer;
311:
312: l_lookup_type ams_lookups.lookup_type%type;
313: l_api_name constant VARCHAR2(30) := 'validate_status_change';
314:
315: BEGIN
316: