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.PSB_WS_ACCT2 dependencies on DBMS_SQL

Line 198: l_start_date_tbl dbms_sql.date_table;

194:
195: num_balances INTEGER;
196:
197: /* START BUG 4256345 */
198: l_start_date_tbl dbms_sql.date_table;
199: l_end_date_tbl dbms_sql.date_table;
200: l_period_amount_tbl dbms_sql.number_table;
201: /* end bug 4256345 */
202:

Line 199: l_end_date_tbl dbms_sql.date_table;

195: num_balances INTEGER;
196:
197: /* START BUG 4256345 */
198: l_start_date_tbl dbms_sql.date_table;
199: l_end_date_tbl dbms_sql.date_table;
200: l_period_amount_tbl dbms_sql.number_table;
201: /* end bug 4256345 */
202:
203: /* Bug No 4725091 */

Line 200: l_period_amount_tbl dbms_sql.number_table;

196:
197: /* START BUG 4256345 */
198: l_start_date_tbl dbms_sql.date_table;
199: l_end_date_tbl dbms_sql.date_table;
200: l_period_amount_tbl dbms_sql.number_table;
201: /* end bug 4256345 */
202:
203: /* Bug No 4725091 */
204: l_fwd_bal_amt_tbl dbms_sql.number_table;

Line 204: l_fwd_bal_amt_tbl dbms_sql.number_table;

200: l_period_amount_tbl dbms_sql.number_table;
201: /* end bug 4256345 */
202:
203: /* Bug No 4725091 */
204: l_fwd_bal_amt_tbl dbms_sql.number_table;
205:
206: -- Bug#5030613 Start
207: l_commit_enc_type_id NUMBER;
208: l_oblig_enc_type_id NUMBER;

Line 243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);

239: end if;
240: /* end bug 4256345 */
241:
242:
243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);
244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);

Line 244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613

240: /* end bug 4256345 */
241:
242:
243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);
244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);

Line 245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);

241:
242:
243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);
244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);
249:

Line 246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);

242:
243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);
244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);
249:
250: if p_gl_budget_set_id is not null then

Line 247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);

243: dbms_sql.bind_variable(g_cur_budget_balance, ':CCID', p_ccid);
244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);
249:
250: if p_gl_budget_set_id is not null then
251: dbms_sql.bind_variable(g_cur_budget_balance, ':BUDGET_VERSION_ID', p_budget_version_id);

Line 248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);

244: dbms_sql.bind_variable(g_cur_budget_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
245: dbms_sql.bind_variable(g_cur_budget_balance, ':ACCOUNT_TYPE', p_account_type);
246: dbms_sql.bind_variable(g_cur_budget_balance, ':CURRENCY_CODE', p_currency_code);
247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);
249:
250: if p_gl_budget_set_id is not null then
251: dbms_sql.bind_variable(g_cur_budget_balance, ':BUDGET_VERSION_ID', p_budget_version_id);
252: end if;

Line 251: dbms_sql.bind_variable(g_cur_budget_balance, ':BUDGET_VERSION_ID', p_budget_version_id);

247: dbms_sql.bind_variable(g_cur_budget_balance, ':START_DATE', p_start_date);
248: dbms_sql.bind_variable(g_cur_budget_balance, ':END_DATE', p_end_date);
249:
250: if p_gl_budget_set_id is not null then
251: dbms_sql.bind_variable(g_cur_budget_balance, ':BUDGET_VERSION_ID', p_budget_version_id);
252: end if;
253:
254: /* start bug 4256345 */
255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);

Line 255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);

251: dbms_sql.bind_variable(g_cur_budget_balance, ':BUDGET_VERSION_ID', p_budget_version_id);
252: end if;
253:
254: /* start bug 4256345 */
255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);
256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);
257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);

Line 256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);

252: end if;
253:
254: /* start bug 4256345 */
255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);
256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);
257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);
260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);

Line 257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */

253:
254: /* start bug 4256345 */
255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);
256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);
257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);
260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);
261: dbms_sql.define_array(g_cur_budget_balance, 3, l_period_amount_tbl, 100, 1);

Line 259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);

255: /* dbms_sql.define_column(g_cur_budget_balance, 1, l_start_date);
256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);
257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);
260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);
261: dbms_sql.define_array(g_cur_budget_balance, 3, l_period_amount_tbl, 100, 1);
262:
263: /* end bug 4256345 */

Line 260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);

256: dbms_sql.define_column(g_cur_budget_balance, 2, l_end_date);
257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);
260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);
261: dbms_sql.define_array(g_cur_budget_balance, 3, l_period_amount_tbl, 100, 1);
262:
263: /* end bug 4256345 */
264:

Line 261: dbms_sql.define_array(g_cur_budget_balance, 3, l_period_amount_tbl, 100, 1);

257: dbms_sql.define_column(g_cur_budget_balance, 3, l_period_amount); */
258:
259: dbms_sql.define_array(g_cur_budget_balance, 1, l_Start_date_tbl, 100, 1);
260: dbms_sql.define_array(g_cur_budget_balance, 2, l_end_date_tbl, 100, 1);
261: dbms_sql.define_array(g_cur_budget_balance, 3, l_period_amount_tbl, 100, 1);
262:
263: /* end bug 4256345 */
264:
265: /* bug no 4725091 */

Line 266: dbms_sql.define_array(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl, 100, 1);

262:
263: /* end bug 4256345 */
264:
265: /* bug no 4725091 */
266: dbms_sql.define_array(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl, 100, 1);
267:
268: num_balances := dbms_sql.execute(g_cur_budget_balance);
269:
270: loop

Line 268: num_balances := dbms_sql.execute(g_cur_budget_balance);

264:
265: /* bug no 4725091 */
266: dbms_sql.define_array(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl, 100, 1);
267:
268: num_balances := dbms_sql.execute(g_cur_budget_balance);
269:
270: loop
271: /* start bug 4256345 */
272: /* if dbms_sql.fetch_rows(g_cur_budget_balance) = 0 then

Line 272: /* if dbms_sql.fetch_rows(g_cur_budget_balance) = 0 then

268: num_balances := dbms_sql.execute(g_cur_budget_balance);
269:
270: loop
271: /* start bug 4256345 */
272: /* if dbms_sql.fetch_rows(g_cur_budget_balance) = 0 then
273: exit;
274: end if; */
275: num_balances := dbms_sql.fetch_rows(g_cur_budget_balance);
276:

