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

Line 90: insert_dbms_sql_feedback INTEGER;

86: actions_request_id NUMBER;
87: x_sysdate DATE;
88:
89: c INTEGER; /* cursor handler */
90: insert_dbms_sql_feedback INTEGER;
91:
92: -- 12.1 QWB Usability Improvements
93: charctr NUMBER;
94:

Line 323: c := DBMS_SQL.OPEN_CURSOR;

319:
320: -- concatenate
321: sql_string := insert_string||') '||value_string||') ';
322:
323: c := DBMS_SQL.OPEN_CURSOR;
324:
325: --dbms_output.put_line('DBMS PARSE');
326: DBMS_SQL.PARSE(c, sql_string, DBMS_SQL.NATIVE);
327:

Line 326: DBMS_SQL.PARSE(c, sql_string, DBMS_SQL.NATIVE);

322:
323: c := DBMS_SQL.OPEN_CURSOR;
324:
325: --dbms_output.put_line('DBMS PARSE');
326: DBMS_SQL.PARSE(c, sql_string, DBMS_SQL.NATIVE);
327:
328:
329: i := return_results_array.first;
330: j := 0;

Line 378: DBMS_SQL.BIND_VARIABLE(c, ':X'||to_char(j), column_value);

374: qa_chars_api.decimal_precision(return_results_array(i).element_id));
375: column_value := round(qltdate.any_to_number(column_value),nvl(l_precision, 240));
376: END IF;
377:
378: DBMS_SQL.BIND_VARIABLE(c, ':X'||to_char(j), column_value);
379: i := return_results_array.next(i);
380:
381: END LOOP;
382:

Line 390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);

386: -- Performance issue due to the use of literals in the SQL .
387: -- Binding the variables with corresponding values.
388: -- skolluku Mon Apr 23 23:39:10 PDT 2007.
389: --
390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);
391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);

Line 391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);

387: -- Binding the variables with corresponding values.
388: -- skolluku Mon Apr 23 23:39:10 PDT 2007.
389: --
390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);
391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);

Line 392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);

388: -- skolluku Mon Apr 23 23:39:10 PDT 2007.
389: --
390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);
391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);

Line 393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);

389: --
390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);
391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);

Line 394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);

390: DBMS_SQL.BIND_VARIABLE(c, ':x_collection_id', x_collection_id);
391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);

Line 395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);

391: DBMS_SQL.BIND_VARIABLE(c, ':x_occurrence', x_occurrence);
392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);

Line 396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);

392: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_updated_by', p_who_last_updated_by);
393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);

Line 397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);

393: DBMS_SQL.BIND_VARIABLE(c, ':p_who_created_by', p_who_created_by);
394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);

Line 398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);

394: DBMS_SQL.BIND_VARIABLE(c, ':p_who_last_update_login', p_who_last_update_login);
395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:

Line 399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);

395: DBMS_SQL.BIND_VARIABLE(c, ':p_enabled_flag', p_enabled_flag);
396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:
403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);

Line 400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);

396: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_number', p_transaction_number);
397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:
403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);
404:

Line 401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);

397: DBMS_SQL.BIND_VARIABLE(c, ':p_org_id', p_org_id);
398: DBMS_SQL.BIND_VARIABLE(c, ':p_plan_id', p_plan_id);
399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:
403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);
404:
405: insert_dbms_sql_feedback := DBMS_SQL.EXECUTE(c);

Line 403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);

399: DBMS_SQL.BIND_VARIABLE(c, ':p_spec_id', p_spec_id);
400: DBMS_SQL.BIND_VARIABLE(c, ':p_transaction_id', p_transaction_id);
401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:
403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);
404:
405: insert_dbms_sql_feedback := DBMS_SQL.EXECUTE(c);
406:
407: --dbms_output.put_line('DBMS CLOSE');

Line 405: insert_dbms_sql_feedback := DBMS_SQL.EXECUTE(c);

401: DBMS_SQL.BIND_VARIABLE(c, ':x_txn_header_id', x_txn_header_id);
402:
403: DBMS_SQL.BIND_VARIABLE(c, ':current_date', p_last_update_date);
404:
405: insert_dbms_sql_feedback := DBMS_SQL.EXECUTE(c);
406:
407: --dbms_output.put_line('DBMS CLOSE');
408: DBMS_SQL.CLOSE_CURSOR(c);
409:

Line 408: DBMS_SQL.CLOSE_CURSOR(c);

404:
405: insert_dbms_sql_feedback := DBMS_SQL.EXECUTE(c);
406:
407: --dbms_output.put_line('DBMS CLOSE');
408: DBMS_SQL.CLOSE_CURSOR(c);
409:
410:
411: IF (p_commit_flag = TRUE) THEN
412: COMMIT;

Line 500: update_dbms_sql_feedback INTEGER;

496: actions_request_id NUMBER;
497: x_sysdate date;
498:
499: c1 INTEGER; /* cursor handler */
500: update_dbms_sql_feedback INTEGER;
501:
502: -- 12.1 QWB Usability improvements
503: charctr NUMBER;
504:

