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 163: TYPE price_type_lookup_cache IS TABLE OF fnd_lookups_cr INDEX BY BINARY_INTEGER;

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

Line 756: ) RETURN fnd_lookups_cr IS

752: END get_po_distribution;
753:
754: FUNCTION get_price_type_lookup
755: ( p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
756: ) RETURN fnd_lookups_cr IS
757: l_cache_index BINARY_INTEGER;
758: BEGIN
759: g_price_type_lookup_calls := g_price_type_lookup_calls + 1;
760:

Line 782: FROM fnd_lookups

778: SELECT p_price_type
779: , meaning
780: INTO g_price_type_lookup_cache(l_cache_index).lookup_code
781: , g_price_type_lookup_cache(l_cache_index).meaning
782: FROM fnd_lookups
783: WHERE lookup_type = 'PRICE DIFFERENTIALS'
784: AND lookup_code = p_price_type;
785: ELSIF l_cache_index <> g_price_type_lookup_cache.LAST THEN
786: -- maintain LRU