[Home] [Help]
PACKAGE BODY: APPS.IGI_IAC_RXI_O_WRAP_ASSET_BAL
Source
1 PACKAGE BODY igi_iac_rxi_o_wrap_asset_bal AS
2 /* $Header: igiiaxbb.pls 120.1.12000000.1 2007/08/01 16:20:00 npandya noship $ */
3
4 --===========================FND_LOG.START=====================================
5
6 g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7 g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8 g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9 g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10 g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11 g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12 g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaxbb.igi_iac_rxi_o_wrap_asset_bal.';
13
14 --===========================FND_LOG.END=======================================
15
16
17 PROCEDURE start_rx_process (
18 errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY VARCHAR2,
20 argument1 IN VARCHAR2, -- report short name
21 argument2 IN VARCHAR2, -- Book Type Code
22 argument3 IN VARCHAR2, -- Period Counter
23 argument4 IN VARCHAR2, -- Category Struct Id
24 argument5 IN VARCHAR2, -- Category Id
25 argument6 IN VARCHAR2 DEFAULT NULL, -- Chart Of Accounts
26 argument7 IN VARCHAR2 DEFAULT NULL, -- From Cost Center
27 argument8 IN VARCHAR2 DEFAULT NULL, -- To Cost Center
28 argument9 IN VARCHAR2 DEFAULT NULL, -- From Asset
29 argument10 IN VARCHAR2 DEFAULT NULL, -- To Asset
30 argument11 IN VARCHAR2 DEFAULT NULL,
31 argument12 IN VARCHAR2 DEFAULT NULL,
32 argument13 IN VARCHAR2 DEFAULT NULL,
33 argument14 IN VARCHAR2 DEFAULT NULL,
34 argument15 IN VARCHAR2 DEFAULT NULL,
35 argument16 IN VARCHAR2 DEFAULT NULL,
36 argument17 IN VARCHAR2 DEFAULT NULL,
37 argument18 IN VARCHAR2 DEFAULT NULL,
38 argument19 IN VARCHAR2 DEFAULT NULL,
39 argument20 IN VARCHAR2 DEFAULT NULL,
40 argument21 IN VARCHAR2 DEFAULT NULL,
41 argument22 IN VARCHAR2 DEFAULT NULL,
42 argument23 IN VARCHAR2 DEFAULT NULL,
43 argument24 IN VARCHAR2 DEFAULT NULL,
44 argument25 IN VARCHAR2 DEFAULT NULL,
45 argument26 IN VARCHAR2 DEFAULT NULL,
46 argument27 IN VARCHAR2 DEFAULT NULL,
47 argument28 IN VARCHAR2 DEFAULT NULL,
48 argument29 IN VARCHAR2 DEFAULT NULL,
49 argument30 IN VARCHAR2 DEFAULT NULL,
50 argument31 IN VARCHAR2 DEFAULT NULL,
51 argument32 IN VARCHAR2 DEFAULT NULL,
52 argument33 IN VARCHAR2 DEFAULT NULL,
53 argument34 IN VARCHAR2 DEFAULT NULL,
54 argument35 IN VARCHAR2 DEFAULT NULL,
55 argument36 IN VARCHAR2 DEFAULT NULL,
56 argument37 IN VARCHAR2 DEFAULT NULL,
57 argument38 IN VARCHAR2 DEFAULT NULL,
58 argument39 IN VARCHAR2 DEFAULT NULL,
59 argument40 IN VARCHAR2 DEFAULT NULL,
60 argument41 IN VARCHAR2 DEFAULT NULL,
61 argument42 IN VARCHAR2 DEFAULT NULL,
62 argument43 IN VARCHAR2 DEFAULT NULL,
63 argument44 IN VARCHAR2 DEFAULT NULL,
64 argument45 IN VARCHAR2 DEFAULT NULL,
65 argument46 IN VARCHAR2 DEFAULT NULL,
66 argument47 IN VARCHAR2 DEFAULT NULL,
67 argument48 IN VARCHAR2 DEFAULT NULL,
68 argument49 IN VARCHAR2 DEFAULT NULL,
69 argument50 IN VARCHAR2 DEFAULT NULL,
70 argument51 IN VARCHAR2 DEFAULT NULL,
71 argument52 IN VARCHAR2 DEFAULT NULL,
72 argument53 IN VARCHAR2 DEFAULT NULL,
73 argument54 IN VARCHAR2 DEFAULT NULL,
74 argument55 IN VARCHAR2 DEFAULT NULL,
75 argument56 IN VARCHAR2 DEFAULT NULL,
76 argument57 IN VARCHAR2 DEFAULT NULL,
77 argument58 IN VARCHAR2 DEFAULT NULL,
78 argument59 IN VARCHAR2 DEFAULT NULL,
79 argument60 IN VARCHAR2 DEFAULT NULL,
80 argument61 IN VARCHAR2 DEFAULT NULL,
81 argument62 IN VARCHAR2 DEFAULT NULL,
82 argument63 IN VARCHAR2 DEFAULT NULL,
83 argument64 IN VARCHAR2 DEFAULT NULL,
84 argument65 IN VARCHAR2 DEFAULT NULL,
85 argument66 IN VARCHAR2 DEFAULT NULL,
86 argument67 IN VARCHAR2 DEFAULT NULL,
87 argument68 IN VARCHAR2 DEFAULT NULL,
88 argument69 IN VARCHAR2 DEFAULT NULL,
89 argument70 IN VARCHAR2 DEFAULT NULL,
90 argument71 IN VARCHAR2 DEFAULT NULL,
91 argument72 IN VARCHAR2 DEFAULT NULL,
92 argument73 IN VARCHAR2 DEFAULT NULL,
93 argument74 IN VARCHAR2 DEFAULT NULL,
94 argument75 IN VARCHAR2 DEFAULT NULL,
95 argument76 IN VARCHAR2 DEFAULT NULL,
96 argument77 IN VARCHAR2 DEFAULT NULL,
97 argument78 IN VARCHAR2 DEFAULT NULL,
98 argument79 IN VARCHAR2 DEFAULT NULL,
99 argument80 IN VARCHAR2 DEFAULT NULL,
100 argument81 IN VARCHAR2 DEFAULT NULL,
101 argument82 IN VARCHAR2 DEFAULT NULL,
102 argument83 IN VARCHAR2 DEFAULT NULL,
103 argument84 IN VARCHAR2 DEFAULT NULL,
104 argument85 IN VARCHAR2 DEFAULT NULL,
105 argument86 IN VARCHAR2 DEFAULT NULL,
106 argument87 IN VARCHAR2 DEFAULT NULL,
107 argument88 IN VARCHAR2 DEFAULT NULL,
108 argument89 IN VARCHAR2 DEFAULT NULL,
109 argument90 IN VARCHAR2 DEFAULT NULL,
110 argument91 IN VARCHAR2 DEFAULT NULL,
111 argument92 IN VARCHAR2 DEFAULT NULL,
112 argument93 IN VARCHAR2 DEFAULT NULL,
113 argument94 IN VARCHAR2 DEFAULT NULL,
114 argument95 IN VARCHAR2 DEFAULT NULL,
115 argument96 IN VARCHAR2 DEFAULT NULL,
116 argument97 IN VARCHAR2 DEFAULT NULL,
117 argument98 IN VARCHAR2 DEFAULT NULL,
118 argument99 IN VARCHAR2 DEFAULT NULL,
119 argument100 IN VARCHAR2 DEFAULT NULL) IS
120
121 l_request_id NUMBER;
122 h_err_msg VARCHAR2(2000);
123
124 l_path VARCHAR2(150) := g_path||'start_rx_process';
125 BEGIN
126
127
128
129 igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Have reached outer package');
130
131 l_request_id := fnd_global.conc_request_id;
132
133 igi_iac_rxi_i_wrap_Asset_bal.run_report
134 ( p_reptShrtName => argument1,
135 p_bookType => argument2,
136 p_period => argument3,
137 p_categoryId => argument5,
138 p_chartOfAccts => argument6,
139 p_from_cc => argument7,
140 p_to_cc => argument8,
141 p_from_asset_num => argument9,
142 p_to_asset_num => argument10,
143 p_request_id => l_request_id,
144 p_retcode => retcode,
145 p_errbuf => errbuf);
146
147 retcode := 0;
148
149
150 EXCEPTION WHEN OTHERS THEN
151 igi_iac_debug_pkg.debug_unexpected_msg(l_path);
152 retcode := 2;
153
154 END start_rx_process;
155
156 END igi_iac_rxi_o_wrap_asset_bal;