Line 695: c1 := DBMS_SQL.OPEN_CURSOR;

691: -- concatenate
692:
693: sql_string := update_string||' '||value_string||' '||where_clause;
694:
695: c1 := DBMS_SQL.OPEN_CURSOR;
696:
697: --dbms_output.put_line('DBMS PARSE');
698: DBMS_SQL.PARSE(c1, sql_string, DBMS_SQL.NATIVE);
699:

Line 698: DBMS_SQL.PARSE(c1, sql_string, DBMS_SQL.NATIVE);

694:
695: c1 := DBMS_SQL.OPEN_CURSOR;
696:
697: --dbms_output.put_line('DBMS PARSE');
698: DBMS_SQL.PARSE(c1, sql_string, DBMS_SQL.NATIVE);
699:
700: j := return_results_array.first;
701: k := 0;
702:

Line 719: DBMS_SQL.BIND_VARIABLE(c1, ':X'||to_char(k), update_column_value);

715: END IF;
716:
717: -- dbms_output.put_line('bind varaible ->'||':X'||to_char(k));
718:
719: DBMS_SQL.BIND_VARIABLE(c1, ':X'||to_char(k), update_column_value);
720: -- anagarwa Mon Mar 8 12:18:47 PST 2004
721: -- Bug 3489530 last_update_Date is added as bind variable so
722: -- we need to bind value here.
723: -- also updated_by and update login were made bind variables to

Line 725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);

721: -- Bug 3489530 last_update_Date is added as bind variable so
722: -- we need to bind value here.
723: -- also updated_by and update login were made bind variables to
724: -- comply with coding standards
725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);
726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);
727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);
728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);
729:

Line 726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);

722: -- we need to bind value here.
723: -- also updated_by and update login were made bind variables to
724: -- comply with coding standards
725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);
726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);
727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);
728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);
729:
730: -- Bug 3776542. Performance issue due to the use of literals in the SQL .

Line 727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);

723: -- also updated_by and update login were made bind variables to
724: -- comply with coding standards
725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);
726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);
727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);
728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);
729:
730: -- Bug 3776542. Performance issue due to the use of literals in the SQL .
731: -- Binding the variables with corresponding values.

Line 728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);

724: -- comply with coding standards
725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);
726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);
727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);
728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);
729:
730: -- Bug 3776542. Performance issue due to the use of literals in the SQL .
731: -- Binding the variables with corresponding values.
732: -- srhariha. Thu Jul 29 00:27:59 PDT 2004.

Line 734: DBMS_SQL.BIND_VARIABLE(c1, ':x_collection_id', x_collection_id);

730: -- Bug 3776542. Performance issue due to the use of literals in the SQL .
731: -- Binding the variables with corresponding values.
732: -- srhariha. Thu Jul 29 00:27:59 PDT 2004.
733:
734: DBMS_SQL.BIND_VARIABLE(c1, ':x_collection_id', x_collection_id);
735: DBMS_SQL.BIND_VARIABLE(c1, ':p_occurrence', p_occurrence);
736: DBMS_SQL.BIND_VARIABLE(c1, ':p_plan_id', p_plan_id);
737:
738:

Line 735: DBMS_SQL.BIND_VARIABLE(c1, ':p_occurrence', p_occurrence);

731: -- Binding the variables with corresponding values.
732: -- srhariha. Thu Jul 29 00:27:59 PDT 2004.
733:
734: DBMS_SQL.BIND_VARIABLE(c1, ':x_collection_id', x_collection_id);
735: DBMS_SQL.BIND_VARIABLE(c1, ':p_occurrence', p_occurrence);
736: DBMS_SQL.BIND_VARIABLE(c1, ':p_plan_id', p_plan_id);
737:
738:
739:

Line 736: DBMS_SQL.BIND_VARIABLE(c1, ':p_plan_id', p_plan_id);

732: -- srhariha. Thu Jul 29 00:27:59 PDT 2004.
733:
734: DBMS_SQL.BIND_VARIABLE(c1, ':x_collection_id', x_collection_id);
735: DBMS_SQL.BIND_VARIABLE(c1, ':p_occurrence', p_occurrence);
736: DBMS_SQL.BIND_VARIABLE(c1, ':p_plan_id', p_plan_id);
737:
738:
739:
740: j := return_results_array.next(j);

Line 745: update_dbms_sql_feedback := DBMS_SQL.EXECUTE(c1);

741:
742:
743: END LOOP;
744:
745: update_dbms_sql_feedback := DBMS_SQL.EXECUTE(c1);
746:
747: DBMS_SQL.CLOSE_CURSOR(c1);
748:
749:

Line 747: DBMS_SQL.CLOSE_CURSOR(c1);

743: END LOOP;
744:
745: update_dbms_sql_feedback := DBMS_SQL.EXECUTE(c1);
746:
747: DBMS_SQL.CLOSE_CURSOR(c1);
748:
749:
750: IF (p_commit_flag = TRUE) THEN
751: COMMIT;