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 1131: from WF_ACTIVITIES_VL

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

Line 1160: from WF_ACTIVITIES_VL

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

Line 1223: from WF_ACTIVITIES_VL

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

Line 1237: from WF_ACTIVITIES_VL

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

Line 2767: from WF_ACTIVITIES_VL

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

Line 3119: from WF_ACTIVITIES_VL

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

Line 3910: from WF_ACTIVITIES_VL

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

Line 4037: from WF_ACTIVITIES_VL

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

Line 4051: from WF_ACTIVITIES_VL

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