APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on IGI_LOOKUPS

Line 81: l_report_title igi_lookups.meaning%TYPE := NULL;

77: RETURN(p_supplier_to);
78: END get_p_supplier_to;
79:
80: FUNCTION get_p_report_title RETURN VARCHAR2 IS
81: l_report_title igi_lookups.meaning%TYPE := NULL;
82: BEGIN
83: BEGIN
84: SELECT meaning
85: INTO l_report_title

Line 86: FROM igi_lookups

82: BEGIN
83: BEGIN
84: SELECT meaning
85: INTO l_report_title
86: FROM igi_lookups
87: WHERE lookup_type = 'IGI_CIS2007_NEW_REPORTS'
88: AND lookup_code = p_report;
89: EXCEPTION
90: WHEN no_data_found THEN

Line 117: l_active_meaning igi_lookups.meaning%TYPE := NULL;

113: RETURN(l_org_name);
114: END get_p_org_name;
115:
116: FUNCTION get_p_active RETURN VARCHAR2 IS
117: l_active_meaning igi_lookups.meaning%TYPE := NULL;
118: BEGIN
119: BEGIN
120: SELECT meaning
121: INTO l_active_meaning

Line 122: FROM igi_lookups

118: BEGIN
119: BEGIN
120: SELECT meaning
121: INTO l_active_meaning
122: FROM igi_lookups
123: WHERE lookup_type = 'IGI_CIS2007_ACTIVE_TYPE'
124: AND lookup_code = p_active;
125: EXCEPTION
126: WHEN no_data_found THEN

Line 133: l_sortby_meaning igi_lookups.meaning%TYPE := NULL;

129: RETURN(l_active_meaning);
130: END get_p_active;
131:
132: FUNCTION get_p_sortby RETURN VARCHAR2 IS
133: l_sortby_meaning igi_lookups.meaning%TYPE := NULL;
134: l_lookup_type igi_lookups.lookup_type%TYPE := NULL;
135: BEGIN
136: BEGIN
137: IF (p_report = 'IGIPVERR') THEN

Line 134: l_lookup_type igi_lookups.lookup_type%TYPE := NULL;

130: END get_p_active;
131:
132: FUNCTION get_p_sortby RETURN VARCHAR2 IS
133: l_sortby_meaning igi_lookups.meaning%TYPE := NULL;
134: l_lookup_type igi_lookups.lookup_type%TYPE := NULL;
135: BEGIN
136: BEGIN
137: IF (p_report = 'IGIPVERR') THEN
138: l_lookup_type := 'IGI_CIS2007_VERR_SORT_COLS';

Line 145: FROM igi_lookups

141: END IF;
142:
143: SELECT meaning
144: INTO l_sortby_meaning
145: FROM igi_lookups
146: WHERE lookup_type = l_lookup_type
147: AND lookup_code = p_sort_by;
148: EXCEPTION
149: WHEN no_data_found THEN