1 PACKAGE GMI_ICR03_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ICR03S.pls 120.0 2007/12/24 13:16:35 nchinnam noship $ */
3 FROM_WHSE VARCHAR2(4);
4 TO_WHSE VARCHAR2(4);
5 FROM_TRANSDATE DATE;
6 TO_TRANSDATE DATE;
7 FROM_TRANSDATE1 varchar2(15);
8 TO_TRANSDATE1 varchar2(15);
9 COST_METHOD VARCHAR2(4);
10 P_ORGN VARCHAR2(4);
11 DEFAULT_CURR VARCHAR2(40);
12 NONBLOCKSQL VARCHAR2(3);
13 P_CONC_REQUEST_ID NUMBER;
14 DOC_TYPECP VARCHAR2(4);
15 DOCUMENT_NOCP VARCHAR2(32);
16 FORMULA_NOCP VARCHAR2(32);
17 VERSCP NUMBER := 0;
18 VEND_SHIP_LOCATIONCP VARCHAR2(32);
19 FRTBILL_MTHDCP VARCHAR2(4) := 'NONE';
20 SHIPPING_MTHDCP VARCHAR2(4) := 'NONE';
21 SHIPPER_NAMECP VARCHAR2(40);
22 FUNCTION DOCUMENT_NOCFFORMULA(DOC_TYPE IN VARCHAR2
23 ,DOC_ID IN NUMBER
24 ,LINE_ID1 IN NUMBER
25 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
26 FUNCTION FORMULA_NOCFFORMULA(DOC_TYPE IN VARCHAR2
27 ,DOC_ID IN NUMBER
28 ,LINE_ID1 IN NUMBER
29 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
30 FUNCTION VERSCFFORMULA(DOC_TYPE IN VARCHAR2
31 ,DOC_ID IN NUMBER
32 ,LINE_ID1 IN NUMBER
33 ,ITEM_ID1 IN NUMBER) RETURN NUMBER;
34 FUNCTION VEND_SHIP_LOCATIONCFFORMULA(DOC_TYPE IN VARCHAR2
35 ,DOC_ID IN NUMBER
36 ,LINE_ID1 IN NUMBER
37 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
38 FUNCTION FRTBILL_MTHDCFFORMULA(DOC_TYPE IN VARCHAR2
39 ,DOC_ID IN NUMBER
40 ,LINE_ID1 IN NUMBER
41 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
42 FUNCTION SHIPPING_MTHDCFFORMULA(DOC_TYPE IN VARCHAR2
43 ,DOC_ID IN NUMBER
44 ,LINE_ID1 IN NUMBER
45 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
46 FUNCTION SHIPPER_NAMECFFORMULA(DOC_TYPE IN VARCHAR2
47 ,DOC_ID IN NUMBER
48 ,LINE_ID1 IN NUMBER
49 ,ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
50 FUNCTION DOC_TYPECFFORMULA(DOC_TYPE IN VARCHAR2) RETURN VARCHAR2;
51 FUNCTION RANGE1CFFORMULA RETURN VARCHAR2;
52 FUNCTION RANGE2CFFORMULA RETURN VARCHAR2;
53 FUNCTION UNIT_COSTCFFORMULA(ITEM_ID1 IN NUMBER
54 ,WAREHOUSE IN VARCHAR2
55 ,TRANS_DATE IN DATE) RETURN NUMBER;
56 FUNCTION COST_ACCUMCFFORMULA(UNIT_COSTCF IN NUMBER
57 ,COUNT_QTYSC IN NUMBER) RETURN NUMBER;
58 FUNCTION DEFAULTCURRCFFORMULA(COST_ACCUMCF IN NUMBER) RETURN VARCHAR2;
59 FUNCTION BEFOREREPORT RETURN BOOLEAN;
60 FUNCTION AFTERPFORM RETURN BOOLEAN;
61 PROCEDURE GMI_ICR03_XMLP_PKG_HEADER;
62 FUNCTION AFTERREPORT RETURN BOOLEAN;
63 FUNCTION DOC_TYPECP_P RETURN VARCHAR2;
64 FUNCTION DOCUMENT_NOCP_P RETURN VARCHAR2;
65 FUNCTION FORMULA_NOCP_P RETURN VARCHAR2;
66 FUNCTION VERSCP_P RETURN NUMBER;
67 FUNCTION VEND_SHIP_LOCATIONCP_P RETURN VARCHAR2;
68 FUNCTION FRTBILL_MTHDCP_P RETURN VARCHAR2;
69 FUNCTION SHIPPING_MTHDCP_P RETURN VARCHAR2;
70 FUNCTION SHIPPER_NAMECP_P RETURN VARCHAR2;
71 END GMI_ICR03_XMLP_PKG;
72
[Home] [Help]