[Home] [Help]
PACKAGE: APPS.QP_QPXPRMLS_XMLP_PKG
Source
1 PACKAGE QP_QPXPRMLS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: QPXPRMLSS.pls 120.2 2010/11/03 16:14:35 smuhamme noship $ */
3 P_SOB_ID NUMBER;
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_MODIFIER_NUMBER_TO VARCHAR2(240);
8
9 P_MODIFIER_NAME_TO VARCHAR2(40);
10
11 P_MODIFIER_NUMBER_FROM VARCHAR2(240);
12
13 P_MODIFIER_VERSION_FROM VARCHAR2(30);
14
15 P_MODIFIER_VERSION_TO VARCHAR2(30);
16
17 P_START_DATE_ACTIVE DATE;
18
19 P_END_DATE_ACTIVE DATE;
20
21 P_ACTIVE_MODIFIER_ONLY VARCHAR2(32767);
22
23 P_ACTIVE_MODIFIER_LINES VARCHAR2(32767);
24
25 P_QUALIFIER_CONTEXT VARCHAR2(30);
26
27 P_QUALIFIER_ATTRIBUTE_FROM VARCHAR2(30);
28
29 P_QUALIFIER_ATTRIBUTE_TO VARCHAR2(30);
30
31 P_MODIFIER_NAME_FROM VARCHAR2(40);
32
33 LP_ACTIVE_ONLY VARCHAR2(240);
34
35 LP_ACTIVE_LINES_ONLY VARCHAR2(240);
36
37 P_CUSTOMER_ID VARCHAR2(40);
38
39 P_CUSTOMER_CLASS_ID VARCHAR2(40);
40
41 P_PRICE_LIST_ID VARCHAR2(40);
42
43 P_ITEM_ID VARCHAR2(40);
44
45 P_ITEM_CATEGORY_ID VARCHAR2(40);
46
47 LP_MODIFIER_NAME VARCHAR2(100) := ' and 1=1';
48
49 LP_MODIFIER_NUMBER VARCHAR2(100) := ' and 1=1';
50
51 LP_MODIFIER_VERSION VARCHAR2(100) := ' and 1=1';
52
53 LP_ACTIVE_MODIFIER_ONLY VARCHAR2(100) := ' and 1=1';
54
55 LP_ACTIVE_DATE VARCHAR2(100) := ' and 1=1';
56
57 LP_CUSTOMER_ID VARCHAR2(500) := ' and 1=1';
58
59 LP_CUSTOMER_CLASS_ID VARCHAR2(500) := ' and 1=1';
60
61 LP_PRICE_LIST_ID VARCHAR2(500) := ' and 1=1';
62
63 LP_ITEM_ID VARCHAR2(500) := ' and 1=1';
64
65 LP_ITEM_CATEGORY_ID VARCHAR2(500) := ' and 1=1';
66
67 P_ENABLE_TRACE VARCHAR2(5);
68
69 LP_ACTIVE_MODIFIER_LINES_ONLY VARCHAR2(300) := ' and 1=1';
70
71 P_RESP_ID NUMBER;
72
73 P_USER_NAME VARCHAR2(240);
74
75 RP_REPORT_NAME VARCHAR2(240);
76
77 RP_COMPANY_NAME VARCHAR2(100);
78
79 FUNCTION BEFOREREPORT RETURN BOOLEAN;
80
81 FUNCTION CF_LINE_TYPE_CODEFORMULA(LIST_TYPE_CODE IN VARCHAR2) RETURN CHAR;
82
83 FUNCTION CF_PARENT_NUMBERFORMULA(PARENT_LIST_HEADER_ID IN NUMBER) RETURN CHAR;
84
85 FUNCTION CF_PARENT_VERSIONFORMULA(PARENT_LIST_HEADER_ID IN NUMBER) RETURN CHAR;
86
87 FUNCTION CF_COUP_LIST_LINEFORMULA(LIST_LINE_ID1 IN NUMBER) RETURN CHAR;
88
89 FUNCTION CF_QUALIFIER_ATTRIBUTEFORMULA(QUALIFIER_CONTEXT IN VARCHAR2
90 ,QUALIFIER_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
91
92 FUNCTION GET_SEGMENT_NAME(QUALIFIER_CONTEXT IN VARCHAR2
93 ,QUALIFIER_ATTRIBUTE IN VARCHAR2) RETURN CHAR;
94
95 FUNCTION GET_NUM_DATE_FROM_CANONICAL(P_DATATYPE IN VARCHAR2
96 ,P_VALUE IN VARCHAR2) RETURN VARCHAR2;
97
98 /*FUNCTION GET_ATTR_VALUE_TO(P_FLEXFIELD_NAME IN VARCHAR2
99 ,P_CONTEXT_NAME IN VARCHAR2
100 ,P_SEGMENT_NAME IN VARCHAR2
101 ,P_ATTR_VALUE_TO IN VARCHAR2) RETURN VARCHAR2;*/
102
103 /*FUNCTION GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME IN VARCHAR2
104 ,P_CONTEXT_NAME IN VARCHAR2
105 ,P_SEGMENT_NAME IN VARCHAR2
106 ,P_ATTR_VALUE IN VARCHAR2) RETURN VARCHAR2;*/
107
108 FUNCTION CF_ATTR_VALUE_FROMFORMULA(QUALIFIER_CONTEXT IN VARCHAR2
109 ,QUALIFIER_ATTRIBUTE IN VARCHAR2
110 ,QUALIFIER_ATTR_VALUE IN VARCHAR2
111 ,COMPARISION_OPERATOR_CODE IN VARCHAR2
112 ,QUALIFIER_DATATYPE IN VARCHAR2
113 ,COMPARISION_OPERATOR_CODE1 IN VARCHAR2) RETURN CHAR;
114
115 FUNCTION CF_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
119 ,QUALIFIER_DATATYPE IN VARCHAR2
120 ,COMPARISION_OPERATOR_CODE1 IN VARCHAR2
121 ,QUALIFIER_ATTR_VALUE IN VARCHAR2) RETURN CHAR;
122
123 FUNCTION AFTERPFORM RETURN BOOLEAN;
124
125 FUNCTION CF_NET_AMOUNT_CALCFORMULA(NET_AMOUNT_FLAG IN VARCHAR2) RETURN CHAR;
126
127 FUNCTION AFTERREPORT RETURN BOOLEAN;
128
129 FUNCTION CF_BENEFIT_PRICEFORMULA(BENEFIT_PRICE_LIST_LINE_ID IN NUMBER) RETURN NUMBER;
130
131 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
132
133 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
134
135 END QP_QPXPRMLS_XMLP_PKG;