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