PACKAGE: APPS.GMF_GMFLCDTL_XMLP_PKG

Source

1 PACKAGE GMF_GMFLCDTL_XMLP_PKG AS
2 /* $Header: GMFLCDTLS.pls 120.0 2007/12/24 13:32:47 nchinnam noship $ */
3   FROM_ORGN VARCHAR2(240);
4 
5   TO_ORGN VARCHAR2(240);
6 
7   FROM_ITEM VARCHAR2(40);
8 
9   TO_ITEM VARCHAR2(40);
10 
11   FROM_COST_CATEGORY VARCHAR2(40);
12 
13   TO_COST_CATEGORY VARCHAR2(40);
14 
15   SY_ALL VARCHAR2(3);
16 
17   NONBLOCKSQL VARCHAR2(5);
18 
19   P_CURRENCY_CODE VARCHAR2(4);
20 
21   P_EXCHANGE_RATE NUMBER;
22 
23   P_FROM_LOT VARCHAR2(80);
24 
25   LP_FROM_LOT VARCHAR2(80);
26 
27   P_TO_LOT VARCHAR2(80);
28 
29   LP_TO_LOT VARCHAR2(80);
30 
31   P_LEGAL_ENTITY_ID NUMBER;
32 
33   P_COST_TYPE_ID NUMBER;
34 
35   P_FROM_ORGANIZATION_ID NUMBER;
36 
37   P_TO_ORGANIZATION_ID NUMBER;
38 
39   P_FROM_ITEM_ID NUMBER;
40 
41   P_TO_ITEM_ID NUMBER;
42 
43   P_FROM_COST_CATEGORY_ID NUMBER;
44 
45   P_TO_COST_CATEGORY_ID NUMBER;
46 
47   P_CONC_REQUEST_ID NUMBER;
48 
49   P_STRUCTURE_ID NUMBER;
50 
51   P_ORGANIZATION_CONTEXT NUMBER;
52 
53   ORGANIZATIONCP VARCHAR2(500):=' ';
54 
55   ITEMCP VARCHAR2(500):=' ';
56 
57   COSTCATEGORYCP VARCHAR2(300):=' ';
58 
59   LOTCP VARCHAR2(400):=' ';
60 
61   FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
62 
63   FUNCTION ITEMCPFORMULA(ITEMCF IN VARCHAR2) RETURN VARCHAR2;
64 
65   FUNCTION ORGANIZATIONCPFORMULA(ORGANIZATIONCF IN VARCHAR2) RETURN VARCHAR2;
66 
67   FUNCTION ORGANIZATIONCFFORMULA RETURN VARCHAR2;
68 
69   FUNCTION COSTCATEGORYCFFORMULA RETURN VARCHAR2;
70 
71   FUNCTION ITEMCLASSCPFORMULA(COSTCATEGORYCF IN VARCHAR2) RETURN VARCHAR2;
72 
73   FUNCTION AFTERPFORM RETURN BOOLEAN;
74 
75   FUNCTION BASE_CURRCFFORMULA RETURN VARCHAR2;
76 
77   FUNCTION BEFOREREPORT RETURN BOOLEAN;
78 
79   PROCEDURE REPORT_HEADER;
80 
81   FUNCTION LEGAL_ENTITYCFFORMULA RETURN CHAR;
82 
83   FUNCTION COST_METHOD_CODECFFORMULA RETURN CHAR;
84 
85   FUNCTION LOTCPFORMULA(LOTCF IN NUMBER) RETURN CHAR;
86 
87   FUNCTION LOTCFFORMULA RETURN NUMBER;
88 
89   FUNCTION AFTERREPORT RETURN BOOLEAN;
90 
91   FUNCTION ORGANIZATIONCP_P RETURN VARCHAR2;
92 
93   FUNCTION ITEMCP_P RETURN VARCHAR2;
94 
95   FUNCTION COSTCATEGORYCP_P RETURN VARCHAR2;
96 
97   FUNCTION LOTCP_P RETURN VARCHAR2;
98 
99 END GMF_GMFLCDTL_XMLP_PKG;
100