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 755: ( p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE

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

Line 797: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE

793: END get_price_type_lookup;
794:
795: FUNCTION get_price_differentials
796: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
797: , p_price_type IN PO_PRICE_DIFFERENTIALS.price_type%TYPE
798: ) RETURN price_differentials_cr IS
799: l_cache_index BINARY_INTEGER;
800: BEGIN
801: g_price_differentials_calls := g_price_differentials_calls + 1;

Line 841: FROM po_price_differentials

837: INTO g_price_differentials_cache(l_cache_index).entity_id
838: , g_price_differentials_cache(l_cache_index).price_type
839: , g_price_differentials_cache(l_cache_index).enabled_flag
840: , g_price_differentials_cache(l_cache_index).multiplier
841: FROM po_price_differentials
842: WHERE entity_type = 'PO LINE'
843: AND entity_id = p_po_line_id
844: AND price_type = p_price_type;
845: