eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_POPDATES_PKG dependencies on BIM_INTL_DATES

Line 83: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_intl_dates';

79:
80: BEGIN
81: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
82:
83: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_intl_dates';
84:
85: OPEN max_gl_date;
86: FETCH max_gl_date into l_date;
87: CLOSE max_gl_date;

Line 107: INTO BIM_INTL_DATES fdf (

103: --ams_utility_pvt.write_conc_log('Before the loop');
104: WHILE l_min_date < l_end_date+1 LOOP
105: BEGIN
106: INSERT
107: INTO BIM_INTL_DATES fdf (
108: TRDATE
109: ,FISCAL_MONTH
110: ,MONTH_FLAG
111: ,FISCAL_QTR

Line 162: ams_utility_pvt.write_conc_log('Error inserting bim_intl_dates ' || sqlerrm(sqlcode));

158: FROM DUAL;
159: l_min_date := l_min_date +1;
160: EXCEPTION
161: WHEN OTHERS THEN
162: ams_utility_pvt.write_conc_log('Error inserting bim_intl_dates ' || sqlerrm(sqlcode));
163: RAISE FND_API.g_exc_error;
164: END;
165: END LOOP;
166: --ams_utility_pvt.write_conc_log('After the loop');

Line 169: update bim_intl_dates p set month_flag = 'Y'

165: END LOOP;
166: --ams_utility_pvt.write_conc_log('After the loop');
167: --ams_utility_pvt.write_conc_log('Update the month flag');
168: BEGIN
169: update bim_intl_dates p set month_flag = 'Y'
170: where p.trdate in (SELECT min(trdate)
171: FROM bim_intl_dates
172: GROUP BY fiscal_month);
173: EXCEPTION

Line 171: FROM bim_intl_dates

167: --ams_utility_pvt.write_conc_log('Update the month flag');
168: BEGIN
169: update bim_intl_dates p set month_flag = 'Y'
170: where p.trdate in (SELECT min(trdate)
171: FROM bim_intl_dates
172: GROUP BY fiscal_month);
173: EXCEPTION
174: WHEN OTHERS THEN
175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

Line 175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

171: FROM bim_intl_dates
172: GROUP BY fiscal_month);
173: EXCEPTION
174: WHEN OTHERS THEN
175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
176: RAISE FND_API.g_exc_error;
177: END;
178:
179: --ams_utility_pvt.write_conc_log('Update the quarter flag');

Line 181: update bim_intl_dates p set qtr_flag = 'Y'

177: END;
178:
179: --ams_utility_pvt.write_conc_log('Update the quarter flag');
180: BEGIN
181: update bim_intl_dates p set qtr_flag = 'Y'
182: where p.trdate in (SELECT min(trdate)
183: FROM bim_intl_dates
184: GROUP BY fiscal_qtr);
185: EXCEPTION

Line 183: FROM bim_intl_dates

179: --ams_utility_pvt.write_conc_log('Update the quarter flag');
180: BEGIN
181: update bim_intl_dates p set qtr_flag = 'Y'
182: where p.trdate in (SELECT min(trdate)
183: FROM bim_intl_dates
184: GROUP BY fiscal_qtr);
185: EXCEPTION
186: WHEN OTHERS THEN
187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

Line 187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

183: FROM bim_intl_dates
184: GROUP BY fiscal_qtr);
185: EXCEPTION
186: WHEN OTHERS THEN
187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
188: RAISE FND_API.g_exc_error;
189: END;
190: --ams_utility_pvt.write_conc_log('Update the year flag');
191: BEGIN

Line 192: update bim_intl_dates p set year_flag = 'Y'

188: RAISE FND_API.g_exc_error;
189: END;
190: --ams_utility_pvt.write_conc_log('Update the year flag');
191: BEGIN
192: update bim_intl_dates p set year_flag = 'Y'
193: where p.trdate in (SELECT min(trdate)
194: FROM bim_intl_dates
195: GROUP BY fiscal_year);
196: EXCEPTION

Line 194: FROM bim_intl_dates

190: --ams_utility_pvt.write_conc_log('Update the year flag');
191: BEGIN
192: update bim_intl_dates p set year_flag = 'Y'
193: where p.trdate in (SELECT min(trdate)
194: FROM bim_intl_dates
195: GROUP BY fiscal_year);
196: EXCEPTION
197: WHEN OTHERS THEN
198: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

Line 198: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

194: FROM bim_intl_dates
195: GROUP BY fiscal_year);
196: EXCEPTION
197: WHEN OTHERS THEN
198: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
199: RAISE FND_API.g_exc_error;
200: END;
201:
202: DELETE FROM bim_rep_history