PACKAGE: APPS.GML_ORAKRP_XMLP_PKG

Source

1 PACKAGE GML_ORAKRP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ORAKRPS.pls 120.0 2007/12/24 13:22:29 nchinnam noship $ */
3   ORGN_CODE VARCHAR2(4);
4 
5   P_SORT_ORDER VARCHAR2(40);
6 
7   P_DEFAULT_ORGN VARCHAR2(4);
8 
9   FROM_ORDER_NUMBER VARCHAR2(32);
10 
11   LFROM_ORDER_NUMBER VARCHAR2(32);
12 
13   TO_ORDER_NUMBER VARCHAR2(32);
14 
15   LTO_ORDER_NUMBER VARCHAR2(32);
16 
17   FROM_ORDER_DATE DATE;
18   FROM_ORDER_DATE_1 varchar2(11);
19 
20   TO_ORDER_DATE DATE;
21   TO_ORDER_DATE_1 varchar2(11);
22 
23   FROM_SOLD_TO VARCHAR2(32);
24 
25   LFROM_SOLD_TO VARCHAR2(32);
26 
27   TO_SOLD_TO VARCHAR2(32);
28 
29   LTO_SOLD_TO VARCHAR2(32);
30 
31   FROM_BILL_TO VARCHAR2(32);
32 
33   LFROM_BILL_TO VARCHAR2(32);
34 
35   TO_BILL_TO VARCHAR2(32);
36 
37   LTO_BILL_TO VARCHAR2(32);
38 
39   EXCLUDE_PRINTED VARCHAR2(4);
40 
41   EXCLUDE_ON_HOLD VARCHAR2(4);
42 
43   SORT_1 VARCHAR2(40);
44 
45   SORT_3 VARCHAR2(32767);
46 
47   SORT_2 VARCHAR2(32767);
48 
49   DEFAULT_USER NUMBER;
50 
51   P_BILL_ADDRESS1 VARCHAR2(80);
52 
53   P_CONC_REQUEST_ID NUMBER;
54 
55   CHARGE_DESCCP VARCHAR2(25);
56 
57   CHARGE_AMTCP NUMBER;
58 
59   ORGN_NAME_CP VARCHAR2(100);
60 
61   ORDER_NUMBERCP VARCHAR2(100):=' ';
62 
63   ORDER_DATECP VARCHAR2(100);
64 
65   SOLD_TOCP VARCHAR2(100):=' ';
66 
67   BILL_TOCP VARCHAR2(100):=' ';
68 
69   EXCLUDE_PRINTEDCP VARCHAR2(100) :=' ';
70 
71   EXCLUDE_ON_HOLDCP VARCHAR2(100):=' ';
72 
73   SORT1_CP VARCHAR2(100);
74 
75   SORT2_CP VARCHAR2(100):=' ' ;
76 
77   SORT3_CP VARCHAR2(100):=' ' ;
78 
79   CP_ORGN_NAME VARCHAR2(100);
80 
81   CP_USER VARCHAR2(15);
82 
83   FUNCTION LCHG_DESCCFFORMULA(LINE_ID IN NUMBER
84                              ,ORDER_ID IN NUMBER) RETURN VARCHAR2;
85 
86   FUNCTION BEFOREREPORT RETURN BOOLEAN;
87 
88   FUNCTION NET_WTCFFORMULA(ORDER_UM1 IN VARCHAR2
89                           ,SHIPWT_UM IN VARCHAR2
90                           ,SHIP_QTY1 IN NUMBER
91                           ,ITEM_ID IN NUMBER
92                           ,ITEM_UM IN VARCHAR2) RETURN NUMBER;
93 
94   FUNCTION EXTENDED_AMT_CFFORMULA(ORDER_QTY1 IN NUMBER
95                                  ,NET_PRICE IN NUMBER) RETURN NUMBER;
96 
97   FUNCTION EXTENDED_AMOUNTCFFORMULA(LINE_ID IN NUMBER
98                                    ,ORDER_ID IN NUMBER
99                                    ,EXTENDED_PRICE IN NUMBER) RETURN NUMBER;
100 
101   FUNCTION ORDER_NUMBERCFFORMULA RETURN VARCHAR2;
102 
103   FUNCTION ORDER_DATECFFORMULA RETURN VARCHAR2;
104 
105   FUNCTION SOLD_TOCFFORMULA RETURN VARCHAR2;
106 
107   FUNCTION BILL_TOCFFORMULA RETURN VARCHAR2;
108 
109   FUNCTION EXCLUDE_PRINTEDCFFORMULA RETURN VARCHAR2;
110 
111   FUNCTION EXCLUDED_ON_HOLDCFFORMULA RETURN VARCHAR2;
112 
113   FUNCTION SORT1_CFFORMULA RETURN VARCHAR2;
114 
115   FUNCTION SORT2_CFFORMULA RETURN VARCHAR2;
116 
117   FUNCTION TOT_ORDERCFFORMULA(TOTAL_E_PRICECS IN NUMBER
118                              ,TOT_EXTENDED_AMTCS IN NUMBER) RETURN NUMBER;
119 
120   FUNCTION SORT3_CFFORMULA RETURN VARCHAR2;
121 
122   FUNCTION SORT3_CPFORMULA(SORT3_CF IN VARCHAR2) RETURN VARCHAR2;
123 
124   FUNCTION TERMS_CODEFORMULA(TERMS IN VARCHAR2) RETURN VARCHAR2;
125 
126   PROCEDURE OROAKRP_HEADER;
127 
128   FUNCTION UDATEFORMULA(ORDER_TYPE in Number, O_NO in varchar2, RELEASE_NO in number) RETURN VARCHAR2;
129 
130   FUNCTION LINE_CHARGESCFFORMULA(ORDER_ID IN NUMBER
131                                 ,LINE_ID IN NUMBER) RETURN NUMBER;
132 
133   FUNCTION LINEDISCOUNTS_CFFORMULA(ORDER_ID IN NUMBER
134                                   ,LINE_ID IN NUMBER) RETURN NUMBER;
135 
136   FUNCTION HEAD_CHARGESCFFORMULA(ORDER_ID IN NUMBER) RETURN NUMBER;
137 
138   FUNCTION HEAD_DISCOUNTSCFFORMULA(ORDER_ID IN NUMBER) RETURN NUMBER;
139 
140   FUNCTION ORD_TOT_FORMULA(ORDER_ID IN NUMBER) RETURN NUMBER;
141 
142   FUNCTION AFTERPFORM RETURN BOOLEAN;
143 
144   FUNCTION AFTERREPORT RETURN BOOLEAN;
145 
146   FUNCTION CHARGE_DESCCP_P RETURN VARCHAR2;
147 
148   FUNCTION CHARGE_AMTCP_P RETURN NUMBER;
149 
150   FUNCTION ORGN_NAME_CP_P RETURN VARCHAR2;
151 
152   FUNCTION ORDER_NUMBERCP_P RETURN VARCHAR2;
153 
154   FUNCTION ORDER_DATECP_P RETURN VARCHAR2;
155 
156   FUNCTION SOLD_TOCP_P RETURN VARCHAR2;
157 
158   FUNCTION BILL_TOCP_P RETURN VARCHAR2;
159 
160   FUNCTION EXCLUDE_PRINTEDCP_P RETURN VARCHAR2;
161 
162   FUNCTION EXCLUDE_ON_HOLDCP_P RETURN VARCHAR2;
163 
164   FUNCTION SORT1_CP_P RETURN VARCHAR2;
165 
166   FUNCTION SORT2_CP_P RETURN VARCHAR2;
167 
168   FUNCTION SORT3_CP_P RETURN VARCHAR2;
169 
170   FUNCTION CP_ORGN_NAME_P RETURN VARCHAR2;
171 
172   FUNCTION CP_USER_P RETURN VARCHAR2;
173 
174 END GML_ORAKRP_XMLP_PKG;
175