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 AMW_AUDIT_PROCEDURES_TL

Line 1166: l_audit_procedure_description amw_audit_procedures_tl.description%TYPE;

1162: IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'Revise_Without_Revision_Exists';
1164: l_dummy_audit_procedure_rec audit_procedure_rec_type := NULL;
1165: l_audit_procedure_rec audit_procedure_rec_type := NULL;
1166: l_audit_procedure_description amw_audit_procedures_tl.description%TYPE;
1167: l_classification number;
1168:
1169: -- find the target revision to be revised
1170: CURSOR c_target_revision (l_audit_procedure_id IN NUMBER) IS

Line 3738: insert into AMW_AUDIT_PROCEDURES_TL (

3734: FROM AMW_AUDIT_PROCEDURES_B
3735: WHERE AUDIT_PROCEDURE_REV_ID = l_approval_status.audit_procedure_rev_id
3736: );
3737:
3738: insert into AMW_AUDIT_PROCEDURES_TL (
3739: AUDIT_PROCEDURE_REV_ID,
3740: NAME,
3741: DESCRIPTION,
3742: LAST_UPDATE_DATE,

Line 3762: from AMW_AUDIT_PROCEDURES_TL

3758: G_LOGIN_ID,
3759: SECURITY_GROUP_ID,
3760: LANGUAGE,
3761: SOURCE_LANG
3762: from AMW_AUDIT_PROCEDURES_TL
3763: where AUDIT_PROCEDURE_REV_ID = l_approval_status.audit_procedure_rev_id);
3764:
3765: UPDATE AMW_AUDIT_PROCEDURES_B
3766: SET LATEST_REVISION_FLAG = 'N',