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.PER_RI_CONFIG_TECH_SUMMARY dependencies on FND_LOOKUPS

Line 1452: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';

1448:
1449: select meaning into l_required from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
1450: l_display := l_required;
1451: l_enabled := l_required;
1452: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';
1453:
1454:
1455: l_kf_seg_clob := get_clob_locator('JobKeyFlexSegment');
1456: dbms_lob.createtemporary(l_kf_seg_clob,TRUE);

Line 1469: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_seg_tab(i).vs_enable_longlist;

1465: if p_kf_job_seg_tab(i).vs_security_available is not null then
1466: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_seg_tab(i).vs_security_available;
1467: end if;
1468: if p_kf_job_seg_tab(i).vs_enable_longlist is not null then
1469: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_seg_tab(i).vs_enable_longlist;
1470: end if;
1471: if p_kf_job_seg_tab(i).vs_format_type is not null then
1472: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_seg_tab(i).vs_format_type;
1473: end if;

Line 1472: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_seg_tab(i).vs_format_type;

1468: if p_kf_job_seg_tab(i).vs_enable_longlist is not null then
1469: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_seg_tab(i).vs_enable_longlist;
1470: end if;
1471: if p_kf_job_seg_tab(i).vs_format_type is not null then
1472: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_seg_tab(i).vs_format_type;
1473: end if;
1474:
1475: l_temp_sql:= ' SELECT ' ||
1476: '''' || p_kf_job_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1517: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_rv_seg_tab(i).vs_enable_longlist;

1513: if p_kf_job_rv_seg_tab(i).vs_security_available is not null then
1514: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_rv_seg_tab(i).vs_security_available;
1515: end if;
1516: if p_kf_job_rv_seg_tab(i).vs_enable_longlist is not null then
1517: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_rv_seg_tab(i).vs_enable_longlist;
1518: end if;
1519: if p_kf_job_rv_seg_tab(i).vs_format_type is not null then
1520: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_rv_seg_tab(i).vs_format_type;
1521: end if;

Line 1520: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_rv_seg_tab(i).vs_format_type;

1516: if p_kf_job_rv_seg_tab(i).vs_enable_longlist is not null then
1517: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_rv_seg_tab(i).vs_enable_longlist;
1518: end if;
1519: if p_kf_job_rv_seg_tab(i).vs_format_type is not null then
1520: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_rv_seg_tab(i).vs_format_type;
1521: end if;
1522:
1523: l_temp_sql:= ' SELECT ' ||
1524: '''' || p_kf_job_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1564: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_enable_longlist;

1560: if p_kf_job_no_rv_seg_tab(i).vs_security_available is not null then
1561: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_security_available;
1562: end if;
1563: if p_kf_job_no_rv_seg_tab(i).vs_enable_longlist is not null then
1564: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_enable_longlist;
1565: end if;
1566: if p_kf_job_no_rv_seg_tab(i).vs_format_type is not null then
1567: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_format_type;
1568: end if;

Line 1567: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_format_type;

1563: if p_kf_job_no_rv_seg_tab(i).vs_enable_longlist is not null then
1564: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_enable_longlist;
1565: end if;
1566: if p_kf_job_no_rv_seg_tab(i).vs_format_type is not null then
1567: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_format_type;
1568: end if;
1569:
1570: l_temp_sql:= ' SELECT ' ||
1571: '''' || p_kf_job_no_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1628: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_seg_tab(i).vs_enable_longlist;

1624: if p_kf_pos_seg_tab(i).vs_security_available is not null then
1625: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_seg_tab(i).vs_security_available;
1626: end if;
1627: if p_kf_pos_seg_tab(i).vs_enable_longlist is not null then
1628: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_seg_tab(i).vs_enable_longlist;
1629: end if;
1630: if p_kf_pos_seg_tab(i).vs_format_type is not null then
1631: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_seg_tab(i).vs_format_type;
1632: end if;

Line 1631: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_seg_tab(i).vs_format_type;

1627: if p_kf_pos_seg_tab(i).vs_enable_longlist is not null then
1628: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_seg_tab(i).vs_enable_longlist;
1629: end if;
1630: if p_kf_pos_seg_tab(i).vs_format_type is not null then
1631: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_seg_tab(i).vs_format_type;
1632: end if;
1633:
1634: l_temp_sql:= ' SELECT ' ||
1635: '''' || p_kf_pos_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1675: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_enable_longlist;