Line 275: num_balances := dbms_sql.fetch_rows(g_cur_budget_balance);

271: /* start bug 4256345 */
272: /* if dbms_sql.fetch_rows(g_cur_budget_balance) = 0 then
273: exit;
274: end if; */
275: num_balances := dbms_sql.fetch_rows(g_cur_budget_balance);
276:
277:
278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);
279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);

Line 278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);

274: end if; */
275: num_balances := dbms_sql.fetch_rows(g_cur_budget_balance);
276:
277:
278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);
279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);
280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);

Line 279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);

275: num_balances := dbms_sql.fetch_rows(g_cur_budget_balance);
276:
277:
278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);
279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);
280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);
283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);

Line 280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */

276:
277:
278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);
279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);
280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);
283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);
284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);

Line 282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);

278: /* dbms_sql.column_value(g_cur_budget_balance, 1, l_start_date);
279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);
280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);
283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);
284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);
285:
286: /* bug no 4725091 */

Line 283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);

279: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date);
280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);
283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);
284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);
285:
286: /* bug no 4725091 */
287: dbms_sql.column_value(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl);

Line 284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);

280: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount); */
281:
282: dbms_sql.column_value(g_cur_budget_balance, 1, l_Start_date_tbl);
283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);
284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);
285:
286: /* bug no 4725091 */
287: dbms_sql.column_value(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl);
288:

Line 287: dbms_sql.column_value(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl);

283: dbms_sql.column_value(g_cur_budget_balance, 2, l_end_date_tbl);
284: dbms_sql.column_value(g_cur_budget_balance, 3, l_period_amount_tbl);
285:
286: /* bug no 4725091 */
287: dbms_sql.column_value(g_cur_budget_balance, 4, l_fwd_bal_amt_tbl);
288:
289: for l_date_index in 1..l_start_date_tbl.count loop
290: for l_period_index in 1..g_num_budget_periods loop
291:

Line 333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);

329: end;
330: elsif p_balance_type = 'A' then
331: begin
332:
333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);
334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);

Line 334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613

330: elsif p_balance_type = 'A' then
331: begin
332:
333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);
334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);

Line 335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);

331: begin
332:
333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);
334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:

Line 336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);

332:
333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);
334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:
340: /* start bug 4256345 */

Line 337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);

333: dbms_sql.bind_variable(g_cur_actual_balance, ':CCID', p_ccid);
334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:
340: /* start bug 4256345 */
341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);

Line 338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);

334: dbms_sql.bind_variable(g_cur_actual_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
335: dbms_sql.bind_variable(g_cur_actual_balance, ':ACCOUNT_TYPE', p_account_type);
336: dbms_sql.bind_variable(g_cur_actual_balance, ':CURRENCY_CODE', p_currency_code);
337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:
340: /* start bug 4256345 */
341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);
342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);

Line 341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);

337: dbms_sql.bind_variable(g_cur_actual_balance, ':START_DATE', p_start_date);
338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:
340: /* start bug 4256345 */
341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);
342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);
343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);

Line 342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);

338: dbms_sql.bind_variable(g_cur_actual_balance, ':END_DATE', p_end_date);
339:
340: /* start bug 4256345 */
341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);
342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);
343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);
346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);

Line 343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */

339:
340: /* start bug 4256345 */
341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);
342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);
343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);
346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);
347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);

Line 345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);

341: /* dbms_sql.define_column(g_cur_actual_balance, 1, l_start_date);
342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);
343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);
346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);
347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);
348: /* end bug 4256345 */
349:

Line 346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);

342: dbms_sql.define_column(g_cur_actual_balance, 2, l_end_date);
343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);
346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);
347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);
348: /* end bug 4256345 */
349:
350:

Line 347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);

343: dbms_sql.define_column(g_cur_actual_balance, 3, l_period_amount); */
344:
345: dbms_sql.define_array(g_cur_actual_balance, 1, l_start_date_tbl, 100, 1);
346: dbms_sql.define_array(g_cur_actual_balance, 2, l_end_date_tbl, 100, 1);
347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);
348: /* end bug 4256345 */
349:
350:
351: num_balances := dbms_sql.execute(g_cur_actual_balance);

Line 351: num_balances := dbms_sql.execute(g_cur_actual_balance);

347: dbms_sql.define_array(g_cur_actual_balance, 3, l_period_amount_tbl, 100, 1);
348: /* end bug 4256345 */
349:
350:
351: num_balances := dbms_sql.execute(g_cur_actual_balance);
352:
353: loop
354: /* start bug 4256345 */
355: /* if dbms_sql.fetch_rows(g_cur_actual_balance) = 0 then

Line 355: /* if dbms_sql.fetch_rows(g_cur_actual_balance) = 0 then

351: num_balances := dbms_sql.execute(g_cur_actual_balance);
352:
353: loop
354: /* start bug 4256345 */
355: /* if dbms_sql.fetch_rows(g_cur_actual_balance) = 0 then
356: exit;
357: end if; */
358:
359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);

Line 359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);

355: /* if dbms_sql.fetch_rows(g_cur_actual_balance) = 0 then
356: exit;
357: end if; */
358:
359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);
360:
361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);
362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */

Line 361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);

357: end if; */
358:
359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);
360:
361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);
362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);

Line 362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);

358:
359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);
360:
361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);
362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);
366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);

Line 363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */

359: num_balances := dbms_sql.fetch_rows(g_cur_actual_balance);
360:
361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);
362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);
366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);
367: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount_tbl);

Line 365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);

361: /* dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date);
362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);
366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);
367: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount_tbl);
368:
369: for l_date_index in 1..l_start_date_tbl.count loop

Line 366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);

362: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date);
363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);
366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);
367: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount_tbl);
368:
369: for l_date_index in 1..l_start_date_tbl.count loop
370: for l_period_index in 1..g_num_actual_periods loop

Line 367: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount_tbl);

363: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount); */
364:
365: dbms_sql.column_value(g_cur_actual_balance, 1, l_start_date_tbl);
366: dbms_sql.column_value(g_cur_actual_balance, 2, l_end_date_tbl);
367: dbms_sql.column_value(g_cur_actual_balance, 3, l_period_amount_tbl);
368:
369: for l_date_index in 1..l_start_date_tbl.count loop
370: for l_period_index in 1..g_num_actual_periods loop
371:

Line 399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);

395: end;
396: elsif p_balance_type = 'E' then
397: begin
398:
399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);
400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);

Line 400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613

