[Home] [Help]
PACKAGE BODY: APPS.JGRX_C_FAREG
Source
1 PACKAGE BODY JGRX_C_FAREG AS
2 /* $Header: jgrxcfrb.pls 115.2 2000/08/29 16:20:00 pkm ship $ */
3
4 -- FA Register core Report
5
6 PROCEDURE get_asset_rtrmnt_details(
7 errbuf OUT VARCHAR2,
8 retcode OUT VARCHAR2,
9 argument1 IN VARCHAR2, -- Book Type
10 argument2 IN VARCHAR2, -- From Period
11 argument3 IN VARCHAR2, -- To Period
12 argument4 IN VARCHAR2, -- Dummy
13 argument5 IN VARCHAR2, -- Major Categoy
14 argument6 IN VARCHAR2, -- Minor Category
15 argument7 IN VARCHAR2, -- Report Type
16 argument8 IN VARCHAR2, -- debug_flag
17 argument9 IN VARCHAR2, -- sql_trace
18 argument10 IN VARCHAR2 DEFAULT NULL,
19 argument11 IN VARCHAR2 DEFAULT NULL,
20 argument12 IN VARCHAR2 DEFAULT NULL,
21 argument13 IN VARCHAR2 DEFAULT NULL,
22 argument14 IN VARCHAR2 DEFAULT NULL,
23 argument15 IN VARCHAR2 DEFAULT NULL,
24 argument16 IN VARCHAR2 DEFAULT NULL,
25 argument17 IN VARCHAR2 DEFAULT NULL,
26 argument18 IN VARCHAR2 DEFAULT NULL,
27 argument19 IN VARCHAR2 DEFAULT NULL,
28 argument20 IN VARCHAR2 DEFAULT NULL,
29 argument21 IN VARCHAR2 DEFAULT NULL,
30 argument22 IN VARCHAR2 DEFAULT NULL,
31 argument23 IN VARCHAR2 DEFAULT NULL,
32 argument24 IN VARCHAR2 DEFAULT NULL,
33 argument25 IN VARCHAR2 DEFAULT NULL,
34 argument26 IN VARCHAR2 DEFAULT NULL,
35 argument27 IN VARCHAR2 DEFAULT NULL,
36 argument28 IN VARCHAR2 DEFAULT NULL,
37 argument29 IN VARCHAR2 DEFAULT NULL,
38 argument30 IN VARCHAR2 DEFAULT NULL,
39 argument31 IN VARCHAR2 DEFAULT NULL,
40 argument32 IN VARCHAR2 DEFAULT NULL,
41 argument33 IN VARCHAR2 DEFAULT NULL,
42 argument34 IN VARCHAR2 DEFAULT NULL,
43 argument35 IN VARCHAR2 DEFAULT NULL,
44 argument36 IN VARCHAR2 DEFAULT NULL,
45 argument37 IN VARCHAR2 DEFAULT NULL,
46 argument38 IN VARCHAR2 DEFAULT NULL,
47 argument39 IN VARCHAR2 DEFAULT NULL,
48 argument40 IN VARCHAR2 DEFAULT NULL,
49 argument41 IN VARCHAR2 DEFAULT NULL,
50 argument42 IN VARCHAR2 DEFAULT NULL,
51 argument43 IN VARCHAR2 DEFAULT NULL,
52 argument44 IN VARCHAR2 DEFAULT NULL,
53 argument45 IN VARCHAR2 DEFAULT NULL,
54 argument46 IN VARCHAR2 DEFAULT NULL,
55 argument47 IN VARCHAR2 DEFAULT NULL,
56 argument48 IN VARCHAR2 DEFAULT NULL,
57 argument49 IN VARCHAR2 DEFAULT NULL,
58 argument50 IN VARCHAR2 DEFAULT NULL,
59 argument51 IN VARCHAR2 DEFAULT NULL,
60 argument52 IN VARCHAR2 DEFAULT NULL,
61 argument53 IN VARCHAR2 DEFAULT NULL,
62 argument54 IN VARCHAR2 DEFAULT NULL,
63 argument55 IN VARCHAR2 DEFAULT NULL,
64 argument56 IN VARCHAR2 DEFAULT NULL,
65 argument57 IN VARCHAR2 DEFAULT NULL,
66 argument58 IN VARCHAR2 DEFAULT NULL,
67 argument59 IN VARCHAR2 DEFAULT NULL,
68 argument60 IN VARCHAR2 DEFAULT NULL,
69 argument61 IN VARCHAR2 DEFAULT NULL,
70 argument62 IN VARCHAR2 DEFAULT NULL,
71 argument63 IN VARCHAR2 DEFAULT NULL,
72 argument64 IN VARCHAR2 DEFAULT NULL,
73 argument65 IN VARCHAR2 DEFAULT NULL,
74 argument66 IN VARCHAR2 DEFAULT NULL,
75 argument67 IN VARCHAR2 DEFAULT NULL,
76 argument68 IN VARCHAR2 DEFAULT NULL,
77 argument69 IN VARCHAR2 DEFAULT NULL,
78 argument70 IN VARCHAR2 DEFAULT NULL,
79 argument71 IN VARCHAR2 DEFAULT NULL,
80 argument72 IN VARCHAR2 DEFAULT NULL,
81 argument73 IN VARCHAR2 DEFAULT NULL,
82 argument74 IN VARCHAR2 DEFAULT NULL,
83 argument75 IN VARCHAR2 DEFAULT NULL,
84 argument76 IN VARCHAR2 DEFAULT NULL,
85 argument77 IN VARCHAR2 DEFAULT NULL,
86 argument78 IN VARCHAR2 DEFAULT NULL,
87 argument79 IN VARCHAR2 DEFAULT NULL,
88 argument80 IN VARCHAR2 DEFAULT NULL,
89 argument81 IN VARCHAR2 DEFAULT NULL,
90 argument82 IN VARCHAR2 DEFAULT NULL,
91 argument83 IN VARCHAR2 DEFAULT NULL,
92 argument84 IN VARCHAR2 DEFAULT NULL,
93 argument85 IN VARCHAR2 DEFAULT NULL,
94 argument86 IN VARCHAR2 DEFAULT NULL,
95 argument87 IN VARCHAR2 DEFAULT NULL,
96 argument88 IN VARCHAR2 DEFAULT NULL,
97 argument89 IN VARCHAR2 DEFAULT NULL,
98 argument90 IN VARCHAR2 DEFAULT NULL,
99 argument91 IN VARCHAR2 DEFAULT NULL,
100 argument92 IN VARCHAR2 DEFAULT NULL,
101 argument93 IN VARCHAR2 DEFAULT NULL,
102 argument94 IN VARCHAR2 DEFAULT NULL,
103 argument95 IN VARCHAR2 DEFAULT NULL,
104 argument96 IN VARCHAR2 DEFAULT NULL,
105 argument97 IN VARCHAR2 DEFAULT NULL,
106 argument98 IN VARCHAR2 DEFAULT NULL,
107 argument99 IN VARCHAR2 DEFAULT NULL,
108 argument100 IN VARCHAR2 DEFAULT NULL)
109 IS
110 l_request_id NUMBER;
111 debug_flag VARCHAR2(1);
112 sql_trace VARCHAR2(1);
113
114 BEGIN
115 --
116 -- Assign parameters doing any necessary mappings
117 -- e.g. date/number conversion
118 l_request_id := FND_GLOBAL.conc_request_id;
119 debug_flag := UPPER(SUBSTRB(argument8,1,1));
120 sql_trace := UPPER(SUBSTRB(argument9,1,1));
121
122 --
123 -- SQL Trace switches and debug flags are optional
124 -- but highly recommended.
125 IF sql_trace = 'Y' then
126 FA_RX_UTIL_PKG.enable_trace;
127 END IF;
128 IF debug_flag = 'Y' then
129 FA_RX_UTIL_PKG.enable_debug;
130 END IF;
131
132 --
133 -- Run report
134 JGRX_FAREG.fa_get_report(
135 argument1,
136 argument2,
137 argument3,
138 argument4,
139 argument5,
140 argument6,
141 argument7,
142 l_request_id,
143 retcode,
144 errbuf);
145
146 END get_asset_rtrmnt_details;
147
148 END JGRX_C_FAREG;