1671: if p_kf_pos_rv_seg_tab(i).vs_security_available is not null then
1672: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_security_available;
1673: end if;
1674: if p_kf_pos_rv_seg_tab(i).vs_enable_longlist is not null then
1675: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_enable_longlist;
1676: end if;
1677: if p_kf_pos_rv_seg_tab(i).vs_format_type is not null then
1678: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_format_type;
1679: end if;

Line 1678: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_format_type;

1674: if p_kf_pos_rv_seg_tab(i).vs_enable_longlist is not null then
1675: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_enable_longlist;
1676: end if;
1677: if p_kf_pos_rv_seg_tab(i).vs_format_type is not null then
1678: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_format_type;
1679: end if;
1680:
1681: l_temp_sql:= ' SELECT ' ||
1682: '''' || p_kf_pos_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1722: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist;

1718: if p_kf_pos_no_rv_seg_tab(i).vs_security_available is not null then
1719: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_security_available;
1720: end if;
1721: if p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist is not null then
1722: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist;
1723: end if;
1724: if p_kf_pos_no_rv_seg_tab(i).vs_format_type is not null then
1725: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_format_type;
1726: end if;

Line 1725: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_format_type;

1721: if p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist is not null then
1722: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist;
1723: end if;
1724: if p_kf_pos_no_rv_seg_tab(i).vs_format_type is not null then
1725: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_format_type;
1726: end if;
1727:
1728: l_temp_sql:= ' SELECT ' ||
1729: '''' || p_kf_pos_no_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1787: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_seg_tab(i).vs_enable_longlist;

1783: if p_kf_grd_seg_tab(i).vs_security_available is not null then
1784: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_seg_tab(i).vs_security_available;
1785: end if;
1786: if p_kf_grd_seg_tab(i).vs_enable_longlist is not null then
1787: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_seg_tab(i).vs_enable_longlist;
1788: end if;
1789: if p_kf_grd_seg_tab(i).vs_format_type is not null then
1790: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_seg_tab(i).vs_format_type;
1791: end if;

Line 1790: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_seg_tab(i).vs_format_type;

1786: if p_kf_grd_seg_tab(i).vs_enable_longlist is not null then
1787: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_seg_tab(i).vs_enable_longlist;
1788: end if;
1789: if p_kf_grd_seg_tab(i).vs_format_type is not null then
1790: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_seg_tab(i).vs_format_type;
1791: end if;
1792:
1793: l_temp_sql:= ' SELECT ' ||
1794: '''' || p_kf_grd_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1834: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_enable_longlist;

1830: if p_kf_grd_rv_seg_tab(i).vs_security_available is not null then
1831: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_security_available;
1832: end if;
1833: if p_kf_grd_rv_seg_tab(i).vs_enable_longlist is not null then
1834: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_enable_longlist;
1835: end if;
1836: if p_kf_grd_rv_seg_tab(i).vs_format_type is not null then
1837: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_format_type;
1838: end if;

Line 1837: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_format_type;

1833: if p_kf_grd_rv_seg_tab(i).vs_enable_longlist is not null then
1834: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_enable_longlist;
1835: end if;
1836: if p_kf_grd_rv_seg_tab(i).vs_format_type is not null then
1837: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_format_type;
1838: end if;
1839:
1840: l_temp_sql:= ' SELECT ' ||
1841: '''' || p_kf_grd_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1882: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist;

1878: if p_kf_grd_no_rv_seg_tab(i).vs_security_available is not null then
1879: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_security_available;
1880: end if;
1881: if p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist is not null then
1882: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist;
1883: end if;
1884: if p_kf_grd_no_rv_seg_tab(i).vs_format_type is not null then
1885: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_format_type;
1886: end if;

Line 1885: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_format_type;

