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 224: x_error_message := 'Error during opening the dbms_sql cursor.';

220: END IF;
221:
222: -- DBMS_OUTPUT.ENABLE(1000000);
223: fund_level := pa_billing_values.funding_level(X_project_id);
224: x_error_message := 'Error during opening the dbms_sql cursor.';
225: c := dbms_sql.open_cursor;
226:
227: x_error_message := 'Error during fetching the get_procedure cursor.';
228:

Line 225: c := dbms_sql.open_cursor;

221:
222: -- DBMS_OUTPUT.ENABLE(1000000);
223: fund_level := pa_billing_values.funding_level(X_project_id);
224: x_error_message := 'Error during opening the dbms_sql cursor.';
225: c := dbms_sql.open_cursor;
226:
227: x_error_message := 'Error during fetching the get_procedure cursor.';
228:
229: /* Added below select statement for bug 3643409 */

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

292: IF g1_debug_mode = 'Y' THEN
293: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: before executing building the Pl/Sql block :'||proc_stmt);
294: END IF;
295: x_error_message := 'Error during parsing the dynamic PL/SQL.';
296: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
297:
298: /* Start of 3560805*/
299:
300: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */

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

298: /* Start of 3560805*/
299:
300: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
301:
302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));

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

299:
300: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
301:
302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));

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

300: /* Release 12 : ATG changes : Added the date format for the variable x_rev_or_bill_date */
301:
302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));

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

301:
302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);

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

302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);

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

303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);

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

304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
312:

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

305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
312:
313: /* End of 3560805*/

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

306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
312:
313: /* End of 3560805*/
314:

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

307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);
312:
313: /* End of 3560805*/
314:
315: x_error_message := 'Error during executing the dynamic PL/SQL.';

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

312:
313: /* End of 3560805*/
314:
315: x_error_message := 'Error during executing the dynamic PL/SQL.';
316: row_processed := dbms_sql.execute(c);
317:
318:
319: IF g1_debug_mode = 'Y' THEN
320: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: After building the Pl/Sql block :');

Line 334: dbms_sql.close_cursor(c);

330: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
331: IF g1_debug_mode = 'Y' THEN
332: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the others error :');
333: END IF;
334: dbms_sql.close_cursor(c);
335: RAISE;
336: END;
337:
338: END LOOP;

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

340: END;
341:
342: END LOOP;
343:
344: x_error_message := 'Error during closing the dbms_sql cursor.';
345: dbms_sql.close_cursor(c);
346: if x_error_message = 'Error during closing the dbms_sql cursor.' then
347: x_error_message := 'OK';
348: end if;

Line 345: dbms_sql.close_cursor(c);

341:
342: END LOOP;
343:
344: x_error_message := 'Error during closing the dbms_sql cursor.';
345: dbms_sql.close_cursor(c);
346: if x_error_message = 'Error during closing the dbms_sql cursor.' then
347: x_error_message := 'OK';
348: end if;
349:

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

342: END LOOP;
343:
344: x_error_message := 'Error during closing the dbms_sql cursor.';
345: dbms_sql.close_cursor(c);
346: if x_error_message = 'Error during closing the dbms_sql cursor.' then
347: x_error_message := 'OK';
348: end if;
349:
350: IF g1_debug_mode = 'Y' THEN