DBA Data[Home] [Help]

PACKAGE BODY: APPS.PNRX_C_RENT_INCREASE_DETAILACC

Source


1 PACKAGE BODY pnrx_c_rent_increase_detailacc AS
2 /* $Header: PNRXCADB.pls 120.0 2007/10/03 14:25:45 rthumma noship $ */
3    PROCEDURE rent_increase_detailacc (
4       errbuf        OUT NOCOPY      VARCHAR2,
5       retcode       OUT NOCOPY      VARCHAR2,
6       argument1     IN              VARCHAR2, ---lease_number_low
7       argument2     IN              VARCHAR2, --lease_number_high
8       argument3     IN              VARCHAR2, -- from_Date
9       argument4     IN              VARCHAR2, -- to_date
10       argument5     IN              VARCHAR2, --
11       argument6     IN              VARCHAR2,
12       argument7     IN              VARCHAR2,
13       argument8     IN              VARCHAR2,
14       argument9     IN              VARCHAR2,
15       argument10    IN              VARCHAR2 DEFAULT NULL,
16       argument11    IN              VARCHAR2 DEFAULT NULL,
17       argument12    IN              VARCHAR2 DEFAULT NULL,
18       argument13    IN              VARCHAR2 DEFAULT NULL,
19       argument14    IN              VARCHAR2 DEFAULT NULL,
20       argument15    IN              VARCHAR2 DEFAULT NULL,
21       argument16    IN              VARCHAR2 DEFAULT NULL,
22       argument17    IN              VARCHAR2 DEFAULT NULL,
23       argument18    IN              VARCHAR2 DEFAULT NULL,
24       argument19    IN              VARCHAR2 DEFAULT NULL,
25       argument20    IN              VARCHAR2 DEFAULT NULL,
26       argument21    IN              VARCHAR2 DEFAULT NULL,
27       argument22    IN              VARCHAR2 DEFAULT NULL,
28       argument23    IN              VARCHAR2 DEFAULT NULL,
29       argument24    IN              VARCHAR2 DEFAULT NULL,
30       argument25    IN              VARCHAR2 DEFAULT NULL,
31       argument26    IN              VARCHAR2 DEFAULT NULL,
32       argument27    IN              VARCHAR2 DEFAULT NULL,
33       argument28    IN              VARCHAR2 DEFAULT NULL,
34       argument29    IN              VARCHAR2 DEFAULT NULL,
35       argument30    IN              VARCHAR2 DEFAULT NULL,
36       argument31    IN              VARCHAR2 DEFAULT NULL,
37       argument32    IN              VARCHAR2 DEFAULT NULL,
38       argument33    IN              VARCHAR2 DEFAULT NULL,
39       argument34    IN              VARCHAR2 DEFAULT NULL,
40       argument35    IN              VARCHAR2 DEFAULT NULL,
41       argument36    IN              VARCHAR2 DEFAULT NULL,
42       argument37    IN              VARCHAR2 DEFAULT NULL,
43       argument38    IN              VARCHAR2 DEFAULT NULL,
44       argument39    IN              VARCHAR2 DEFAULT NULL,
45       argument40    IN              VARCHAR2 DEFAULT NULL,
46       argument41    IN              VARCHAR2 DEFAULT NULL,
47       argument42    IN              VARCHAR2 DEFAULT NULL,
48       argument43    IN              VARCHAR2 DEFAULT NULL,
49       argument44    IN              VARCHAR2 DEFAULT NULL,
50       argument45    IN              VARCHAR2 DEFAULT NULL,
51       argument46    IN              VARCHAR2 DEFAULT NULL,
52       argument47    IN              VARCHAR2 DEFAULT NULL,
53       argument48    IN              VARCHAR2 DEFAULT NULL,
54       argument49    IN              VARCHAR2 DEFAULT NULL,
55       argument50    IN              VARCHAR2 DEFAULT NULL,
56       argument51    IN              VARCHAR2 DEFAULT NULL,
57       argument52    IN              VARCHAR2 DEFAULT NULL,
58       argument53    IN              VARCHAR2 DEFAULT NULL,
59       argument54    IN              VARCHAR2 DEFAULT NULL,
60       argument55    IN              VARCHAR2 DEFAULT NULL,
61       argument56    IN              VARCHAR2 DEFAULT NULL,
62       argument57    IN              VARCHAR2 DEFAULT NULL,
63       argument58    IN              VARCHAR2 DEFAULT NULL,
64       argument59    IN              VARCHAR2 DEFAULT NULL,
65       argument60    IN              VARCHAR2 DEFAULT NULL,
66       argument61    IN              VARCHAR2 DEFAULT NULL,
67       argument62    IN              VARCHAR2 DEFAULT NULL,
68       argument63    IN              VARCHAR2 DEFAULT NULL,
69       argument64    IN              VARCHAR2 DEFAULT NULL,
70       argument65    IN              VARCHAR2 DEFAULT NULL,
71       argument66    IN              VARCHAR2 DEFAULT NULL,
72       argument67    IN              VARCHAR2 DEFAULT NULL,
73       argument68    IN              VARCHAR2 DEFAULT NULL,
74       argument69    IN              VARCHAR2 DEFAULT NULL,
75       argument70    IN              VARCHAR2 DEFAULT NULL,
76       argument71    IN              VARCHAR2 DEFAULT NULL,
77       argument72    IN              VARCHAR2 DEFAULT NULL,
78       argument73    IN              VARCHAR2 DEFAULT NULL,
79       argument74    IN              VARCHAR2 DEFAULT NULL,
80       argument75    IN              VARCHAR2 DEFAULT NULL,
81       argument76    IN              VARCHAR2 DEFAULT NULL,
82       argument77    IN              VARCHAR2 DEFAULT NULL,
83       argument78    IN              VARCHAR2 DEFAULT NULL,
84       argument79    IN              VARCHAR2 DEFAULT NULL,
85       argument80    IN              VARCHAR2 DEFAULT NULL,
86       argument81    IN              VARCHAR2 DEFAULT NULL,
87       argument82    IN              VARCHAR2 DEFAULT NULL,
88       argument83    IN              VARCHAR2 DEFAULT NULL,
89       argument84    IN              VARCHAR2 DEFAULT NULL,
90       argument85    IN              VARCHAR2 DEFAULT NULL,
91       argument86    IN              VARCHAR2 DEFAULT NULL,
92       argument87    IN              VARCHAR2 DEFAULT NULL,
93       argument88    IN              VARCHAR2 DEFAULT NULL,
94       argument89    IN              VARCHAR2 DEFAULT NULL,
95       argument90    IN              VARCHAR2 DEFAULT NULL,
96       argument91    IN              VARCHAR2 DEFAULT NULL,
97       argument92    IN              VARCHAR2 DEFAULT NULL,
98       argument93    IN              VARCHAR2 DEFAULT NULL,
99       argument94    IN              VARCHAR2 DEFAULT NULL,
100       argument95    IN              VARCHAR2 DEFAULT NULL,
101       argument96    IN              VARCHAR2 DEFAULT NULL,
102       argument97    IN              VARCHAR2 DEFAULT NULL,
103       argument98    IN              VARCHAR2 DEFAULT NULL,
104       argument99    IN              VARCHAR2 DEFAULT NULL,
105       argument100   IN              VARCHAR2 DEFAULT NULL
106    )
107    IS
108       l_request_id   NUMBER;
109       l_user_id      NUMBER;
110    BEGIN
111       -- Populate mandatory parameters for request_id and user_id
112       l_request_id := fnd_global.conc_request_id;
113       fnd_profile.get ('USER_ID', l_user_id);
114       --Fnd_Profile.get('USER_ID', l_user_id);
115       fnd_file.put_line (fnd_file.LOG, 'arg1:' || argument1);
116       fnd_file.put_line (fnd_file.LOG, 'arg2:' || argument2);
117       fnd_file.put_line (fnd_file.LOG, 'arg3:' || argument3);
118       fnd_file.put_line (fnd_file.LOG, 'arg4:' || argument4);
119       -- Call the inner report passing mandatory parameters (and optional parameters if any)
120       pnrx_rent_increase_detailacc.rent_increase_detailacc (
121          p_lease_number_low       => argument1,
122          p_lease_number_high      => argument2,
123          p_ri_number_low          => argument3,
124          p_ri_number_high         => argument4,
125 	 p_assess_date_from       => fnd_date.canonical_to_date (argument5),
126 	 p_assess_date_to         => fnd_date.canonical_to_date(argument6),
127          p_location_id            => TO_NUMBER (argument7),
128          p_lease_class            => argument8,
129          p_property_id            => TO_NUMBER (argument9),
130          p_building_id            => TO_NUMBER (argument10),
131 	 p_include_draft          => argument11,
132          p_rent_type              => argument12,
133          p_account_class          => argument13,
134          p_set_of_books_id        => TO_NUMBER (argument14),
135          p_chart_of_accounts_id   => TO_NUMBER (argument15),
136          l_request_id             => TO_NUMBER (l_request_id),
137          l_user_id                => TO_NUMBER (l_user_id),
138          retcode                  => retcode,
139          errbuf                   => errbuf
140       );
141       COMMIT;
142    END rent_increase_detailacc;
143 END pnrx_c_rent_increase_detailacc;