PACKAGE: APPS.RLM_RLMDMSIQ_XMLP_PKG

Source

1 PACKAGE RLM_RLMDMSIQ_XMLP_PKG AS
2 /* $Header: RLMDMSIQS.pls 120.0 2008/01/25 09:38:28 krreddy noship $ */
3   P_SHIP_FROM_ORG_ID NUMBER;
4 
5   P_CUSTOMER_ID NUMBER;
6 
7   P_SHIP_TO_ORG_ID NUMBER;
8 
9   P_DELIVER_TO_ORG_ID NUMBER;
10 
11   P_FROM_SHIP_DATE DATE;
12 
13   P_TO_SHIP_DATE DATE;
14 
15   P_CUST_OR_INV_ITEM VARCHAR2(32767);
16 
17   P_FROM_ITEM_ID NUMBER;
18 
19   P_TO_ITEM_ID NUMBER;
20 
21   P_FROM_ORDER NUMBER;
22 
23   P_TO_ORDER NUMBER;
24 
25   P_REQ_FIRM_FORECAST_BOTH VARCHAR2(32767):= 'B';
26 
27   P_INCL_CANCEL_LINES VARCHAR2(32767):= 'Y';
28 
29   P_SHIP_UNSHIP_BOTH VARCHAR2(32767):='B';
30 
31   P_SUM_DATE_AND_BUCKET VARCHAR2(32767):='N';
32 
33   P_INCL_CURR_RES_AUTHZNS VARCHAR2(32767):= 'Y';
34 
35   P_TITLE VARCHAR2(100);
36 
37   P_WHERE_CLAUSE1 VARCHAR2(500):=' ';
38 
39   P_WHERE_CLAUSE2 VARCHAR2(500):=' ';
40 
41   LP_Q1_COL1 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAA''';
42 
43   LP_Q1_COL2 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
44 
45   LP_Q1_COL3 VARCHAR2(40) := 'NULL';
46 
47   LP_Q1_COL4 VARCHAR2(40) := 'NULL';
48 
49   LP_Q1_COL5 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
50 
51   LP_Q1_COL6 VARCHAR2(40) := 'NULL';
52 
53   LP_Q1_COL7 VARCHAR2(40) := '''AAA''';
54 
55   LP_Q1_COL8 VARCHAR2(40) := 'NULL';
56 
57   LP_Q1_COL9 VARCHAR2(40) := '''AAA''';
58 
59   LP_Q1_COL10 VARCHAR2(40) := 'NULL';
60 
61   LP_Q1_COL11 VARCHAR2(40) := '''AAA''';
62 
63   LP_Q1_COL12 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
64 
65   LP_Q1_COL13 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
66 
67   LP_Q1_COL14 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
68 
69   LP_Q1_COL15 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
70 
71   LP_Q1_COL16 VARCHAR2(40) := '''AAAAAAAAAA''';
72 
73   LP_Q2_COL1 VARCHAR2(100) := 'NULL';
74 
75   LP_Q2_COL2 VARCHAR2(40) := 'NULL';
76 
77   LP_Q2_COL3 VARCHAR2(40) := 'NULL';
78 
79   LP_Q2_COL4 VARCHAR2(40) := 'NULL';
80 
81   LP_Q2_COL5 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
82 
83   LP_Q2_COL6 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
84 
85   LP_Q2_COL7 VARCHAR2(40) := 'NULL';
86 
87   LP_Q2_COL8 VARCHAR2(40) := 'NULL';
88 
89   LP_Q2_COL9 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
90 
91   LP_Q2_COL10 VARCHAR2(40) := 'NULL';
92 
93   LP_Q2_COL11 VARCHAR2(40) := '''AAA''';
94 
95   LP_Q1_GROUP_BY VARCHAR2(1000):=' ';
96 
97   LP_Q2_GROUP_BY VARCHAR2(1000):=' ';
98 
99   LP_Q1_LINES VARCHAR2(300):=' ';
100 
101   LP_Q1_COL17 VARCHAR2(100) := '''AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA''';
102 
103   P_ORG_ID NUMBER;
104 
105   P_CONC_REQUEST_ID NUMBER;
106 
107   CP_DEFAULT_OU VARCHAR2(240);
108 
109   CP_P_CUSTOMER_NAME VARCHAR2(240);
110 
111   CP_P_SHIP_TO VARCHAR2(240);
112 
113   CP_P_SHIP_FROM VARCHAR2(240);
114 
115   CP_P_DELIVER_TO VARCHAR2(240);
116 
117   FUNCTION BEFOREREPORT RETURN BOOLEAN;
118 
119   FUNCTION CUSTOMER_NUMBERFORMULA(SOLD_TO_ORG_ID IN NUMBER) RETURN CHAR;
120 
121   FUNCTION CUSTOMER_NAMEFORMULA(SOLD_TO_ORG_ID IN NUMBER) RETURN CHAR;
122 
123   FUNCTION SHIP_FROM_CODEFORMULA(SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
124 
125   FUNCTION SHIP_FROM_NAMEFORMULA(SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
126 
127   FUNCTION CUSTOMER_ITEM_NUMBERFORMULA(ORDERED_ITEM_ID IN NUMBER) RETURN CHAR;
128 
129   FUNCTION CUSTOMER_ITEM_DESCFORMULA(ORDERED_ITEM_ID IN NUMBER) RETURN CHAR;
130 
131   FUNCTION CONCATENATED_SEGMENTSFORMULA(INVENTORY_ITEM_ID IN NUMBER
132                                        ,SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
133 
134   FUNCTION DESCRIPTIONFORMULA(INVENTORY_ITEM_ID IN NUMBER
135                              ,SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
136 
137   FUNCTION BUCKET_TYPE_CODEFORMULA(DEMAND_BUCKET_TYPE_CODE IN VARCHAR2) RETURN CHAR;
138 
139   FUNCTION SHIP_TO_LOCATIONFORMULA(SHIP_TO_ORG_ID3 IN NUMBER) RETURN CHAR;
140 
141   FUNCTION INTMED_SHIP_TO_LOCATIONFORMUL(INTMED_SHIP_TO_ORG_ID IN NUMBER) RETURN CHAR;
142 
143   FUNCTION SHIP_TO_NAMEFORMULA(SHIP_TO_ORG_ID3 IN NUMBER) RETURN CHAR;
144 
145   FUNCTION INTMED_SHIP_TO_NAMEFORMULA(INTMED_SHIP_TO_ORG_ID IN NUMBER) RETURN CHAR;
146 
147   FUNCTION FCST_BUCKET_TYPE_CODEFORMULA(DEMAND_BUCKET_TYPE_CODE1 IN VARCHAR2) RETURN CHAR;
148 
149   FUNCTION CUM_START_DATEFORMULA(VEH_CUS_ITEM_CUM_KEY_ID IN NUMBER) RETURN DATE;
150 
151   FUNCTION CUM_QTYFORMULA(VEH_CUS_ITEM_CUM_KEY_ID IN NUMBER) RETURN NUMBER;
152 
153   FUNCTION LAST_CUM_QTY_UPDATE_DATEFORMU(VEH_CUS_ITEM_CUM_KEY_ID IN NUMBER) RETURN DATE;
154 
155   FUNCTION CF_SCHED_TYPE(SCHEDULE_TYPE IN VARCHAR2) RETURN VARCHAR2;
156 
157   FUNCTION CF_SCHED_TYPE_2(SCHEDULE_TYPE2 IN VARCHAR2) RETURN VARCHAR2;
158 
159   FUNCTION AFTERPFORM RETURN BOOLEAN;
160 
161   FUNCTION AFTERREPORT RETURN BOOLEAN;
162 
163   FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
164 
165   FUNCTION CP_P_CUSTOMER_NAME_P RETURN VARCHAR2;
166 
167   FUNCTION CP_P_SHIP_TO_P RETURN VARCHAR2;
168 
169   FUNCTION CP_P_SHIP_FROM_P RETURN VARCHAR2;
170 
171   FUNCTION CP_P_DELIVER_TO_P RETURN VARCHAR2;
172 
173 END RLM_RLMDMSIQ_XMLP_PKG;
174