396: elsif p_balance_type = 'E' then
397: begin
398:
399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);
400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);
404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);

Line 401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);

397: begin
398:
399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);
400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);
404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);
405:

Line 402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);

398:
399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);
400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);
404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);
405:
406: -- Bug#5030613 Start

Line 403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);

399: dbms_sql.bind_variable(g_cur_encum_balance, ':CCID', p_ccid);
400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);
404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);
405:
406: -- Bug#5030613 Start
407: for c_fin_rec in c_fin loop

Line 404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);

400: dbms_sql.bind_variable(g_cur_encum_balance, ':B_SET_OF_BOOKS_ID', p_set_of_books_id) ; -- Bug#5030613
401: dbms_sql.bind_variable(g_cur_encum_balance, ':ACCOUNT_TYPE', p_account_type);
402: dbms_sql.bind_variable(g_cur_encum_balance, ':CURRENCY_CODE', p_currency_code);
403: dbms_sql.bind_variable(g_cur_encum_balance, ':START_DATE', p_start_date);
404: dbms_sql.bind_variable(g_cur_encum_balance, ':END_DATE', p_end_date);
405:
406: -- Bug#5030613 Start
407: for c_fin_rec in c_fin loop
408: l_commit_enc_type_id := c_fin_rec.req_encumbrance_type_id;

Line 419: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;

415: IF NOT FND_API.to_Boolean(g_include_gl_commit_balance)
416: THEN
417: IF NOT FND_API.to_Boolean(g_include_gl_oblig_balance)
418: THEN
419: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
420: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
421: ELSE
422: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
423: END IF;

Line 420: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;

416: THEN
417: IF NOT FND_API.to_Boolean(g_include_gl_oblig_balance)
418: THEN
419: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
420: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
421: ELSE
422: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
423: END IF;
424: ELSE

Line 422: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;

418: THEN
419: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
420: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
421: ELSE
422: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
423: END IF;
424: ELSE
425: IF not FND_API.to_Boolean(g_include_gl_oblig_balance)
426: THEN

Line 427: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;

423: END IF;
424: ELSE
425: IF not FND_API.to_Boolean(g_include_gl_oblig_balance)
426: THEN
427: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
428: END IF ;
429: END IF;
430: ELSE
431: IF NOT FND_API.to_Boolean(g_include_gl_commit_balance)

Line 435: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;

431: IF NOT FND_API.to_Boolean(g_include_gl_commit_balance)
432: THEN
433: IF FND_API.to_Boolean(g_include_gl_oblig_balance)
434: THEN
435: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
436: END IF;
437: ELSE
438: IF NOT FND_API.to_Boolean(g_include_gl_oblig_balance)
439: THEN

Line 440: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;

436: END IF;
437: ELSE
438: IF NOT FND_API.to_Boolean(g_include_gl_oblig_balance)
439: THEN
440: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
441: ELSE
442: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
443: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
444: END IF;

Line 442: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;

438: IF NOT FND_API.to_Boolean(g_include_gl_oblig_balance)
439: THEN
440: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
441: ELSE
442: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
443: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
444: END IF;
445: END IF;
446: END IF;

Line 443: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;

439: THEN
440: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
441: ELSE
442: dbms_sql.bind_variable(g_cur_encum_balance, ':B_OBLIG_ENC_TYPE_ID', l_oblig_enc_type_id) ;
443: dbms_sql.bind_variable(g_cur_encum_balance, ':B_COMMIT_ENC_TYPE_ID', l_commit_enc_type_id) ;
444: END IF;
445: END IF;
446: END IF;
447: -- Bug#5030613 End

Line 450: /* dbms_sql.define_column(g_cur_encum_balance, 1, l_start_date);

446: END IF;
447: -- Bug#5030613 End
448:
449: /* start bug 4256345 */
450: /* dbms_sql.define_column(g_cur_encum_balance, 1, l_start_date);
451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);
452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);

Line 451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);

447: -- Bug#5030613 End
448:
449: /* start bug 4256345 */
450: /* dbms_sql.define_column(g_cur_encum_balance, 1, l_start_date);
451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);
452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);
455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);

Line 452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */

448:
449: /* start bug 4256345 */
450: /* dbms_sql.define_column(g_cur_encum_balance, 1, l_start_date);
451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);
452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);
455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);
456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);

Line 454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);

450: /* dbms_sql.define_column(g_cur_encum_balance, 1, l_start_date);
451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);
452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);
455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);
456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);
457: /* end bug 4256345 */
458:

Line 455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);

451: dbms_sql.define_column(g_cur_encum_balance, 2, l_end_date);
452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);
455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);
456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);
457: /* end bug 4256345 */
458:
459: /* bug no 4725091 */

Line 456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);

452: dbms_sql.define_column(g_cur_encum_balance, 3, l_period_amount); */
453:
454: dbms_sql.define_array(g_cur_encum_balance, 1, l_start_date_tbl, 100, 1);
455: dbms_sql.define_array(g_cur_encum_balance, 2, l_end_date_tbl, 100, 1);
456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);
457: /* end bug 4256345 */
458:
459: /* bug no 4725091 */
460: dbms_sql.define_array(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl, 100, 1);

Line 460: dbms_sql.define_array(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl, 100, 1);

456: dbms_sql.define_array(g_cur_encum_balance, 3, l_period_amount_tbl, 100, 1);
457: /* end bug 4256345 */
458:
459: /* bug no 4725091 */
460: dbms_sql.define_array(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl, 100, 1);
461:
462:
463: num_balances := dbms_sql.execute(g_cur_encum_balance);
464:

Line 463: num_balances := dbms_sql.execute(g_cur_encum_balance);

459: /* bug no 4725091 */
460: dbms_sql.define_array(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl, 100, 1);
461:
462:
463: num_balances := dbms_sql.execute(g_cur_encum_balance);
464:
465: loop
466: /* start bug 4256345 */
467: /* if dbms_sql.fetch_rows(g_cur_encum_balance) = 0 then

Line 467: /* if dbms_sql.fetch_rows(g_cur_encum_balance) = 0 then

463: num_balances := dbms_sql.execute(g_cur_encum_balance);
464:
465: loop
466: /* start bug 4256345 */
467: /* if dbms_sql.fetch_rows(g_cur_encum_balance) = 0 then
468: exit;
469: end if; */
470:
471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);

Line 471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);

467: /* if dbms_sql.fetch_rows(g_cur_encum_balance) = 0 then
468: exit;
469: end if; */
470:
471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);
472:
473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);
474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */

