[Home] [Help]
PACKAGE: APPS.RLM_RLMSCHRL_XMLP_PKG
Source
1 PACKAGE RLM_RLMSCHRL_XMLP_PKG AS
2 /* $Header: RLMSCHRLS.pls 120.0 2008/01/25 09:44:08 krreddy noship $ */
3 P_CUSTOMER NUMBER;
4
5 P_SCHEDULE_TYPE VARCHAR2(32767);
6
7 P_SCHEDULE_NUM VARCHAR2(40);
8
9 P_SHIP_FROM NUMBER;
10
11 P_SHIP_TO VARCHAR2(32767);
12
13 P_SCHEDULE_PURPOSE VARCHAR2(32767);
14
15 P_HORIZON_START_DATE VARCHAR2(30);
16
17 P_HORIZON_END_DATE VARCHAR2(30);
18
19 P_ISSUE_DATE_FROM VARCHAR2(30);
20
21 P_ISSUE_DATE_TO VARCHAR2(30);
22
23 P_TP_FROM VARCHAR2(32767);
24
25 P_TP_TO VARCHAR2(32767);
26
27 P_TP_LOC_FROM VARCHAR2(32767);
28
29 P_TP_LOC_TO VARCHAR2(32767);
30
31 P_PROCESS_DATE_FROM VARCHAR2(30);
32
33 P_PROCESS_DATE_TO VARCHAR2(30);
34
35 P_WHERE_CLAUSE VARCHAR2(1500);
36
37 P_PROCESS_STATUS NUMBER;
38
39 P_SCHEDULE_SOURCE VARCHAR2(32767);
40
41 P_DETAIL_TYPE VARCHAR2(30);
42
43 P_TITLE VARCHAR2(50);
44
45 P_SHIPPED_REC_CUM VARCHAR2(100);
46
47 P_AUTH VARCHAR2(30);
48
49 P_OTHER VARCHAR2(32767);
50
51 P_REF_NUM VARCHAR2(35);
52
53 P_ORG_ID NUMBER;
54
55 P_CONC_REQUEST_ID NUMBER;
56
57 CP_CUSTOMER VARCHAR2(20);
58
59 CP_SCHEDULE_REF_NUM VARCHAR2(35);
60
61 CP_SHIP_FROM_ORG VARCHAR2(20);
62
63 CP_SHIP_TO VARCHAR2(20);
64
65 CP_SCHEDULE_TYPE VARCHAR2(30);
66
67 CP_SCHEDULE_PURPOSE VARCHAR2(30);
68
69 CP_SCHEDULE_SOURCE VARCHAR2(20);
70
71 CP_PROCESS_STATUS VARCHAR2(40);
72
73 CP_HORIZON_START_DATE VARCHAR2(30);
74
75 CP_HORIZON_END_DATE VARCHAR2(30);
76
77 CP_ISSUE_DATE_FROM VARCHAR2(30);
78
79 CP_ISSUE_DATE_TO VARCHAR2(30);
80
81 CP_TP_FROM VARCHAR2(20);
82
83 CP_TP_TO VARCHAR2(20);
84
85 CP_TP_LOC_CODE_FROM VARCHAR2(20);
86
87 CP_TP_LOC_CODE_TO VARCHAR2(20);
88
89 CP_PROCESS_DATE_FROM VARCHAR2(30);
90
91 CP_PROCESS_DATE_TO VARCHAR2(30);
92
93 CP_TITLE VARCHAR2(50);
94
95 CP_DEFAULT_OU VARCHAR2(240);
96
97 FUNCTION CF_CUSTOMER_NUMFORMULA(CUSTOMER_ID IN NUMBER) RETURN CHAR;
98
99 FUNCTION CF_SHIP_FROM_ORGFORMULA(SCHEDULE_SOURCE IN VARCHAR2
100 ,SHIP_FROM_ORG_ID IN NUMBER
101 ,CUST_SHIP_FROM_ORG_EXT IN VARCHAR2) RETURN VARCHAR;
102
103 FUNCTION CF_SHIP_TO_LOCFORMULA(SCHEDULE_SOURCE IN VARCHAR2
104 ,SHIP_TO_ADDRESS_ID IN NUMBER
105 ,CUST_SHIP_TO_EXT IN VARCHAR2) RETURN VARCHAR;
106
107 FUNCTION CF_CUST_ITEM_NUMFORMULA(SCHEDULE_SOURCE IN VARCHAR2
108 ,CUSTOMER_ITEM_ID IN NUMBER
109 ,CUSTOMER_ID IN NUMBER
110 ,CUSTOMER_ITEM_EXT IN VARCHAR2) RETURN VARCHAR;
111
112 FUNCTION AFTERPFORM RETURN BOOLEAN;
113
114 FUNCTION BEFOREREPORT RETURN BOOLEAN;
115
116 FUNCTION CF_TEST_INDICATORFORMULA(EDI_TEST_INDICATOR IN VARCHAR2) RETURN CHAR;
117
118 FUNCTION CF_SHIP_DEL_PATTERNFORMULA(SHIP_DEL_PATTERN_EXT IN VARCHAR2) RETURN CHAR;
119
120 FUNCTION CF_INV_ITEM_CONC_SEGMENTFORMUL(INVENTORY_ITEM_ID IN NUMBER
121 ,SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR;
122
123 FUNCTION CF_SHIP_FROM_ORG1FORMULA(SCHEDULE_SOURCE IN VARCHAR2
124 ,SHIP_FROM_ORG_ID1 IN NUMBER
125 ,CUST_SHIP_FROM_ORG_EXT1 IN VARCHAR2) RETURN VARCHAR;
126
127 FUNCTION CF_SHIP_TO_LOC1FORMULA(SCHEDULE_SOURCE IN VARCHAR2
128 ,SHIP_TO_ADDRESS_ID1 IN NUMBER
129 ,CUST_SHIP_TO_EXT1 IN VARCHAR2) RETURN VARCHAR;
130
131 FUNCTION CF_SHIP_DEL_PATTERN1FORMULA(SHIP_DEL_PATTERN_EXT1 IN VARCHAR2) RETURN CHAR;
132
133 FUNCTION CF_INV_CONC_SEGMENT1FORMULA(INVENTORY_ITEM_ID1 IN NUMBER
134 ,SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR;
135
136 FUNCTION CF_CUST_ITEM_NUM1FORMULA(SCHEDULE_SOURCE IN VARCHAR2
137 ,CUSTOMER_ITEM_ID1 IN NUMBER
138 ,CUSTOMER_ID IN NUMBER
139 ,CUSTOMER_ITEM_EXT1 IN VARCHAR2) RETURN CHAR;
140
141 FUNCTION CF_BILL_TO_LOCFORMULA(BILL_TO_ADDRESS_ID IN NUMBER) RETURN CHAR;
142
143 FUNCTION CF_BILL_TO_LOC1FORMULA(BILL_TO_ADDRESS_ID1 IN NUMBER) RETURN CHAR;
144
145 FUNCTION CF_SCHEDULE_SOURCEFORMULA(SCHEDULE_SOURCE IN VARCHAR2) RETURN CHAR;
146
147 FUNCTION CF_ADDRESS1FORMULA(CUST_ADDRESS_1_EXT IN VARCHAR2
148 ,CUST_ADDRESS_2_EXT IN VARCHAR2
149 ,CUST_ADDRESS_3_EXT IN VARCHAR2
150 ,CUST_ADDRESS_4_EXT IN VARCHAR2) RETURN CHAR;
151
152 FUNCTION CF_ADDRESS2FORMULA(CUST_ADDRESS_1_EXT IN VARCHAR2
153 ,CUST_ADDRESS_2_EXT IN VARCHAR2
154 ,CUST_ADDRESS_3_EXT IN VARCHAR2
155 ,CUST_ADDRESS_4_EXT IN VARCHAR2) RETURN CHAR;
156
157 FUNCTION CF_ADDRESS3FORMULA(CUST_ADDRESS_1_EXT IN VARCHAR2
158 ,CUST_ADDRESS_2_EXT IN VARCHAR2
159 ,CUST_ADDRESS_3_EXT IN VARCHAR2
160 ,CUST_ADDRESS_4_EXT IN VARCHAR2) RETURN CHAR;
161
162 FUNCTION CF_ADDRESS4FORMULA(CUST_ADDRESS_1_EXT IN VARCHAR2
163 ,CUST_ADDRESS_2_EXT IN VARCHAR2
164 ,CUST_ADDRESS_3_EXT IN VARCHAR2
165 ,CUST_ADDRESS_4_EXT IN VARCHAR2) RETURN CHAR;
166
167 FUNCTION AFTERREPORT RETURN BOOLEAN;
168
169 FUNCTION CP_CUSTOMER_P RETURN VARCHAR2;
170
171 FUNCTION CP_SCHEDULE_REF_NUM_P RETURN VARCHAR2;
172
173 FUNCTION CP_SHIP_FROM_ORG_P RETURN VARCHAR2;
174
175 FUNCTION CP_SHIP_TO_P RETURN VARCHAR2;
176
177 FUNCTION CP_SCHEDULE_TYPE_P RETURN VARCHAR2;
178
179 FUNCTION CP_SCHEDULE_PURPOSE_P RETURN VARCHAR2;
180
181 FUNCTION CP_SCHEDULE_SOURCE_P RETURN VARCHAR2;
182
183 FUNCTION CP_PROCESS_STATUS_P RETURN VARCHAR2;
184
185 FUNCTION CP_HORIZON_START_DATE_P RETURN VARCHAR2;
186
187 FUNCTION CP_HORIZON_END_DATE_P RETURN VARCHAR2;
188
189 FUNCTION CP_ISSUE_DATE_FROM_P RETURN VARCHAR2;
190
191 FUNCTION CP_ISSUE_DATE_TO_P RETURN VARCHAR2;
192
193 FUNCTION CP_TP_FROM_P RETURN VARCHAR2;
194
195 FUNCTION CP_TP_TO_P RETURN VARCHAR2;
196
197 FUNCTION CP_TP_LOC_CODE_FROM_P RETURN VARCHAR2;
198
199 FUNCTION CP_TP_LOC_CODE_TO_P RETURN VARCHAR2;
200
201 FUNCTION CP_PROCESS_DATE_FROM_P RETURN VARCHAR2;
202
203 FUNCTION CP_PROCESS_DATE_TO_P RETURN VARCHAR2;
204
205 FUNCTION CP_TITLE_P RETURN VARCHAR2;
206
207 FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
208
209 END RLM_RLMSCHRL_XMLP_PKG;