APPS.IGI_CIS_IGIPMTHP_PKG dependencies on IGI_LOOKUPS

Line 235: l_print_type igi_lookups.meaning%TYPE := null;

231:
232:
233: FUNCTION get_print_type RETURN VARCHAR2 IS
234: l_procedure_name VARCHAR2(100):='.get_print_type';
235: l_print_type igi_lookups.meaning%TYPE := null;
236: BEGIN
237: l_procedure_name := g_path_name || l_procedure_name;
238: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
239: SELECT meaning

Line 241: FROM igi_lookups

237: l_procedure_name := g_path_name || l_procedure_name;
238: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
239: SELECT meaning
240: INTO l_print_type
241: FROM igi_lookups
242: WHERE lookup_type = 'IGI_CIS2007_PRINT_TYPES'
243: AND lookup_code = p_print_type;
244:
245: log(C_STATE_LEVEL, l_procedure_name, 'END');

Line 283: l_sort_by igi_lookups.meaning%TYPE := NULL ;

279: END get_org_name;
280:
281: FUNCTION get_p_sort_by RETURN VARCHAR2 IS
282: l_procedure_name VARCHAR2(100):='.get_p_sort_by';
283: l_sort_by igi_lookups.meaning%TYPE := NULL ;
284: BEGIN
285: l_procedure_name := g_path_name || l_procedure_name;
286: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
287:

Line 290: FROM igi_lookups

286: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
287:
288: SELECT meaning
289: INTO l_sort_by
290: FROM igi_lookups
291: WHERE lookup_type='IGI_CIS2007_MTHR_SORT_COLS'
292: AND lookup_code=p_sort_by;
293:
294: log(C_STATE_LEVEL, l_procedure_name, 'END');

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

301:
302:
303: FUNCTION get_p_report_title RETURN VARCHAR2 IS
304: l_procedure_name VARCHAR2(100):='.get_p_report_title';
305: l_report_title igi_lookups.meaning%TYPE := NULL;
306: BEGIN
307: l_procedure_name := g_path_name || l_procedure_name;
308: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
309: SELECT meaning

Line 311: FROM igi_lookups

307: l_procedure_name := g_path_name || l_procedure_name;
308: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
309: SELECT meaning
310: INTO l_report_title
311: FROM igi_lookups
312: WHERE lookup_type = 'IGI_CIS2007_NEW_REPORTS'
313: AND lookup_code = decode(p_mode||p_report_lev,'PS','IGIPMTPS',
314: 'PD','IGIPMTPD',
315: 'FD','IGIPMTRD',

Line 340: FROM igi_lookups

336: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
337:
338: SELECT meaning
339: INTO l_tax_status
340: FROM igi_lookups
341: WHERE lookup_type = 'IGI_CIS2007_TAX_STATUS'
342: AND lookup_code = decode(nvl(p_awt_group_code,' '),l_gross_group,'G',
343: l_net_group,'N',
344: l_unmatch_group,'U');

Line 363: l_amt_type igi_lookups.meaning%TYPE := NULL;

359:
360: --Function Added for ER6137652
361: FUNCTION get_p_amt_type RETURN VARCHAR2 IS
362: l_procedure_name VARCHAR2(100):='.get_p_amt_type';
363: l_amt_type igi_lookups.meaning%TYPE := NULL;
364: BEGIN
365: l_procedure_name := g_path_name || l_procedure_name;
366: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
367: SELECT meaning

Line 369: FROM igi_lookups

365: l_procedure_name := g_path_name || l_procedure_name;
366: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
367: SELECT meaning
368: INTO l_amt_type
369: FROM igi_lookups
370: WHERE lookup_type = 'IGI_CIS2007_MTH_RET_AMT_TYPE'
371: AND lookup_code = nvl(p_amt_type,'P');
372: log(C_STATE_LEVEL, l_procedure_name, 'END');
373: RETURN(l_amt_type);