DBA Data[Home] [Help]

PACKAGE: APPS.GMF_CMR05USR_XMLP_PKG

Source


1 PACKAGE GMF_CMR05USR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CMR05USRS.pls 120.0 2007/12/24 13:19:58 nchinnam noship $ */
3   P_CALENDAR VARCHAR2(10);
4 
5   P_PERIOD_CODE VARCHAR2(10);
6 
7   FROM_ORGN VARCHAR2(3);
8 
9   TO_ORGN VARCHAR2(3);
10 
11   FROM_ITEM VARCHAR2(2000);
12 
13   TO_ITEM VARCHAR2(2000);
14 
15   FROM_COST_CATEGORY VARCHAR2(2000);
16 
17   TO_COST_CATEGORY VARCHAR2(2000);
18 
19   SY_ALL VARCHAR2(3);
20 
21   NONBLOCKSQL VARCHAR2(5);
22 
23   P_CURRENCY_CODE VARCHAR2(4);
24 
25   LP_CURRENCY_CODE VARCHAR2(4);
26 
27   P_EXCHANGE_RATE NUMBER;
28 
29   LP_EXCHANGE_RATE NUMBER;
30 
31   P_COST_TYPE_ID VARCHAR2(15);
32 
33   P_LEGAL_ENTITY_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_CATEGORY_STRUCTURE_ID NUMBER;
50 
51   ORGANIZATIONCP VARCHAR2(500);
52 
53   ITEMCP VARCHAR2(500);
54 
55   COSTCATEGORYCP VARCHAR2(300);
56 
57   FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
58 
59   FUNCTION ITEMCPFORMULA(ITEMCF IN VARCHAR2) RETURN VARCHAR2;
60 
61   FUNCTION ORGANIZATIONCPFORMULA(ORGANIZATIONCF IN VARCHAR2) RETURN VARCHAR2;
62 
63   FUNCTION ORGANIZATIONCFFORMULA RETURN VARCHAR2;
64 
65   FUNCTION COSTCATEGORYCFFORMULA RETURN VARCHAR2;
66 
67   FUNCTION COSTCATEGORYCPFORMULA(COSTCATEGORYCF IN VARCHAR2) RETURN VARCHAR2;
68 
69   FUNCTION AFTERPFORM RETURN BOOLEAN;
70 
71   FUNCTION BASE_CURRCFFORMULA RETURN VARCHAR2;
72 
73   PROCEDURE GMF_CMR05USR_XMLP_PKG_HEADER;
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   PROCEDURE REPORT_HEADER;
78 
79   FUNCTION PERIOD_IDFORMULA RETURN NUMBER;
80 
81   FUNCTION COST_MTHD_CODEFORMULA RETURN CHAR;
82 
83   FUNCTION LEGAL_ENTITYCFFORMULA RETURN CHAR;
84 
85   FUNCTION AFTERREPORT RETURN BOOLEAN;
86 
87   FUNCTION ORGANIZATIONCP_P RETURN VARCHAR2;
88 
89   FUNCTION ITEMCP_P RETURN VARCHAR2;
90 
91   FUNCTION COSTCATEGORYCP_P RETURN VARCHAR2;
92 
93 END GMF_CMR05USR_XMLP_PKG;
94