1881: if p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist is not null then
1882: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist;
1883: end if;
1884: if p_kf_grd_no_rv_seg_tab(i).vs_format_type is not null then
1885: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_format_type;
1886: end if;
1887:
1888: l_temp_sql:= ' SELECT ' ||
1889: '''' || p_kf_grd_no_rv_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 1949: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grp_seg_tab(i).vs_enable_longlist;

1945: if p_kf_grp_seg_tab(i).vs_security_available is not null then
1946: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grp_seg_tab(i).vs_security_available;
1947: end if;
1948: if p_kf_grp_seg_tab(i).vs_enable_longlist is not null then
1949: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grp_seg_tab(i).vs_enable_longlist;
1950: end if;
1951: if p_kf_grp_seg_tab(i).vs_format_type is not null then
1952: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grp_seg_tab(i).vs_format_type;
1953: end if;

Line 1952: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grp_seg_tab(i).vs_format_type;

1948: if p_kf_grp_seg_tab(i).vs_enable_longlist is not null then
1949: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grp_seg_tab(i).vs_enable_longlist;
1950: end if;
1951: if p_kf_grp_seg_tab(i).vs_format_type is not null then
1952: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_grp_seg_tab(i).vs_format_type;
1953: end if;
1954:
1955: l_temp_sql:= ' SELECT ' ||
1956: '''' || p_kf_grp_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 2014: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cmp_seg_tab(i).vs_enable_longlist;

2010: if p_kf_cmp_seg_tab(i).vs_security_available is not null then
2011: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cmp_seg_tab(i).vs_security_available;
2012: end if;
2013: if p_kf_cmp_seg_tab(i).vs_enable_longlist is not null then
2014: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cmp_seg_tab(i).vs_enable_longlist;
2015: end if;
2016: if p_kf_cmp_seg_tab(i).vs_format_type is not null then
2017: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cmp_seg_tab(i).vs_format_type;
2018: end if;

Line 2017: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cmp_seg_tab(i).vs_format_type;

2013: if p_kf_cmp_seg_tab(i).vs_enable_longlist is not null then
2014: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cmp_seg_tab(i).vs_enable_longlist;
2015: end if;
2016: if p_kf_cmp_seg_tab(i).vs_format_type is not null then
2017: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cmp_seg_tab(i).vs_format_type;
2018: end if;
2019:
2020: l_temp_sql:= ' SELECT ' ||
2021: '''' || p_kf_cmp_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 2079: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cost_seg_tab(i).vs_enable_longlist;

2075: if p_kf_cost_seg_tab(i).vs_security_available is not null then
2076: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cost_seg_tab(i).vs_security_available;
2077: end if;
2078: if p_kf_cost_seg_tab(i).vs_enable_longlist is not null then
2079: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cost_seg_tab(i).vs_enable_longlist;
2080: end if;
2081: if p_kf_cost_seg_tab(i).vs_format_type is not null then
2082: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cost_seg_tab(i).vs_format_type;
2083: end if;

Line 2082: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cost_seg_tab(i).vs_format_type;

2078: if p_kf_cost_seg_tab(i).vs_enable_longlist is not null then
2079: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cost_seg_tab(i).vs_enable_longlist;
2080: end if;
2081: if p_kf_cost_seg_tab(i).vs_format_type is not null then
2082: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_cost_seg_tab(i).vs_format_type;
2083: end if;
2084:
2085: l_temp_sql:= ' SELECT ' ||
2086: '''' || p_kf_cost_seg_tab(i).appl_short_name ||''''||' appl_short_name,' ||

Line 2792: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';

2788: BEGIN
2789: hr_utility.set_location('Entering ' ||l_proc,10);
2790:
2791: select meaning into l_allow_dynamic from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
2792: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';
2793: l_enabled := l_allow_dynamic;
2794: l_required := l_allow_dynamic;
2795: l_display := l_allow_dynamic;
2796: l_freeze_flex_def := l_allow_dynamic;

Line 2874: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_segment_tab(i).vs_enable_longlist;

2870: if p_kf_segment_tab(i).vs_security_available is not null then
2871: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_segment_tab(i).vs_security_available;
2872: end if;
2873: if p_kf_segment_tab(i).vs_enable_longlist is not null then
2874: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_segment_tab(i).vs_enable_longlist;
2875: end if;
2876: if p_kf_segment_tab(i).vs_format_type is not null then
2877: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_segment_tab(i).vs_format_type;
2878: end if;

Line 2877: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_segment_tab(i).vs_format_type;

2873: if p_kf_segment_tab(i).vs_enable_longlist is not null then
2874: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_segment_tab(i).vs_enable_longlist;
2875: end if;
2876: if p_kf_segment_tab(i).vs_format_type is not null then
2877: select meaning into l_vs_format_type from fnd_lookups where lookup_type = 'FIELD_TYPE' and lookup_code = p_kf_segment_tab(i).vs_format_type;
2878: end if;
2879: exception
2880: when no_data_found then
2881: null;