APPS.PO_FED_FIELD_FUNCTIONS dependencies on FND_LOOKUP_VALUES_VL

Line 2084: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;

2080: d_proc_name CONSTANT varchar2(50) := 'supplier_details_XD';
2081: d_module CONSTANT varchar2(100):= d_pkg_name ||'.'||d_proc_name;
2082: d_progress NUMBER(6);
2083:
2084: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;
2085: l_meanings_table varchar_table;
2086:
2087: l_doing_bsns_as varchar2(100);
2088: l_suplr_size varchar2(100);

Line 2305: FROM fnd_lookup_values_vl flv,

2301: WHERE vendor_id = x_supplier_id;
2302:
2303: SELECT flv.meaning
2304: BULK COLLECT INTO l_meanings_table
2305: FROM fnd_lookup_values_vl flv,
2306: POS_BUS_CLASS_ATTR pca
2307: WHERE flv.enabled_flag='Y'
2308: AND flv.start_date_active < sysdate
2309: AND (flv.end_date_active > sysdate or flv.end_date_active is null)

Line 2653: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;

2649:
2650: d_proc_name CONSTANT varchar2(50) := 'supplier_details_XRD';
2651: d_module CONSTANT varchar2(100):= d_pkg_name ||'.'||d_proc_name;
2652:
2653: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;
2654: l_meanings_table varchar_table;
2655:
2656: l_supplier_id NUMBER(10);
2657: l_supplier_site_id NUMBER(10);

Line 2884: FROM fnd_lookup_values_vl flv,

2880: WHERE vendor_id = l_supplier_id;
2881:
2882: SELECT flv.meaning
2883: BULK COLLECT INTO l_meanings_table
2884: FROM fnd_lookup_values_vl flv,
2885: POS_BUS_CLASS_ATTR pca
2886: WHERE flv.enabled_flag='Y'
2887: AND flv.start_date_active < sysdate
2888: AND (flv.end_date_active > sysdate or flv.end_date_active is null)