DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_LOOKUP_VALUES

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

459: meaning varchar2(80)
460: );
461: temp_record temp_record_type;
462: rec_count number;
463: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
464: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
465: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
466: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
467: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');

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

460: );
461: temp_record temp_record_type;
462: rec_count number;
463: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
464: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
465: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
466: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
467: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');
468: -- weekdays weekday_array := weekday_array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');

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

461: temp_record temp_record_type;
462: rec_count number;
463: TYPE month_array IS varray(12) OF fnd_lookup_values.meaning%TYPE;
464: TYPE week_array IS varray(6) OF fnd_lookup_values.meaning%TYPE;
465: TYPE weekday_array IS varray(7) OF fnd_lookup_values.meaning%TYPE;
466: -- months month_array := month_array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
467: -- weeks week_array := week_array('First ', 'Second ', 'Third ', 'Fourth ', 'Last ');
468: -- weekdays weekday_array := weekday_array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');
469:

Line 481: FROM fnd_lookup_values_vl

477: -- get values for weeks array from lookup FND_SCH_WEEKDAY_TYPE
478: rec_count := 1;
479: ltype := 'FND_SCH_WEEKDAY_TYPE';
480: FOR temp_record IN (SELECT meaning
481: FROM fnd_lookup_values_vl
482: WHERE lookup_type = ltype
483: ORDER BY to_number(lookup_code)) LOOP
484: weeks(rec_count) := temp_record.meaning;
485: rec_count := rec_count + 1;

Line 492: FROM fnd_lookup_values_vl

488: -- get values for weekdays array from lookup FND_SCH_WEEK_DAYS
489: rec_count := 1;
490: ltype := 'FND_SCH_WEEK_DAYS';
491: FOR temp_record IN (SELECT meaning
492: FROM fnd_lookup_values_vl
493: WHERE lookup_type = ltype
494: ORDER BY to_number(lookup_code)) LOOP
495: weekdays(rec_count) := temp_record.meaning;
496: rec_count := rec_count + 1;

Line 503: FROM fnd_lookup_values_vl

499: -- get values for months array from lookup FND_SCH_MONTHS
500: rec_count := 1;
501: ltype := 'FND_SCH_MONTHS';
502: FOR temp_record IN (SELECT meaning
503: FROM fnd_lookup_values_vl
504: WHERE lookup_type = ltype
505: ORDER BY to_number(lookup_code)) LOOP
506: months(rec_count) := temp_record.meaning;
507: rec_count := rec_count + 1;