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_LOAD_CONSTRAINT_DATA dependencies on AMW_CONSTRAINT_REV_S

Line 447: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S

443: l_row_id AMW_CONSTRAINTS_VL.row_id%type;
444: l_constraint_rev_id NUMBER;
445: l_classification VARCHAR2(30):=p_classification;
446:
447: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
448: CURSOR c_constraint_rev_id IS
449: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
450: FROM dual;
451:

Line 449: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL

445: l_classification VARCHAR2(30):=p_classification;
446:
447: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
448: CURSOR c_constraint_rev_id IS
449: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
450: FROM dual;
451:
452: BEGIN
453: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S

Line 453: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S

449: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
450: FROM dual;
451:
452: BEGIN
453: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
454: OPEN c_constraint_rev_id;
455: FETCH c_constraint_rev_id INTO l_constraint_rev_id;
456: CLOSE c_constraint_rev_id;
457:

Line 561: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S

557:
558: l_constraint_rev_id NUMBER;
559: l_classification VARCHAR2(30):=p_classification;
560: l_objective_code VARCHAR2(30):=p_objective_code;
561: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
562: CURSOR c_constraint_rev_id IS
563: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
564: FROM dual;
565:

Line 563: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL

559: l_classification VARCHAR2(30):=p_classification;
560: l_objective_code VARCHAR2(30):=p_objective_code;
561: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
562: CURSOR c_constraint_rev_id IS
563: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
564: FROM dual;
565:
566: CURSOR c_classification(c_cst_rev_id number) IS
567: SELECT classification

Line 576: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S

572: SELECT objective_code
573: FROM amw_constraints_b
574: WHERE constraint_rev_id=c_cst_rev_id;
575: BEGIN
576: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
577: OPEN c_constraint_rev_id;
578: FETCH c_constraint_rev_id INTO l_constraint_rev_id;
579: CLOSE c_constraint_rev_id;
580: