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_CONTROLS_PAGE_PKG dependencies on AMW_CONTROL_PURPOSES

Line 1041: from amw_control_purposes

1037: n number;
1038: BEGIN
1039: select count(*)
1040: into n
1041: from amw_control_purposes
1042: where control_rev_id = P_CONTROL_REV_ID
1043: and PURPOSE_code = P_PURPOSE_CODE;
1044:
1045: if n > 0 then

Line 1063: from amw_control_PURPOSES

1059: no varchar2(80);
1060: BEGIN
1061: select count(*)
1062: into n
1063: from amw_control_PURPOSES
1064: where control_rev_id = P_CONTROL_REV_ID
1065: and PURPOSE_code = P_PURPOSE_CODE;
1066:
1067: select meaning

Line 1121: delete from amw_control_PURPOSES

1117:
1118: -- initialize return status to success
1119: x_return_status := fnd_api.g_ret_sts_success;
1120:
1121: delete from amw_control_PURPOSES
1122: where control_rev_id = p_control_rev_id
1123: and PURPOSE_code = p_PURPOSE_code;
1124:
1125: if (p_select_flag = 'Y') then

Line 1126: insert into amw_control_PURPOSES(

1122: where control_rev_id = p_control_rev_id
1123: and PURPOSE_code = p_PURPOSE_code;
1124:
1125: if (p_select_flag = 'Y') then
1126: insert into amw_control_PURPOSES(
1127: control_PURPOSE_id
1128: ,control_rev_id
1129: ,PURPOSE_codE
1130: ,creation_date

Line 1135: AMW_CONTROL_PURPOSES_S.NEXTVAL

1131: ,created_by
1132: ,last_update_date
1133: ,last_updated_by
1134: ,last_update_login) values (
1135: AMW_CONTROL_PURPOSES_S.NEXTVAL
1136: ,p_control_rev_id
1137: ,p_PURPOSE_code
1138: ,SYSDATE
1139: ,FND_GLOBAL.USER_ID