1 PACKAGE OE_RMA_QUERY_PRICE AUTHID CURRENT_USER as
2 /* $Header: oexrlqps.pls 115.0 99/07/16 08:29:26 porting ship $ */
3
4 FUNCTION GET_PRICE_ADJUSTMENTS_TOTAL(
5 P_HEADER_ID IN NUMBER,
6 P_LINE_ID IN NUMBER,
7 P_REF_ORD_HEADER_ID IN NUMBER DEFAULT NULL
8 )
9 RETURN NUMBER;
10
11 PROCEDURE GET_PRICE_INFO (
12 P_LINE_ID IN NUMBER,
13 P_PRICE_LIST_ID OUT NUMBER,
14 P_TERMS_ID OUT NUMBER,
15 P_ROUNDING_FACTOR OUT NUMBER
16 );
17
18 PROCEDURE GET_PRICING(
19 L_PRICING_CONTEXT OUT VARCHAR2,
20 L_PRICING_ATTRIBUTE1 OUT VARCHAR2,
21 L_PRICING_ATTRIBUTE2 OUT VARCHAR2,
22 L_PRICING_ATTRIBUTE3 OUT VARCHAR2,
23 L_PRICING_ATTRIBUTE4 OUT VARCHAR2,
24 L_PRICING_ATTRIBUTE5 OUT VARCHAR2,
25 L_PRICING_ATTRIBUTE6 OUT VARCHAR2,
26 L_PRICING_ATTRIBUTE7 OUT VARCHAR2,
27 L_PRICING_ATTRIBUTE8 OUT VARCHAR2,
28 L_PRICING_ATTRIBUTE9 OUT VARCHAR2,
29 L_PRICING_ATTRIBUTE10 OUT VARCHAR2,
30 L_PRICING_ATTRIBUTE11 OUT VARCHAR2,
31 L_PRICING_ATTRIBUTE12 OUT VARCHAR2,
32 L_PRICING_ATTRIBUTE13 OUT VARCHAR2,
33 L_PRICING_ATTRIBUTE14 OUT VARCHAR2,
34 L_PRICING_ATTRIBUTE15 OUT VARCHAR2,
35 L_LINK_TO_LINE_ID IN NUMBER
36 );
37
38 END OE_RMA_QUERY_PRICE;