APPS.PSB_WS_PERIOD_TOTAL dependencies on DBMS_SQL

Line 252: l_cursor_id := dbms_sql.open_cursor;

248: query_condition || '))' ;
249:
250: l_sql := l_sql || l_flex_condition;
251:
252: l_cursor_id := dbms_sql.open_cursor;
253:
254: -- Parsing the statement.
255: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
256:

Line 255: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);

251:
252: l_cursor_id := dbms_sql.open_cursor;
253:
254: -- Parsing the statement.
255: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
256:
257: -- Bind input variables
258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);

Line 258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);

254: -- Parsing the statement.
255: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
256:
257: -- Bind input variables
258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);

Line 259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);

255: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
256:
257: -- Bind input variables
258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);

Line 260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);

256:
257: -- Bind input variables
258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);

Line 261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);

257: -- Bind input variables
258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */

Line 262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);

258: dbms_sql.bind_variable(l_cursor_id, ':b_acct_type', l_acct_type);
259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);

Line 263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);

259: dbms_sql.bind_variable(l_cursor_id, ':b_worksheet_id', p_worksheet_id);
260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */

Line 264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);

260: dbms_sql.bind_variable(l_cursor_id, ':b_account_flag', p_account_flag);
261: dbms_sql.bind_variable(l_cursor_id, ':b_currency_flag',p_currency_flag);
262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);

Line 266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);

262: dbms_sql.bind_variable(l_cursor_id, ':b_template_id', p_template_id);
263: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_flag', p_spkg_flag);
264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);

Line 268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);

264: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_selection_exists', p_spkg_selection_exists);
265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);
271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);
272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);

Line 269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);

265: /* Bug No 2543015 Start */
266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);
271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);
272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);
273:

Line 270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);

266: dbms_sql.bind_variable(l_cursor_id, ':b_spkg_name', p_spkg_name);
267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);
271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);
272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);
273:
274: -- define output variables

Line 271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);

267: /* Bug No 2543015 End */
268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);
271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);
272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);
273:
274: -- define output variables
275:

Line 272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);

268: dbms_sql.bind_variable(l_cursor_id, ':b_user_id', p_user_id);
269: dbms_sql.bind_variable(l_cursor_id, ':b_chart_of_accounts', p_chart_of_accounts);
270: dbms_sql.bind_variable(l_cursor_id, ':b_budget_year_id', p_budget_year_id);
271: dbms_sql.bind_variable(l_cursor_id, ':b_balance_type', p_balance_type);
272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);
273:
274: -- define output variables
275:
276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);

Line 276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);

272: dbms_sql.bind_variable(l_cursor_id, ':b_profile_worksheet_id', p_profile_worksheet_id);
273:
274: -- define output variables
275:
276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);
277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);

Line 277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);

273:
274: -- define output variables
275:
276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);
277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);

Line 278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);

274: -- define output variables
275:
276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);
277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);

Line 279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);

275:
276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);
277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);

Line 280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);

276: dbms_sql.define_column(l_cursor_id, 1, l1_amount);
277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);

Line 281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);

277: dbms_sql.define_column(l_cursor_id, 2, l2_amount);
278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);

Line 282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);

278: dbms_sql.define_column(l_cursor_id, 3, l3_amount);
279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);

Line 283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);

279: dbms_sql.define_column(l_cursor_id, 4, l4_amount);
280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);

Line 284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);

280: dbms_sql.define_column(l_cursor_id, 5, l5_amount);
281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);

Line 285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);

281: dbms_sql.define_column(l_cursor_id, 6, l6_amount);
282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);
289:

Line 286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);

282: dbms_sql.define_column(l_cursor_id, 7, l7_amount);
283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);
289:
290: -- execute

Line 287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);

283: dbms_sql.define_column(l_cursor_id, 8, l8_amount);
284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);
289:
290: -- execute
291: l_ignore := dbms_sql.execute(l_cursor_id);