Line 473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);

469: end if; */
470:
471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);
472:
473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);
474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);

Line 474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);

470:
471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);
472:
473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);
474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);
478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);

Line 475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */

471: num_balances := dbms_sql.fetch_rows(g_cur_encum_balance);
472:
473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);
474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);
478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);
479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);

Line 477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);

473: /*dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date);
474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);
478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);
479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);
480:
481: /* bug no 4725091 */

Line 478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);

474: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date);
475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);
478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);
479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);
480:
481: /* bug no 4725091 */
482: dbms_sql.column_value(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl);

Line 479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);

475: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount); */
476:
477: dbms_sql.column_value(g_cur_encum_balance, 1, l_start_date_tbl);
478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);
479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);
480:
481: /* bug no 4725091 */
482: dbms_sql.column_value(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl);
483:

Line 482: dbms_sql.column_value(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl);

478: dbms_sql.column_value(g_cur_encum_balance, 2, l_end_date_tbl);
479: dbms_sql.column_value(g_cur_encum_balance, 3, l_period_amount_tbl);
480:
481: /* bug no 4725091 */
482: dbms_sql.column_value(g_cur_encum_balance, 4, l_fwd_bal_amt_tbl);
483:
484:
485: for l_date_index in 1..l_start_date_tbl.count loop
486: for l_period_index in 1..g_num_actual_periods loop

Line 1107: g_cur_budget_balance := dbms_sql.open_cursor;

1103: END IF;
1104: /* end bug 4256345 */
1105:
1106:
1107: g_cur_budget_balance := dbms_sql.open_cursor;
1108: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
1109:
1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);

Line 1108: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);

1104: /* end bug 4256345 */
1105:
1106:
1107: g_cur_budget_balance := dbms_sql.open_cursor;
1108: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
1109:
1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
1112:

Line 1110: g_cur_actual_balance := dbms_sql.open_cursor;

1106:
1107: g_cur_budget_balance := dbms_sql.open_cursor;
1108: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
1109:
1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
1112:
1113: g_cur_encum_balance := dbms_sql.open_cursor;
1114: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);

Line 1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);

1107: g_cur_budget_balance := dbms_sql.open_cursor;
1108: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
1109:
1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
1112:
1113: g_cur_encum_balance := dbms_sql.open_cursor;
1114: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
1115:

Line 1113: g_cur_encum_balance := dbms_sql.open_cursor;

1109:
1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
1112:
1113: g_cur_encum_balance := dbms_sql.open_cursor;
1114: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
1115:
1116: -- Currently, only Actual and Budget Balances are extracted from GL
1117:

Line 1114: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);

1110: g_cur_actual_balance := dbms_sql.open_cursor;
1111: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
1112:
1113: g_cur_encum_balance := dbms_sql.open_cursor;
1114: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
1115:
1116: -- Currently, only Actual and Budget Balances are extracted from GL
1117:
1118: g_balance_type(1) := 'A';

Line 1460: dbms_sql.close_cursor(g_cur_budget_balance);

1456: end if;
1457:
1458: end if;
1459:
1460: dbms_sql.close_cursor(g_cur_budget_balance);
1461: dbms_sql.close_cursor(g_cur_actual_balance);
1462: dbms_sql.close_cursor(g_cur_encum_balance);
1463:
1464:

Line 1461: dbms_sql.close_cursor(g_cur_actual_balance);

1457:
1458: end if;
1459:
1460: dbms_sql.close_cursor(g_cur_budget_balance);
1461: dbms_sql.close_cursor(g_cur_actual_balance);
1462: dbms_sql.close_cursor(g_cur_encum_balance);
1463:
1464:
1465: -- Initialize API return status to success

Line 1462: dbms_sql.close_cursor(g_cur_encum_balance);

1458: end if;
1459:
1460: dbms_sql.close_cursor(g_cur_budget_balance);
1461: dbms_sql.close_cursor(g_cur_actual_balance);
1462: dbms_sql.close_cursor(g_cur_encum_balance);
1463:
1464:
1465: -- Initialize API return status to success
1466:

Line 1475: if dbms_sql.is_open(g_cur_budget_balance) then

1471:
1472: when FND_API.G_EXC_ERROR then
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474:
1475: if dbms_sql.is_open(g_cur_budget_balance) then
1476: dbms_sql.close_cursor(g_cur_budget_balance);
1477: end if;
1478:
1479: if dbms_sql.is_open(g_cur_actual_balance) then

Line 1476: dbms_sql.close_cursor(g_cur_budget_balance);

1472: when FND_API.G_EXC_ERROR then
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474:
1475: if dbms_sql.is_open(g_cur_budget_balance) then
1476: dbms_sql.close_cursor(g_cur_budget_balance);
1477: end if;
1478:
1479: if dbms_sql.is_open(g_cur_actual_balance) then
1480: dbms_sql.close_cursor(g_cur_actual_balance);

Line 1479: if dbms_sql.is_open(g_cur_actual_balance) then

1475: if dbms_sql.is_open(g_cur_budget_balance) then
1476: dbms_sql.close_cursor(g_cur_budget_balance);
1477: end if;
1478:
1479: if dbms_sql.is_open(g_cur_actual_balance) then
1480: dbms_sql.close_cursor(g_cur_actual_balance);
1481: end if;
1482:
1483: if dbms_sql.is_open(g_cur_encum_balance) then

Line 1480: dbms_sql.close_cursor(g_cur_actual_balance);

1476: dbms_sql.close_cursor(g_cur_budget_balance);
1477: end if;
1478:
1479: if dbms_sql.is_open(g_cur_actual_balance) then
1480: dbms_sql.close_cursor(g_cur_actual_balance);
1481: end if;
1482:
1483: if dbms_sql.is_open(g_cur_encum_balance) then
1484: dbms_sql.close_cursor(g_cur_encum_balance);

Line 1483: if dbms_sql.is_open(g_cur_encum_balance) then

1479: if dbms_sql.is_open(g_cur_actual_balance) then
1480: dbms_sql.close_cursor(g_cur_actual_balance);
1481: end if;
1482:
1483: if dbms_sql.is_open(g_cur_encum_balance) then
1484: dbms_sql.close_cursor(g_cur_encum_balance);
1485: end if;
1486:
1487: -- FOR BUG 4256345

Line 1484: dbms_sql.close_cursor(g_cur_encum_balance);

