[Home] [Help]
PACKAGE: APPS.GMF_CMR05USR_XMLP_PKG
Source
1 PACKAGE GMF_CMR05USR_XMLP_PKG 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