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.AMW_AUDIT_PROCEDURES_PVT dependencies on DUAL

Line 558: FROM dual;

554: l_row_id amw_audit_procedures_vl.row_id%TYPE;
555:
556: CURSOR c_rev_id IS
557: SELECT amw_procedure_rev_s.nextval
558: FROM dual;
559:
560: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
561: SELECT 1
562: FROM amw_audit_procedures_b

Line 567: FROM dual;

563: WHERE audit_procedure_rev_id = l_rev_id;
564:
565: CURSOR c_id IS
566: SELECT amw_procedures_s.nextval
567: FROM dual;
568:
569: CURSOR c_id_exists (l_id IN NUMBER) IS
570: SELECT 1
571: FROM amw_audit_procedures_b

Line 3012: select amw_ap_steps_s.nextval from dual;

3008: From amw_audit_procedures_b
3009: Where audit_procedure_rev_id = c_audit_procedure_rev_id;
3010:
3011: cursor get_ap_steps_id is
3012: select amw_ap_steps_s.nextval from dual;
3013:
3014: l_api_name CONSTANT VARCHAR2(30) := 'Insert_AP_Step';
3015: l_api_version_number CONSTANT NUMBER := 1.0;
3016:

Line 3609: FROM dual;

3605: l_approval_status c_approval_status%ROWTYPE;
3606: l_dummy NUMBER;
3607: CURSOR c_get_rev_id IS
3608: SELECT amw_procedure_rev_s.nextval
3609: FROM dual;
3610: l_audit_procedure_rev_id NUMBER;
3611:
3612: BEGIN
3613: -- Standard Start of API savepoint