1480: dbms_sql.close_cursor(g_cur_actual_balance);
1481: end if;
1482:
1483: if dbms_sql.is_open(g_cur_encum_balance) then
1484: dbms_sql.close_cursor(g_cur_encum_balance);
1485: end if;
1486:
1487: -- FOR BUG 4256345
1488: /* if c_ccids%ISOPEN then

Line 1500: if dbms_sql.is_open(g_cur_budget_balance) then

1496:
1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499:
1500: if dbms_sql.is_open(g_cur_budget_balance) then
1501: dbms_sql.close_cursor(g_cur_budget_balance);
1502: end if;
1503:
1504: if dbms_sql.is_open(g_cur_actual_balance) then

Line 1501: dbms_sql.close_cursor(g_cur_budget_balance);

1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499:
1500: if dbms_sql.is_open(g_cur_budget_balance) then
1501: dbms_sql.close_cursor(g_cur_budget_balance);
1502: end if;
1503:
1504: if dbms_sql.is_open(g_cur_actual_balance) then
1505: dbms_sql.close_cursor(g_cur_actual_balance);

Line 1504: if dbms_sql.is_open(g_cur_actual_balance) then

1500: if dbms_sql.is_open(g_cur_budget_balance) then
1501: dbms_sql.close_cursor(g_cur_budget_balance);
1502: end if;
1503:
1504: if dbms_sql.is_open(g_cur_actual_balance) then
1505: dbms_sql.close_cursor(g_cur_actual_balance);
1506: end if;
1507:
1508: if dbms_sql.is_open(g_cur_encum_balance) then

Line 1505: dbms_sql.close_cursor(g_cur_actual_balance);

1501: dbms_sql.close_cursor(g_cur_budget_balance);
1502: end if;
1503:
1504: if dbms_sql.is_open(g_cur_actual_balance) then
1505: dbms_sql.close_cursor(g_cur_actual_balance);
1506: end if;
1507:
1508: if dbms_sql.is_open(g_cur_encum_balance) then
1509: dbms_sql.close_cursor(g_cur_encum_balance);

Line 1508: if dbms_sql.is_open(g_cur_encum_balance) then

1504: if dbms_sql.is_open(g_cur_actual_balance) then
1505: dbms_sql.close_cursor(g_cur_actual_balance);
1506: end if;
1507:
1508: if dbms_sql.is_open(g_cur_encum_balance) then
1509: dbms_sql.close_cursor(g_cur_encum_balance);
1510: end if;
1511:
1512: -- FOR BUG 4256345

Line 1509: dbms_sql.close_cursor(g_cur_encum_balance);

1505: dbms_sql.close_cursor(g_cur_actual_balance);
1506: end if;
1507:
1508: if dbms_sql.is_open(g_cur_encum_balance) then
1509: dbms_sql.close_cursor(g_cur_encum_balance);
1510: end if;
1511:
1512: -- FOR BUG 4256345
1513: /* if c_ccids%ISOPEN then

Line 1525: if dbms_sql.is_open(g_cur_budget_balance) then

1521:
1522: when OTHERS then
1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524:
1525: if dbms_sql.is_open(g_cur_budget_balance) then
1526: dbms_sql.close_cursor(g_cur_budget_balance);
1527: end if;
1528:
1529: if dbms_sql.is_open(g_cur_actual_balance) then

Line 1526: dbms_sql.close_cursor(g_cur_budget_balance);

1522: when OTHERS then
1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524:
1525: if dbms_sql.is_open(g_cur_budget_balance) then
1526: dbms_sql.close_cursor(g_cur_budget_balance);
1527: end if;
1528:
1529: if dbms_sql.is_open(g_cur_actual_balance) then
1530: dbms_sql.close_cursor(g_cur_actual_balance);

Line 1529: if dbms_sql.is_open(g_cur_actual_balance) then

1525: if dbms_sql.is_open(g_cur_budget_balance) then
1526: dbms_sql.close_cursor(g_cur_budget_balance);
1527: end if;
1528:
1529: if dbms_sql.is_open(g_cur_actual_balance) then
1530: dbms_sql.close_cursor(g_cur_actual_balance);
1531: end if;
1532:
1533: if dbms_sql.is_open(g_cur_encum_balance) then

Line 1530: dbms_sql.close_cursor(g_cur_actual_balance);

1526: dbms_sql.close_cursor(g_cur_budget_balance);
1527: end if;
1528:
1529: if dbms_sql.is_open(g_cur_actual_balance) then
1530: dbms_sql.close_cursor(g_cur_actual_balance);
1531: end if;
1532:
1533: if dbms_sql.is_open(g_cur_encum_balance) then
1534: dbms_sql.close_cursor(g_cur_encum_balance);

Line 1533: if dbms_sql.is_open(g_cur_encum_balance) then

1529: if dbms_sql.is_open(g_cur_actual_balance) then
1530: dbms_sql.close_cursor(g_cur_actual_balance);
1531: end if;
1532:
1533: if dbms_sql.is_open(g_cur_encum_balance) then
1534: dbms_sql.close_cursor(g_cur_encum_balance);
1535: end if;
1536:
1537: -- FOR BUG 4256345

Line 1534: dbms_sql.close_cursor(g_cur_encum_balance);

1530: dbms_sql.close_cursor(g_cur_actual_balance);
1531: end if;
1532:
1533: if dbms_sql.is_open(g_cur_encum_balance) then
1534: dbms_sql.close_cursor(g_cur_encum_balance);
1535: end if;
1536:
1537: -- FOR BUG 4256345
1538: /* if c_ccids%ISOPEN then

Line 2804: g_cur_budget_balance := dbms_sql.open_cursor;

2800: END IF;
2801: END IF;
2802: -- Bug#5030613 End
2803:
2804: g_cur_budget_balance := dbms_sql.open_cursor;
2805: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
2806:
2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);

Line 2805: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);

2801: END IF;
2802: -- Bug#5030613 End
2803:
2804: g_cur_budget_balance := dbms_sql.open_cursor;
2805: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
2806:
2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
2809:

Line 2807: g_cur_actual_balance := dbms_sql.open_cursor;

2803:
2804: g_cur_budget_balance := dbms_sql.open_cursor;
2805: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
2806:
2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
2809:
2810: g_cur_encum_balance := dbms_sql.open_cursor;
2811: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);

Line 2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);

2804: g_cur_budget_balance := dbms_sql.open_cursor;
2805: dbms_sql.parse(g_cur_budget_balance, g_sql_budget_balance, dbms_sql.v7);
2806:
2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
2809:
2810: g_cur_encum_balance := dbms_sql.open_cursor;
2811: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
2812:

Line 2810: g_cur_encum_balance := dbms_sql.open_cursor;

2806:
2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
2809:
2810: g_cur_encum_balance := dbms_sql.open_cursor;
2811: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
2812:
2813: if l_budget_calendar_id <> NVL( PSB_WS_ACCT1.g_budget_calendar_id,
2814: FND_API.G_MISS_NUM)

Line 2811: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);

2807: g_cur_actual_balance := dbms_sql.open_cursor;
2808: dbms_sql.parse(g_cur_actual_balance, g_sql_actual_balance, dbms_sql.v7);
2809:
2810: g_cur_encum_balance := dbms_sql.open_cursor;
2811: dbms_sql.parse(g_cur_encum_balance, g_sql_encum_balance, dbms_sql.v7);
2812:
2813: if l_budget_calendar_id <> NVL( PSB_WS_ACCT1.g_budget_calendar_id,
2814: FND_API.G_MISS_NUM)
2815: then

Line 3090: dbms_sql.close_cursor(g_cur_budget_balance);

3086:
3087: end loop;
3088: -- End processing budget groups associated with the worksheet.
3089:
3090: dbms_sql.close_cursor(g_cur_budget_balance);
3091: dbms_sql.close_cursor(g_cur_actual_balance);
3092: dbms_sql.close_cursor(g_cur_encum_balance);
3093:
3094: -- Initialize API return status to success

Line 3091: dbms_sql.close_cursor(g_cur_actual_balance);

3087: end loop;
3088: -- End processing budget groups associated with the worksheet.
3089:
3090: dbms_sql.close_cursor(g_cur_budget_balance);
3091: dbms_sql.close_cursor(g_cur_actual_balance);
3092: dbms_sql.close_cursor(g_cur_encum_balance);
3093:
3094: -- Initialize API return status to success
3095: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3092: dbms_sql.close_cursor(g_cur_encum_balance);

3088: -- End processing budget groups associated with the worksheet.
3089:
3090: dbms_sql.close_cursor(g_cur_budget_balance);
3091: dbms_sql.close_cursor(g_cur_actual_balance);
3092: dbms_sql.close_cursor(g_cur_encum_balance);
3093:
3094: -- Initialize API return status to success
3095: p_return_status := FND_API.G_RET_STS_SUCCESS;
3096:

Line 3102: if dbms_sql.is_open(g_cur_budget_balance) then

3098:
3099: when FND_API.G_EXC_ERROR then
3100: p_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: if dbms_sql.is_open(g_cur_budget_balance) then
3103: dbms_sql.close_cursor(g_cur_budget_balance);
3104: end if;
3105:
3106: if dbms_sql.is_open(g_cur_actual_balance) then

Line 3103: dbms_sql.close_cursor(g_cur_budget_balance);

3099: when FND_API.G_EXC_ERROR then
3100: p_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: if dbms_sql.is_open(g_cur_budget_balance) then
3103: dbms_sql.close_cursor(g_cur_budget_balance);
3104: end if;
3105:
3106: if dbms_sql.is_open(g_cur_actual_balance) then
3107: dbms_sql.close_cursor(g_cur_actual_balance);

Line 3106: if dbms_sql.is_open(g_cur_actual_balance) then

3102: if dbms_sql.is_open(g_cur_budget_balance) then
3103: dbms_sql.close_cursor(g_cur_budget_balance);
3104: end if;
3105:
3106: if dbms_sql.is_open(g_cur_actual_balance) then
3107: dbms_sql.close_cursor(g_cur_actual_balance);
3108: end if;
3109:
3110: if dbms_sql.is_open(g_cur_encum_balance) then

Line 3107: dbms_sql.close_cursor(g_cur_actual_balance);

3103: dbms_sql.close_cursor(g_cur_budget_balance);
3104: end if;
3105:
3106: if dbms_sql.is_open(g_cur_actual_balance) then
3107: dbms_sql.close_cursor(g_cur_actual_balance);
3108: end if;
3109:
3110: if dbms_sql.is_open(g_cur_encum_balance) then
3111: dbms_sql.close_cursor(g_cur_encum_balance);

Line 3110: if dbms_sql.is_open(g_cur_encum_balance) then

3106: if dbms_sql.is_open(g_cur_actual_balance) then
3107: dbms_sql.close_cursor(g_cur_actual_balance);
3108: end if;
3109:
3110: if dbms_sql.is_open(g_cur_encum_balance) then
3111: dbms_sql.close_cursor(g_cur_encum_balance);
3112: end if;
3113:
3114: if c_ccids%ISOPEN then

Line 3111: dbms_sql.close_cursor(g_cur_encum_balance);

3107: dbms_sql.close_cursor(g_cur_actual_balance);
3108: end if;
3109:
3110: if dbms_sql.is_open(g_cur_encum_balance) then
3111: dbms_sql.close_cursor(g_cur_encum_balance);
3112: end if;
3113:
3114: if c_ccids%ISOPEN then
3115: close c_ccids;

Line 3121: if dbms_sql.is_open(g_cur_budget_balance) then

3117:
3118: when FND_API.G_EXC_UNEXPECTED_ERROR then
3119: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3120:
3121: if dbms_sql.is_open(g_cur_budget_balance) then
3122: dbms_sql.close_cursor(g_cur_budget_balance);
3123: end if;
3124:
3125: if dbms_sql.is_open(g_cur_actual_balance) then

Line 3122: dbms_sql.close_cursor(g_cur_budget_balance);

3118: when FND_API.G_EXC_UNEXPECTED_ERROR then
3119: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3120:
3121: if dbms_sql.is_open(g_cur_budget_balance) then
3122: dbms_sql.close_cursor(g_cur_budget_balance);
3123: end if;
3124:
3125: if dbms_sql.is_open(g_cur_actual_balance) then
3126: dbms_sql.close_cursor(g_cur_actual_balance);

Line 3125: if dbms_sql.is_open(g_cur_actual_balance) then

3121: if dbms_sql.is_open(g_cur_budget_balance) then
3122: dbms_sql.close_cursor(g_cur_budget_balance);
3123: end if;
3124:
3125: if dbms_sql.is_open(g_cur_actual_balance) then
3126: dbms_sql.close_cursor(g_cur_actual_balance);
3127: end if;
3128:
3129: if dbms_sql.is_open(g_cur_encum_balance) then

Line 3126: dbms_sql.close_cursor(g_cur_actual_balance);

3122: dbms_sql.close_cursor(g_cur_budget_balance);
3123: end if;
3124:
3125: if dbms_sql.is_open(g_cur_actual_balance) then
3126: dbms_sql.close_cursor(g_cur_actual_balance);
3127: end if;
3128:
3129: if dbms_sql.is_open(g_cur_encum_balance) then
3130: dbms_sql.close_cursor(g_cur_encum_balance);

Line 3129: if dbms_sql.is_open(g_cur_encum_balance) then

3125: if dbms_sql.is_open(g_cur_actual_balance) then
3126: dbms_sql.close_cursor(g_cur_actual_balance);
3127: end if;
3128:
3129: if dbms_sql.is_open(g_cur_encum_balance) then
3130: dbms_sql.close_cursor(g_cur_encum_balance);
3131: end if;
3132:
3133: if c_ccids%ISOPEN then

Line 3130: dbms_sql.close_cursor(g_cur_encum_balance);

3126: dbms_sql.close_cursor(g_cur_actual_balance);
3127: end if;
3128:
3129: if dbms_sql.is_open(g_cur_encum_balance) then
3130: dbms_sql.close_cursor(g_cur_encum_balance);
3131: end if;
3132:
3133: if c_ccids%ISOPEN then
3134: close c_ccids;

Line 3140: if dbms_sql.is_open(g_cur_budget_balance) then

3136:
3137: when OTHERS then
3138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3139:
3140: if dbms_sql.is_open(g_cur_budget_balance) then
3141: dbms_sql.close_cursor(g_cur_budget_balance);
3142: end if;
3143:
3144: if dbms_sql.is_open(g_cur_actual_balance) then

Line 3141: dbms_sql.close_cursor(g_cur_budget_balance);

3137: when OTHERS then
3138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3139:
3140: if dbms_sql.is_open(g_cur_budget_balance) then
3141: dbms_sql.close_cursor(g_cur_budget_balance);
3142: end if;
3143:
3144: if dbms_sql.is_open(g_cur_actual_balance) then
3145: dbms_sql.close_cursor(g_cur_actual_balance);

Line 3144: if dbms_sql.is_open(g_cur_actual_balance) then

3140: if dbms_sql.is_open(g_cur_budget_balance) then
3141: dbms_sql.close_cursor(g_cur_budget_balance);
3142: end if;
3143:
3144: if dbms_sql.is_open(g_cur_actual_balance) then
3145: dbms_sql.close_cursor(g_cur_actual_balance);
3146: end if;
3147:
3148: if dbms_sql.is_open(g_cur_encum_balance) then

Line 3145: dbms_sql.close_cursor(g_cur_actual_balance);

3141: dbms_sql.close_cursor(g_cur_budget_balance);
3142: end if;
3143:
3144: if dbms_sql.is_open(g_cur_actual_balance) then
3145: dbms_sql.close_cursor(g_cur_actual_balance);
3146: end if;
3147:
3148: if dbms_sql.is_open(g_cur_encum_balance) then
3149: dbms_sql.close_cursor(g_cur_encum_balance);

Line 3148: if dbms_sql.is_open(g_cur_encum_balance) then

3144: if dbms_sql.is_open(g_cur_actual_balance) then
3145: dbms_sql.close_cursor(g_cur_actual_balance);
3146: end if;
3147:
3148: if dbms_sql.is_open(g_cur_encum_balance) then
3149: dbms_sql.close_cursor(g_cur_encum_balance);
3150: end if;
3151:
3152: if c_ccids%ISOPEN then

Line 3149: dbms_sql.close_cursor(g_cur_encum_balance);

3145: dbms_sql.close_cursor(g_cur_actual_balance);
3146: end if;
3147:
3148: if dbms_sql.is_open(g_cur_encum_balance) then
3149: dbms_sql.close_cursor(g_cur_encum_balance);
3150: end if;
3151:
3152: if c_ccids%ISOPEN then
3153: close c_ccids;

Line 6000: cur_alloc := dbms_sql.open_cursor;

5996: 'where b.budget_calendar_id = ' || p_budget_calendar_id || ' ' ||
5997: 'and b.budget_year_type_id = ' || c_AllocRule_Rec.budget_year_type_id || ' ' ||
5998: 'and a.budget_year_id = b.budget_period_id)';
5999:
6000: cur_alloc := dbms_sql.open_cursor;
6001: dbms_sql.parse(cur_alloc, sql_alloc, dbms_sql.v7);
6002:
6003: for l_index in 1..l_num_periods loop
6004: dbms_sql.define_column(cur_alloc, l_index, l_amount);

Line 6001: dbms_sql.parse(cur_alloc, sql_alloc, dbms_sql.v7);

5997: 'and b.budget_year_type_id = ' || c_AllocRule_Rec.budget_year_type_id || ' ' ||
5998: 'and a.budget_year_id = b.budget_period_id)';
5999:
6000: cur_alloc := dbms_sql.open_cursor;
6001: dbms_sql.parse(cur_alloc, sql_alloc, dbms_sql.v7);
6002:
6003: for l_index in 1..l_num_periods loop
6004: dbms_sql.define_column(cur_alloc, l_index, l_amount);
6005: end loop;

Line 6004: dbms_sql.define_column(cur_alloc, l_index, l_amount);

6000: cur_alloc := dbms_sql.open_cursor;
6001: dbms_sql.parse(cur_alloc, sql_alloc, dbms_sql.v7);
6002:
6003: for l_index in 1..l_num_periods loop
6004: dbms_sql.define_column(cur_alloc, l_index, l_amount);
6005: end loop;
6006:
6007: num_alloc := dbms_sql.execute(cur_alloc);
6008:

Line 6007: num_alloc := dbms_sql.execute(cur_alloc);

6003: for l_index in 1..l_num_periods loop
6004: dbms_sql.define_column(cur_alloc, l_index, l_amount);
6005: end loop;
6006:
6007: num_alloc := dbms_sql.execute(cur_alloc);
6008:
6009: loop
6010:
6011: if dbms_sql.fetch_rows(cur_alloc) = 0 then

Line 6011: if dbms_sql.fetch_rows(cur_alloc) = 0 then

6007: num_alloc := dbms_sql.execute(cur_alloc);
6008:
6009: loop
6010:
6011: if dbms_sql.fetch_rows(cur_alloc) = 0 then
6012: exit;
6013: end if;
6014:
6015: l_allocated := TRUE;

Line 6018: dbms_sql.column_value(cur_alloc, l_index, l_period_amount(p_budget_periods(l_index).long_sequence_no));

6014:
6015: l_allocated := TRUE;
6016:
6017: for l_index in 1..l_num_periods loop
6018: dbms_sql.column_value(cur_alloc, l_index, l_period_amount(p_budget_periods(l_index).long_sequence_no));
6019: l_running_total := l_running_total + nvl(l_period_amount(p_budget_periods(l_index).long_sequence_no), 0);
6020: end loop;
6021:
6022: end loop;

Line 6024: dbms_sql.close_cursor(cur_alloc);

6020: end loop;
6021:
6022: end loop;
6023:
6024: dbms_sql.close_cursor(cur_alloc);
6025:
6026: for l_index in 1..l_num_periods loop
6027:
6028: if l_running_total = 0 then

Line 7847: cur_sumbgroup := dbms_sql.open_cursor;

7843: 'root_budget_group ' ||
7844: 'from psb_budget_groups ' ||
7845: 'where budget_group_id = :budget_group_id';
7846:
7847: cur_sumbgroup := dbms_sql.open_cursor;
7848: dbms_sql.parse(cur_sumbgroup, sql_sumbgroup, dbms_sql.v7);
7849:
7850: l_parent_found := FALSE;
7851: l_num_pbgroups := l_bgroups_index;

Line 7848: dbms_sql.parse(cur_sumbgroup, sql_sumbgroup, dbms_sql.v7);

7844: 'from psb_budget_groups ' ||
7845: 'where budget_group_id = :budget_group_id';
7846:
7847: cur_sumbgroup := dbms_sql.open_cursor;
7848: dbms_sql.parse(cur_sumbgroup, sql_sumbgroup, dbms_sql.v7);
7849:
7850: l_parent_found := FALSE;
7851: l_num_pbgroups := l_bgroups_index;
7852:

Line 7860: dbms_sql.bind_variable(cur_sumbgroup, ':budget_group_id', l_bgroups_tbl(l_index));

7856:
7857: if l_bgroups_tbl(l_index) is not null then
7858: begin
7859:
7860: dbms_sql.bind_variable(cur_sumbgroup, ':budget_group_id', l_bgroups_tbl(l_index));
7861:
7862: dbms_sql.define_column(cur_sumbgroup, 1, l_parentbgroup_id);
7863: dbms_sql.define_column(cur_sumbgroup, 2, l_root_budget_group, 1);
7864:

Line 7862: dbms_sql.define_column(cur_sumbgroup, 1, l_parentbgroup_id);

7858: begin
7859:
7860: dbms_sql.bind_variable(cur_sumbgroup, ':budget_group_id', l_bgroups_tbl(l_index));
7861:
7862: dbms_sql.define_column(cur_sumbgroup, 1, l_parentbgroup_id);
7863: dbms_sql.define_column(cur_sumbgroup, 2, l_root_budget_group, 1);
7864:
7865: num_sumbgroup := dbms_sql.execute(cur_sumbgroup);
7866:

Line 7863: dbms_sql.define_column(cur_sumbgroup, 2, l_root_budget_group, 1);

7859:
7860: dbms_sql.bind_variable(cur_sumbgroup, ':budget_group_id', l_bgroups_tbl(l_index));
7861:
7862: dbms_sql.define_column(cur_sumbgroup, 1, l_parentbgroup_id);
7863: dbms_sql.define_column(cur_sumbgroup, 2, l_root_budget_group, 1);
7864:
7865: num_sumbgroup := dbms_sql.execute(cur_sumbgroup);
7866:
7867: loop

Line 7865: num_sumbgroup := dbms_sql.execute(cur_sumbgroup);

7861:
7862: dbms_sql.define_column(cur_sumbgroup, 1, l_parentbgroup_id);
7863: dbms_sql.define_column(cur_sumbgroup, 2, l_root_budget_group, 1);
7864:
7865: num_sumbgroup := dbms_sql.execute(cur_sumbgroup);
7866:
7867: loop
7868:
7869: if dbms_sql.fetch_rows(cur_sumbgroup) = 0 then

Line 7869: if dbms_sql.fetch_rows(cur_sumbgroup) = 0 then

7865: num_sumbgroup := dbms_sql.execute(cur_sumbgroup);
7866:
7867: loop
7868:
7869: if dbms_sql.fetch_rows(cur_sumbgroup) = 0 then
7870: exit;
7871: end if;
7872:
7873: dbms_sql.column_value(cur_sumbgroup, 1, l_parentbgroup_id);

Line 7873: dbms_sql.column_value(cur_sumbgroup, 1, l_parentbgroup_id);

7869: if dbms_sql.fetch_rows(cur_sumbgroup) = 0 then
7870: exit;
7871: end if;
7872:
7873: dbms_sql.column_value(cur_sumbgroup, 1, l_parentbgroup_id);
7874: dbms_sql.column_value(cur_sumbgroup, 2, l_root_budget_group);
7875:
7876: if l_root_budget_group = 'Y' then
7877: l_bgroup_id := l_bgroups_tbl(l_index);

Line 7874: dbms_sql.column_value(cur_sumbgroup, 2, l_root_budget_group);

7870: exit;
7871: end if;
7872:
7873: dbms_sql.column_value(cur_sumbgroup, 1, l_parentbgroup_id);
7874: dbms_sql.column_value(cur_sumbgroup, 2, l_root_budget_group);
7875:
7876: if l_root_budget_group = 'Y' then
7877: l_bgroup_id := l_bgroups_tbl(l_index);
7878: exit;

Line 7924: dbms_sql.close_cursor(cur_sumbgroup);

7920: end if;
7921:
7922: end loop;
7923:
7924: dbms_sql.close_cursor(cur_sumbgroup);
7925:
7926: end;
7927: end if;
7928:

Line 8005: if dbms_sql.is_open(cur_sumbgroup) then

8001:
8002:
8003: when OTHERS then
8004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8005: if dbms_sql.is_open(cur_sumbgroup) then
8006: dbms_sql.close_cursor(cur_sumbgroup);
8007: end if;
8008:
8009: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 8006: dbms_sql.close_cursor(cur_sumbgroup);

8002:
8003: when OTHERS then
8004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8005: if dbms_sql.is_open(cur_sumbgroup) then
8006: dbms_sql.close_cursor(cur_sumbgroup);
8007: end if;
8008:
8009: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8010: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,