Line 288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);

284: dbms_sql.define_column(l_cursor_id, 9, l9_amount);
285: dbms_sql.define_column(l_cursor_id, 10, l10_amount);
286: dbms_sql.define_column(l_cursor_id, 11, l11_amount);
287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);
289:
290: -- execute
291: l_ignore := dbms_sql.execute(l_cursor_id);
292: -- fetch

Line 291: l_ignore := dbms_sql.execute(l_cursor_id);

287: dbms_sql.define_column(l_cursor_id, 12, l12_amount);
288: dbms_sql.define_column(l_cursor_id, 13, l_year_amount);
289:
290: -- execute
291: l_ignore := dbms_sql.execute(l_cursor_id);
292: -- fetch
293: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
294:
295: -- retrieve the value

Line 293: l_ignore := dbms_sql.fetch_rows(l_cursor_id );

289:
290: -- execute
291: l_ignore := dbms_sql.execute(l_cursor_id);
292: -- fetch
293: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
294:
295: -- retrieve the value
296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);

Line 296: dbms_sql.column_value(l_cursor_id,1,l1_amount);

292: -- fetch
293: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
294:
295: -- retrieve the value
296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);

Line 297: dbms_sql.column_value(l_cursor_id,2,l2_amount);

293: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
294:
295: -- retrieve the value
296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);

Line 298: dbms_sql.column_value(l_cursor_id,3,l3_amount);

294:
295: -- retrieve the value
296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);

Line 299: dbms_sql.column_value(l_cursor_id,4,l4_amount);

295: -- retrieve the value
296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);

Line 300: dbms_sql.column_value(l_cursor_id,5,l5_amount);

296: dbms_sql.column_value(l_cursor_id,1,l1_amount);
297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);

Line 301: dbms_sql.column_value(l_cursor_id,6,l6_amount);

297: dbms_sql.column_value(l_cursor_id,2,l2_amount);
298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);

Line 302: dbms_sql.column_value(l_cursor_id,7,l7_amount);

298: dbms_sql.column_value(l_cursor_id,3,l3_amount);
299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);

Line 303: dbms_sql.column_value(l_cursor_id,8,l8_amount);

299: dbms_sql.column_value(l_cursor_id,4,l4_amount);
300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);

Line 304: dbms_sql.column_value(l_cursor_id,9,l9_amount);

300: dbms_sql.column_value(l_cursor_id,5,l5_amount);
301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);
308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);

Line 305: dbms_sql.column_value(l_cursor_id,10,l10_amount);

301: dbms_sql.column_value(l_cursor_id,6,l6_amount);
302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);
308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);
309:

Line 306: dbms_sql.column_value(l_cursor_id,11,l11_amount);

302: dbms_sql.column_value(l_cursor_id,7,l7_amount);
303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);
308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);
309:
310: p1_amount := l1_amount;

Line 307: dbms_sql.column_value(l_cursor_id,12,l12_amount);

303: dbms_sql.column_value(l_cursor_id,8,l8_amount);
304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);
308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);
309:
310: p1_amount := l1_amount;
311: p2_amount := l2_amount;

Line 308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);

304: dbms_sql.column_value(l_cursor_id,9,l9_amount);
305: dbms_sql.column_value(l_cursor_id,10,l10_amount);
306: dbms_sql.column_value(l_cursor_id,11,l11_amount);
307: dbms_sql.column_value(l_cursor_id,12,l12_amount);
308: dbms_sql.column_value(l_cursor_id,13,l_year_amount);
309:
310: p1_amount := l1_amount;
311: p2_amount := l2_amount;
312: p3_amount := l3_amount;

Line 325: dbms_sql.close_cursor(l_cursor_id);

321: p12_amount := l12_amount;
322: p_year_amount := l_year_amount;
323:
324: -- close the cursor
325: dbms_sql.close_cursor(l_cursor_id);
326:
327:
328: END Get_Totals;
329: