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.WF_LOAD dependencies on WF_ACTIVITIES_VL

Line 1130: from WF_ACTIVITIES_VL

1126: begin
1127: select PROTECT_LEVEL, CUSTOM_LEVEL, VERSION, BEGIN_DATE, END_DATE
1128: into protection_level, customization_level,
1129: old_version, old_begin_date, old_end_date
1130: from WF_ACTIVITIES_VL
1131: where ITEM_TYPE = x_item_type
1132: and NAME = x_name
1133: and x_effective_date >= BEGIN_DATE
1134: and x_effective_date < nvl(END_DATE, x_effective_date+1);

Line 1159: from WF_ACTIVITIES_VL

1155: -- to be entered or a previously deleted activity is being
1156: -- recreated. OK to leave end_date as null.
1157: select min(BEGIN_DATE)
1158: into old_end_date
1159: from WF_ACTIVITIES_VL
1160: where ITEM_TYPE = x_item_type
1161: and NAME = x_name
1162: and BEGIN_DATE >= x_effective_date;
1163:

Line 1222: from WF_ACTIVITIES_VL

1218: begin
1219: -- l_name will be the old data to update
1220: select ITEM_TYPE||':'||NAME||':'||to_char(VERSION), DISPLAY_NAME, NAME
1221: into conflict_name, l_dname, l_name
1222: from WF_ACTIVITIES_VL
1223: where DISPLAY_NAME = n_dname
1224: and ITEM_TYPE = x_item_type
1225: and x_effective_date >= BEGIN_DATE
1226: and x_effective_date < nvl(END_DATE, x_effective_date+1)

Line 1236: from WF_ACTIVITIES_VL

1232: loop
1233: begin
1234: select ITEM_TYPE||':'||NAME||':'||to_char(VERSION), DISPLAY_NAME
1235: into conflict_name, l_dname
1236: from WF_ACTIVITIES_VL
1237: where DISPLAY_NAME = n_dname
1238: and ITEM_TYPE = x_item_type
1239: and x_effective_date >= BEGIN_DATE
1240: and x_effective_date < nvl(END_DATE, x_effective_date+1)

Line 2766: from WF_ACTIVITIES_VL

2762: x_level_error := 0;
2763:
2764: select PROTECT_LEVEL, CUSTOM_LEVEL
2765: into protection_level, customization_level
2766: from WF_ACTIVITIES_VL
2767: where ITEM_TYPE = x_item_type
2768: and NAME = x_name
2769: and END_DATE is null;
2770:

Line 3118: from WF_ACTIVITIES_VL

3114: READ_ROLE, WRITE_ROLE, EXECUTE_ROLE,
3115: to_char(BEGIN_DATE, 'YYYY/MM/DD HH24:MI:SS') EFFECTIVE_DATE,
3116: ERROR_ITEM_TYPE, RUNNABLE_FLAG, FUNCTION_TYPE,
3117: EVENT_NAME, DIRECTION
3118: from WF_ACTIVITIES_VL
3119: where sysdate >= BEGIN_DATE
3120: and (sysdate < END_DATE or END_DATE is null)
3121: and ITEM_TYPE = itt
3122: order by item_type, name;

Line 3909: from WF_ACTIVITIES_VL

3905: p_expand_role,
3906: p_error_item_type,
3907: p_runnable_flag,
3908: p_version
3909: from WF_ACTIVITIES_VL
3910: where ITEM_TYPE = p_item_type
3911: and NAME = p_name
3912: and END_DATE is null;
3913: exception

Line 4036: from WF_ACTIVITIES_VL

4032: begin
4033: -- l_name will be the old data to update
4034: select ITEM_TYPE||':'||NAME||':'||to_char(VERSION), DISPLAY_NAME, NAME
4035: into conflict_name, l_dname, l_name
4036: from WF_ACTIVITIES_VL
4037: where DISPLAY_NAME = n_dname
4038: and ITEM_TYPE = p_item_type
4039: and l_begin_date >= BEGIN_DATE
4040: and l_begin_date < nvl(END_DATE, l_begin_date+1)

Line 4050: from WF_ACTIVITIES_VL

4046: loop
4047: begin
4048: select ITEM_TYPE||':'||NAME||':'||to_char(VERSION), DISPLAY_NAME
4049: into conflict_name, l_dname
4050: from WF_ACTIVITIES_VL
4051: where DISPLAY_NAME = n_dname
4052: and ITEM_TYPE = p_item_type
4053: and l_begin_date >= BEGIN_DATE
4054: and l_begin_date < nvl(END_DATE, l_begin_date+1)