APPS.RCV_HXT_GRP dependencies on FND_LOOKUPS

Line 126: TYPE fnd_lookups_cr IS RECORD

122: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
124: );
125:
126: TYPE fnd_lookups_cr IS RECORD
127: ( lookup_code FND_LOOKUPS.lookup_code%TYPE
128: , meaning FND_LOOKUPS.meaning%TYPE
129: );
130:

Line 127: ( lookup_code FND_LOOKUPS.lookup_code%TYPE

123: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
124: );
125:
126: TYPE fnd_lookups_cr IS RECORD
127: ( lookup_code FND_LOOKUPS.lookup_code%TYPE
128: , meaning FND_LOOKUPS.meaning%TYPE
129: );
130:
131: TYPE price_differentials_cr IS RECORD

Line 128: , meaning FND_LOOKUPS.meaning%TYPE

124: );
125:
126: TYPE fnd_lookups_cr IS RECORD
127: ( lookup_code FND_LOOKUPS.lookup_code%TYPE
128: , meaning FND_LOOKUPS.meaning%TYPE
129: );
130:
131: TYPE price_differentials_cr IS RECORD
132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE

Line 165: TYPE price_type_lookup_cache IS TABLE OF fnd_lookups_cr INDEX BY BINARY_INTEGER;

161: TYPE build_attribute_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.attribute_info INDEX BY BINARY_INTEGER;
162: TYPE po_header_cache IS TABLE OF po_header_cr INDEX BY BINARY_INTEGER;
163: TYPE po_line_cache IS TABLE OF po_line_cr INDEX BY BINARY_INTEGER;
164: TYPE po_distribution_cache IS TABLE OF po_distribution_cr INDEX BY BINARY_INTEGER;
165: TYPE price_type_lookup_cache IS TABLE OF fnd_lookups_cr INDEX BY BINARY_INTEGER;
166: TYPE price_differentials_cache IS TABLE OF price_differentials_cr INDEX BY BINARY_INTEGER;
167: TYPE assignments_cache IS TABLE OF per_all_assignments_cr INDEX BY BINARY_INTEGER;
168: TYPE rcv_transactions_cache IS TABLE OF rcv_transactions_cr INDEX BY BINARY_INTEGER;
169:

Line 766: ) RETURN fnd_lookups_cr IS

762: END get_po_distribution;
763:
764: FUNCTION get_price_type_lookup
765: ( p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
766: ) RETURN fnd_lookups_cr IS
767: l_cache_index BINARY_INTEGER;
768: BEGIN
769: g_price_type_lookup_calls := g_price_type_lookup_calls + 1;
770:

Line 792: FROM fnd_lookups

788: SELECT p_price_type
789: , meaning
790: INTO g_price_type_lookup_cache(l_cache_index).lookup_code
791: , g_price_type_lookup_cache(l_cache_index).meaning
792: FROM fnd_lookups
793: WHERE lookup_type = 'PRICE DIFFERENTIALS'
794: AND lookup_code = p_price_type;
795: ELSIF l_cache_index <> g_price_type_lookup_cache.LAST THEN
796: -- maintain LRU