[Home] [Help]
PACKAGE: APPS.QP_QPXPRFOR_XMLP_PKG
Source
1 PACKAGE QP_QPXPRFOR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: QPXPRFORS.pls 120.2 2010/11/03 16:10:24 smuhamme noship $ */
3 P_SOB_ID NUMBER;
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_CUSTOM_PRICE VARCHAR2(2000);
8
9 P_FORMULA_FROM VARCHAR2(240);
10
11 P_START_DATE_ACTIVE DATE;
12
13 P_END_DATE_ACTIVE DATE;
14
15 P_FORMULA_TO VARCHAR2(240);
16
17 P_FROM_PRICE_LIST VARCHAR2(240);
18
19 P_TO_PRICE_LIST VARCHAR2(240);
20
21 RP_REPORT_NAME VARCHAR2(240);
22
23 RP_COMPANY_NAME VARCHAR2(100);
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION CF_FORMULA_TYPEFORMULA(PRICE_FORMULA_LINE_TYPE_CODE IN VARCHAR2) RETURN CHAR;
28
29 FUNCTION CF_COMPONENTFORMULA(PRICE_LIST_LINE_ID IN NUMBER
30 ,PRICE_MODIFIER_LIST_ID IN NUMBER
31 ,PRICE_FORMULA_LINE_TYPE_CODE IN VARCHAR2
32 ,NUMERIC_CONSTANT IN NUMBER) RETURN CHAR;
33
34 FUNCTION CF_OPERANDFORMULA(LIST_LINE_ID IN NUMBER) RETURN NUMBER;
35
36 FUNCTION CF_PRICING_CONTEXTFORMULA(PRICING_ATTRIBUTE_CONTEXT IN VARCHAR2
37 ,PRICING_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
38
39 FUNCTION CF_PRICING_CONTEXT1FORMULA(PRICING_ATTRIBUTE_CONTEXT1 IN VARCHAR2
40 ,PRICING_ATTRIBUTE1 IN VARCHAR2) RETURN CHAR;
41
42 FUNCTION AFTERREPORT RETURN BOOLEAN;
43
44 FUNCTION CF_VALUE_FROMFORMULA(PRICING_ATTR_VALUE_FROM IN VARCHAR2
45 ,COMPARISON_OPERATOR_CODE IN VARCHAR2
46 ,PRICING_ATTRIBUTE_CONTEXT1 IN VARCHAR2
47 ,PRICING_ATTRIBUTE1 IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
50
51 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
52
53 END QP_QPXPRFOR_XMLP_PKG;