[Home] [Help]
PACKAGE: APPS.QP_QPXPRCST_XMLP_PKG
Source
1 PACKAGE QP_QPXPRCST_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: QPXPRCSTS.pls 120.2 2010/11/03 16:04:16 smuhamme noship $ */
3 P_SOB_ID NUMBER;
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_FROM_PRICE_LIST VARCHAR2(240);
8
9 P_TO_PRICE_LIST VARCHAR2(240);
10
11 P_START_DATE_ACTIVE DATE;
12
13 P_END_DATE_ACTIVE DATE;
14
15 P_ACTIVE_FLAG VARCHAR2(5);
16
17 P_QUALIFIER_CONTEXT VARCHAR2(30);
18
19 P_QUALIFIER_ATTRIBUTE_FROM VARCHAR2(240);
20
21 P_QUALIFIER_ATTRIBUTE_TO VARCHAR2(30);
22
23 P_PRODUCT_CONTEXT VARCHAR2(30);
24
25 P_PRODUCT_ATTRIBUTE VARCHAR2(30);
26
27 P_PRODUCT_ATTRIBUTE_VALUE VARCHAR2(240);
28
29 P_ORGANIZATION NUMBER;
30
31 P_PRICE_LIST_NAME VARCHAR2(1000) := ' AND 1=1';
32
33 P_PRICE_LIST_ACTIVE_DATE VARCHAR2(500) := ' AND 1=1';
34
35 P_PRICE_LIST_ACTIVE_FLAG VARCHAR2(250) := ' AND 1=1';
36
37 P_TO_CURRENCY_CODE VARCHAR2(32767);
38
39 P_TO_CURRENCY VARCHAR2(500) := ' WHERE 1=1';
40
41 P_ITEM_ORGANIZATION NUMBER;
42
43 P_USER_NAME VARCHAR2(240);
44
45 P_RESP_ID NUMBER;
46
47 RP_REPORT_NAME VARCHAR2(240);
48
49 RP_COMPANY_NAME VARCHAR2(100);
50
51 FUNCTION CF_FREIGHT_TERMSFORMULA(FREIGHT_TERMS_CODE IN VARCHAR2) RETURN CHAR;
52
53 FUNCTION CF_PAYMENT_TERMSFORMULA(TERMS_ID IN NUMBER) RETURN CHAR;
54
55 FUNCTION BEFOREREPORT RETURN BOOLEAN;
56
57 FUNCTION CF_PRICE_CONTEXTFORMULA(PRICING_ATTRIBUTE_CONTEXT IN VARCHAR2
58 ,PRICING_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
59
60 FUNCTION CF_PRICE_CONTEXT1FORMULA(PRICING_ATTRIBUTE_CONTEXT1 IN VARCHAR2
61 ,PRICING_ATTRIBUTE1 IN VARCHAR2) RETURN CHAR;
62
63 FUNCTION AFTERPFORM RETURN BOOLEAN;
64
65 FUNCTION CF_QUALIFIER_ATTR_VALUEFORMULA(QUALIFIER_CONTEXT IN VARCHAR2
66 ,QUALIFIER_ATTRIBUTE IN VARCHAR2
67 ,QUALIFIER_ATTR_VALUE IN VARCHAR2
68 ,COMPARISION_OPERATOR_CODE IN VARCHAR2) RETURN CHAR;
69
70 FUNCTION GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME IN VARCHAR2
71 ,P_CONTEXT_NAME IN VARCHAR2
72 ,P_SEGMENT_NAME IN VARCHAR2
73 ,P_ATTR_VALUE IN VARCHAR2
74 ,P_COMPARISON_OPERATOR_CODE IN VARCHAR2 := NULL) RETURN VARCHAR2;
75
76 FUNCTION GET_NUM_DATE_FROM_CANONICAL(P_DATATYPE IN VARCHAR2
77 ,P_VALUE IN VARCHAR2) RETURN VARCHAR2;
78
79 PROCEDURE GET_VALUESET_ID(P_FLEXFIELD_NAME IN VARCHAR2
80 ,P_CONTEXT IN VARCHAR2
81 ,P_SEG IN VARCHAR2
82 ,X_VSID OUT NOCOPY NUMBER
83 ,X_FORMAT_TYPE OUT NOCOPY VARCHAR2
84 ,X_VALIDATION_TYPE OUT NOCOPY VARCHAR2);
85
86 FUNCTION CF_QUALIFIER_CONTEXTFORMULA(QUALIFIER_CONTEXT IN VARCHAR2
87 ,QUALIFIER_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
88
89 FUNCTION CF_PRODUCT_ATTRIBUTEFORMULA(PRODUCT_ATTRIBUTE_CONTEXT1 IN VARCHAR2
90 ,PRODUCT_ATTRIBUTE1 IN VARCHAR2) RETURN VARCHAR2;
91
92 FUNCTION CF_BASE_MARKUP_FORMULAFORMULA(BASE_MARKUP_FORMULA_ID IN NUMBER) RETURN CHAR;
93
94 FUNCTION CF_PRICE_FORMULAFORMULA(PRICE_FORMULA_ID IN NUMBER) RETURN CHAR;
95
96 FUNCTION CF_MARKUP_FORMULAFORMULA(MARKUP_FORMULA_ID IN NUMBER) RETURN CHAR;
97
98 FUNCTION CF_ATTRIBUTE_CONTEXTFORMULA(CURR_ATTRIBUTE_TYPE IN VARCHAR2
99 ,CURR_ATTRIBUTE_CONTEXT IN VARCHAR2) RETURN CHAR;
100
101 FUNCTION CF_ATTRIBUTEFORMULA(CURR_ATTRIBUTE_TYPE IN VARCHAR2
102 ,CURR_ATTRIBUTE_CONTEXT IN VARCHAR2
103 ,CURR_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
104
105 FUNCTION CF_ATTRIBUTE_VALUEFORMULA(CURR_ATTRIBUTE_TYPE IN VARCHAR2
106 ,CURR_ATTRIBUTE_CONTEXT IN VARCHAR2
107 ,CURR_ATTRIBUTE IN VARCHAR2
108 ,CURR_ATTRIBUTE_VALUE IN VARCHAR2) RETURN CHAR;
109
110 FUNCTION CF_PRODUCT_ATTR_VAL_DISPFORMUL(PRODUCT_ATTRIBUTE_CONTEXT1 IN VARCHAR2
111 ,PRODUCT_ATTRIBUTE1 IN VARCHAR2
112 ,PRODUCT_ATTR_VALUE IN VARCHAR2
113 ,PRODUCT_ATTR_VAL_DISP IN VARCHAR2) RETURN CHAR;
114
115 FUNCTION CF_QUAL_ATTR_VALUE_TOFORMULA(QUALIFIER_CONTEXT IN VARCHAR2
116 ,QUALIFIER_ATTRIBUTE IN VARCHAR2
117 ,QUALIFIER_ATTR_VALUE_TO IN VARCHAR2
118 ,COMPARISION_OPERATOR_CODE IN VARCHAR2) RETURN CHAR;
119
120 FUNCTION AFTERREPORT RETURN BOOLEAN;
121
122 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
123
124 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
125
126 END QP_QPXPRCST_XMLP_PKG;