PACKAGE: APPS.ONT_OEXOECCH_XMLP_PKG

Source

1 PACKAGE ONT_OEXOECCH_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOECCHS.pls 120.1 2007/12/25 07:14:14 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_ORDER_NUMBER VARCHAR2(32767);
8 
9   P_CUSTOMER_NAME VARCHAR2(360);
10 
11   P_DATE_HOLD_APPLIED_LOW DATE;
12 
13   P_DATE_HOLD_APPLIED_HIGH DATE;
14 
15   P_CURRENCY_CODE VARCHAR2(60);
16 
17   P_CUSTOMER_NUMBER VARCHAR2(30);
18 
19   LP_ORDER_NUMBER VARCHAR2(500):=' ' ;
20 
21   LP_DATE_HOLD_APPLIED VARCHAR2(500):=' ';
22 
23   LP_CURRENCY_CODE VARCHAR2(500):='  ';
24 
25   LP_CUSTOMER_NUMBER VARCHAR2(500):=' ';
26 
27   LP_CUSTOMER_NAME VARCHAR2(500):=' ';
28 
29   P_ORDER_TYPE VARCHAR2(30);
30 
31   LP_ORDER_TYPE VARCHAR2(500):=' ';
32 
33   P_VAT_PROFILE VARCHAR2(30);
34 
35   L_ORDER_TYPE VARCHAR2(30);
36 
37   C_UNINV_ORD_SHIP NUMBER;
38 
39   C_UNINV_ORD_CREDIT NUMBER;
40 
41   C_REC_BAL_SHIP NUMBER;
42 
43   C_REC_BAL_CREDIT NUMBER;
44 
45   C_TOT_ORDER_LIMIT NUMBER;
46 
47   C_ORDER_LIMIT NUMBER;
48 
49   C_REC_BAL_PICK NUMBER;
50 
51   C_REC_BAL_PACK NUMBER;
52 
53   C_UNINV_ORD_PICK NUMBER;
54 
55   C_UNINV_ORD_PACK NUMBER;
56 
57   RP_REPORT_NAME VARCHAR2(240);
58 
59   RP_SUB_TITLE VARCHAR2(240);
60 
61   RP_COMPANY_NAME VARCHAR2(100);
62 
63   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
64 
65   RP_DATA_FOUND VARCHAR2(300);
66 
67   RP_DATE_HOLD_APPLIED_RANGE VARCHAR2(100);
68 
69   RP_SHIP VARCHAR2(100);
70 
71   RP_ORDER VARCHAR2(100);
72 
73   RP_VAT_PROFILE VARCHAR2(100);
74 
75   RP_CURR_PROFILE VARCHAR2(20);
76 
77   RP_ORDER_AMOUNT NUMBER;
78 
79   RP_TOTAL_AMOUNT NUMBER;
80 
81   RP_PICK VARCHAR2(100);
82 
83   RP_PACK VARCHAR2(100);
84 
85   FUNCTION BEFOREREPORT RETURN BOOLEAN;
86 
87   FUNCTION AFTERREPORT RETURN BOOLEAN;
88 
89   FUNCTION AFTERPFORM RETURN BOOLEAN;
90 
91   FUNCTION C_COMPUTE_AMOUNTSFORMULA(SITE_USE_ID IN NUMBER
92                                    ,CURRENCY1 IN VARCHAR2
93                                    ,CUSTOMER_ID IN NUMBER
94                                    ,ENTRY_OPEN_AR_DAYS IN NUMBER
95                                    ,ENTRY_OPEN_AR_FLAG IN VARCHAR2
96                                    ,SHIP_OPEN_AR_DAYS IN NUMBER
97                                    ,SHIP_OPEN_AR_FLAG IN VARCHAR2
98                                    ,ENTRY_UNINVOICED_FLAG IN VARCHAR2
99                                    ,ENTRY_ON_HOLD_FLAG IN VARCHAR2
100                                    ,SHIP_UNINVOICED_FLAG IN VARCHAR2
101                                    ,SHIP_ON_HOLD_FLAG IN VARCHAR2
102                                    ,ENTRY_SHIPPING_INTERVAL IN NUMBER
103                                    ,SHIP_SHIPPING_INTERVAL IN NUMBER
104                                    ,ENTRY_RULE_ID IN NUMBER
105                                    ,SHIP_RULE_ID IN NUMBER
106                                    ,PICK_OPEN_AR_DAYS IN NUMBER
107                                    ,PICK_OPEN_AR_FLAG IN VARCHAR2
108                                    ,PICK_UNINVOICED_FLAG IN VARCHAR2
109                                    ,PICK_ON_HOLD_FLAG IN VARCHAR2
110                                    ,PICK_SHIPPING_INTERVAL IN NUMBER
111                                    ,PICK_RULE_ID IN NUMBER
112                                    ,PACK_OPEN_AR_DAYS IN NUMBER
113                                    ,PACK_OPEN_AR_FLAG IN VARCHAR2
114                                    ,PACK_UNINVOICED_FLAG IN VARCHAR2
115                                    ,PACK_ON_HOLD_FLAG IN VARCHAR2
116                                    ,PACK_SHIPPING_INTERVAL IN NUMBER
117                                    ,PACK_RULE_ID IN NUMBER) RETURN NUMBER;
118 
119   FUNCTION C_DATA_NOT_FOUNDFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN NUMBER;
120 
121   FUNCTION C_ADDRESSFORMULA(ADDRESS1 IN VARCHAR2
122                            ,CITY IN VARCHAR2
123                            ,STATE IN VARCHAR2) RETURN VARCHAR2;
124 
125   FUNCTION C_DAYS_ON_HOLD_CRFORMULA(S_DAYS_ON_HOLD_CR IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION C_DAYS_ON_HOLD_CUFORMULA(S_DAYS_ON_HOLD_CU IN NUMBER) RETURN NUMBER;
128 
129   FUNCTION C_UNINV_ORD_SHIP_P RETURN NUMBER;
130 
131   FUNCTION C_UNINV_ORD_CREDIT_P RETURN NUMBER;
132 
133   FUNCTION C_REC_BAL_SHIP_P RETURN NUMBER;
134 
135   FUNCTION C_REC_BAL_CREDIT_P RETURN NUMBER;
136 
137   FUNCTION C_TOT_ORDER_LIMIT_P RETURN NUMBER;
138 
139   FUNCTION C_ORDER_LIMIT_P RETURN NUMBER;
140 
141   FUNCTION C_REC_BAL_PICK_P RETURN NUMBER;
142 
143   FUNCTION C_REC_BAL_PACK_P RETURN NUMBER;
144 
145   FUNCTION C_UNINV_ORD_PICK_P RETURN NUMBER;
146 
147   FUNCTION C_UNINV_ORD_PACK_P RETURN NUMBER;
148 
149   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
150 
151   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
152 
153   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
154 
155   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
156 
157   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
158 
159   FUNCTION RP_DATE_HOLD_APPLIED_RANGE_P RETURN VARCHAR2;
160 
161   FUNCTION RP_SHIP_P RETURN VARCHAR2;
162 
163   FUNCTION RP_ORDER_P RETURN VARCHAR2;
164 
165   FUNCTION RP_VAT_PROFILE_P RETURN VARCHAR2;
166 
167   FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
168 
169   FUNCTION RP_ORDER_AMOUNT_P RETURN NUMBER;
170 
171   FUNCTION RP_TOTAL_AMOUNT_P RETURN NUMBER;
172 
173   FUNCTION RP_PICK_P RETURN VARCHAR2;
174 
175   FUNCTION RP_PACK_P RETURN VARCHAR2;
176 
177   FUNCTION ORDER_AMOUNT_DSPFORMULA( currency1 in varchar2,order_amount in number) RETURN VARCHAR2;
178 
179   FUNCTION S_ORDER_AMOUNT_CR_DSPFORMULA( currency1 in varchar2,s_order_amount_cr in number) RETURN VARCHAR2;
180 END ONT_OEXOECCH_XMLP_PKG;
181