APPS.FND_CONC_SSWA dependencies on FND_LOOKUP_VALUES

Line 402: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;

398: meaning varchar2(80)
399: );
400: temp_record temp_record_type;
401: rec_count number;
402: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
403: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
404: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
405: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
406: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');

Line 403: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;

399: );
400: temp_record temp_record_type;
401: rec_count number;
402: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
403: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
404: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
405: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
406: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');
407: -- weekdays weekday_array := weekday_array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');

Line 404: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;

400: temp_record temp_record_type;
401: rec_count number;
402: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
403: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
404: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
405: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
406: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');
407: -- weekdays weekday_array := weekday_array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');
408:

Line 420: FROM fnd_lookup_values_vl

416: -- get values for weeks array from lookup FND_SCH_WEEKDAY_TYPE
417: rec_count := 1;
418: ltype := 'FND_SCH_WEEKDAY_TYPE';
419: FOR temp_record IN (SELECT meaning
420: FROM fnd_lookup_values_vl
421: WHERE lookup_type = ltype
422: ORDER BY to_number(lookup_code)) LOOP
423: weeks(rec_count) := temp_record.meaning;
424: rec_count := rec_count + 1;

Line 431: FROM fnd_lookup_values_vl

427: -- get values for weekdays array from lookup FND_SCH_WEEK_DAYS
428: rec_count := 1;
429: ltype := 'FND_SCH_WEEK_DAYS';
430: FOR temp_record IN (SELECT meaning
431: FROM fnd_lookup_values_vl
432: WHERE lookup_type = ltype
433: ORDER BY to_number(lookup_code)) LOOP
434: weekdays(rec_count) := temp_record.meaning;
435: rec_count := rec_count + 1;

Line 442: FROM fnd_lookup_values_vl

438: -- get values for months array from lookup FND_SCH_MONTHS
439: rec_count := 1;
440: ltype := 'FND_SCH_MONTHS';
441: FOR temp_record IN (SELECT meaning
442: FROM fnd_lookup_values_vl
443: WHERE lookup_type = ltype
444: ORDER BY to_number(lookup_code)) LOOP
445: months(rec_count) := temp_record.meaning;
446: rec_count := rec_count + 1;