APPS.RCV_HXT_GRP dependencies on PO_PRICE_DIFFERENTIALS

Line 132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%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
133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE
134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE
135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE
136: , price PO_LINES_ALL.unit_price%TYPE

Line 133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE

129: );
130:
131: TYPE price_differentials_cr IS RECORD
132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE
133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE
134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE
135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE
136: , price PO_LINES_ALL.unit_price%TYPE
137: );

Line 134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE

130:
131: TYPE price_differentials_cr IS RECORD
132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE
133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE
134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE
135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE
136: , price PO_LINES_ALL.unit_price%TYPE
137: );
138:

Line 135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE

131: TYPE price_differentials_cr IS RECORD
132: ( entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE
133: , price_type PO_PRICE_DIFFERENTIALS.price_type%TYPE
134: , enabled_flag PO_PRICE_DIFFERENTIALS.enabled_flag%TYPE
135: , multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE
136: , price PO_LINES_ALL.unit_price%TYPE
137: );
138:
139: -- The PO information is new to 11.5.10 so do not introduce

Line 765: ( p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE

761: RAISE DERIVE_DISTRIBUTION_ID_FAILED;
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;

Line 807: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE

803: END get_price_type_lookup;
804:
805: FUNCTION get_price_differentials
806: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
807: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
808: ) RETURN price_differentials_cr IS
809: l_cache_index BINARY_INTEGER;
810: BEGIN
811: g_price_differentials_calls := g_price_differentials_calls + 1;

Line 850: FROM po_price_differentials

846: INTO g_price_differentials_cache(l_cache_index).entity_id
847: , g_price_differentials_cache(l_cache_index).price_type
848: , g_price_differentials_cache(l_cache_index).enabled_flag
849: , g_price_differentials_cache(l_cache_index).multiplier
850: FROM po_price_differentials
851: WHERE entity_type = 'PO LINE'
852: AND entity_id = p_po_line_id
853: AND price_type = p_price_type;
854: