1 PACKAGE IGI_IGIIAOPE_XMLP_PKG AS
2 /* $Header: IGIIAOPES.pls 120.0.12010000.1 2008/07/29 08:58:37 appldev ship $ */
3 P_BOOK VARCHAR2(15);
4
5 P_COMPANY1 VARCHAR2(40);
6
7 DO_INSERT number;
8 P_COMPANY2 VARCHAR2(40);
9
10 P_COST_CENTER1 VARCHAR2(40);
11
12 P_COST_CENTER2 VARCHAR2(40);
13
14 P_ACCOUNT1 VARCHAR2(40);
15
16 P_ACCOUNT2 VARCHAR2(40);
17
18 P_CONC_REQUEST_ID NUMBER;
19
20 P_PERIOD1 VARCHAR2(15);
21
22 P_PERIOD2 VARCHAR2(15);
23
24 P_REPORT_TYPE VARCHAR2(15);
25
26 ACCT_BAL_APROMPT VARCHAR2(222);
27
28 ACCT_CC_APROMPT VARCHAR2(222);
29
30 RP_BAL_LPROMPT VARCHAR2(222);
31
32 RP_CC_APROMPT VARCHAR2(222);
33
34 RP_COMPANY_NAME VARCHAR2(30);
35
36 RP_REPORT_NAME VARCHAR2(80);
37
38 RP_CC_LPROMPT VARCHAR2(80);
39
40 FUNCTION DO_INSERTFORMULA RETURN NUMBER;
41
42 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2
43 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
44
45 FUNCTION COST_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
46 ,ADDITION IN NUMBER) RETURN NUMBER;
47
48 FUNCTION COST_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
49 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
50
51 FUNCTION COST_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
52 ,REVALUATION IN NUMBER) RETURN NUMBER;
53
54 FUNCTION COST_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
55 ,RECLASS IN NUMBER) RETURN NUMBER;
56
57 FUNCTION COST_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
58 ,TRANSFER IN NUMBER) RETURN NUMBER;
59
60 FUNCTION BLOG_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
61 ,ADDITION IN NUMBER) RETURN NUMBER;
62
63 FUNCTION BLOG_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
64 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
65
66 FUNCTION BLOG_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
67 ,REVALUATION IN NUMBER) RETURN NUMBER;
68
69 FUNCTION BLOG_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
70 ,RECLASS IN NUMBER) RETURN NUMBER;
71
72 FUNCTION BLOG_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2) RETURN NUMBER;
73
74 FUNCTION NET_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
75 ,ADDITION IN NUMBER) RETURN NUMBER;
76
77 FUNCTION NET_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
78 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
79
80 FUNCTION NET_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
81 ,REVALUATION IN NUMBER) RETURN NUMBER;
82
83 FUNCTION NET_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
84 ,RECLASS IN NUMBER) RETURN NUMBER;
85
86 FUNCTION NET_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
87 ,TRANSFER IN NUMBER) RETURN NUMBER;
88
89 FUNCTION BEFOREREPORT RETURN BOOLEAN;
90
91 FUNCTION AFTERREPORT RETURN BOOLEAN;
92
93 FUNCTION COST_MOVEMENTFORMULA(BALANCE_TYPE IN VARCHAR2
94 ,ADDITION IN NUMBER
95 ,ADJUSTMENT IN NUMBER
96 ,RECLASS IN NUMBER
97 ,REVALUATION IN NUMBER
98 ,CC_COST_TRANSFER IN NUMBER) RETURN NUMBER;
99
100 FUNCTION BLOG_MOVEMENTFORMULA(BALANCE_TYPE IN VARCHAR2
101 ,ADDITION IN NUMBER
102 ,ADJUSTMENT IN NUMBER
103 ,RECLASS IN NUMBER
104 ,REVALUATION IN NUMBER) RETURN NUMBER;
105
106 FUNCTION NET_MOVEMENTFORMULA(BALANCE_TYPE IN VARCHAR2
107 ,ADDITION IN NUMBER
108 ,ADJUSTMENT IN NUMBER
109 ,RECLASS IN NUMBER
110 ,REVALUATION IN NUMBER
111 ,TRANSFER IN NUMBER) RETURN NUMBER;
112
113 FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
114
115 FUNCTION ACCT_CC_APROMPT_P RETURN VARCHAR2;
116
117 FUNCTION RP_BAL_LPROMPT_P RETURN VARCHAR2;
118
119 FUNCTION RP_CC_APROMPT_P RETURN VARCHAR2;
120
121 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
122
123 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
124
125 FUNCTION RP_CC_LPROMPT_P RETURN VARCHAR2;
126
127 END IGI_IGIIAOPE_XMLP_PKG;