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

Line 285: x_error_message := 'Error during opening the dbms_sql cursor.';

281: END IF;
282:
283: -- DBMS_OUTPUT.ENABLE(1000000);
284: fund_level := pa_billing_values.funding_level(X_project_id);
285: x_error_message := 'Error during opening the dbms_sql cursor.';
286: c := dbms_sql.open_cursor;
287:
288: x_error_message := 'Error during fetching the get_procedure cursor.';
289:

Line 286: c := dbms_sql.open_cursor;

282:
283: -- DBMS_OUTPUT.ENABLE(1000000);
284: fund_level := pa_billing_values.funding_level(X_project_id);
285: x_error_message := 'Error during opening the dbms_sql cursor.';
286: c := dbms_sql.open_cursor;
287:
288: x_error_message := 'Error during fetching the get_procedure cursor.';
289:
290: /* Added below select statement for bug 3643409 */

Line 357: dbms_sql.parse(c, proc_stmt, dbms_sql.native);

353: IF g1_debug_mode = 'Y' THEN
354: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: before executing building the Pl/Sql block :'||proc_stmt);
355: END IF;
356: x_error_message := 'Error during parsing the dynamic PL/SQL.';
357: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
358:
359: /* Start of 3560805*/
360:
361: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */

Line 363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);

359: /* Start of 3560805*/
360:
361: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
362:
363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));

Line 364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);

360:
361: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
362:
363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));

Line 365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);

361: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
362:
363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));

Line 366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);

362:
363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);

Line 367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));

363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);

Line 368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));

364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);

Line 369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));

365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
373:

Line 370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);

366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
373:
374: /* End of 3560805*/

Line 371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);

367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
373:
374: /* End of 3560805*/
375:

Line 372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);

368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
373:
374: /* End of 3560805*/
375:
376: x_error_message := 'Error during executing the dynamic PL/SQL.';

Line 377: row_processed := dbms_sql.execute(c);

373:
374: /* End of 3560805*/
375:
376: x_error_message := 'Error during executing the dynamic PL/SQL.';
377: row_processed := dbms_sql.execute(c);
378:
379:
380: IF g1_debug_mode = 'Y' THEN
381: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: After building the Pl/Sql block :');

Line 395: dbms_sql.close_cursor(c);

391: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
392: IF g1_debug_mode = 'Y' THEN
393: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the others error :');
394: END IF;
395: dbms_sql.close_cursor(c);
396: RAISE;
397: END;
398:
399: END LOOP;

Line 405: x_error_message := 'Error during closing the dbms_sql cursor.';

401: END;
402:
403: END LOOP;
404:
405: x_error_message := 'Error during closing the dbms_sql cursor.';
406: dbms_sql.close_cursor(c);
407: if x_error_message = 'Error during closing the dbms_sql cursor.' then
408: x_error_message := 'OK';
409: end if;

Line 406: dbms_sql.close_cursor(c);

402:
403: END LOOP;
404:
405: x_error_message := 'Error during closing the dbms_sql cursor.';
406: dbms_sql.close_cursor(c);
407: if x_error_message = 'Error during closing the dbms_sql cursor.' then
408: x_error_message := 'OK';
409: end if;
410:

Line 407: if x_error_message = 'Error during closing the dbms_sql cursor.' then

403: END LOOP;
404:
405: x_error_message := 'Error during closing the dbms_sql cursor.';
406: dbms_sql.close_cursor(c);
407: if x_error_message = 'Error during closing the dbms_sql cursor.' then
408: x_error_message := 'OK';
409: end if;
410:
411: IF g1_debug_mode = 'Y' THEN