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

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 1193: from WF_ACTIVITIES

1189: -- Get current version number, if not exist, use 1
1190: -- If version exists, noinsert is positive, that is not to insert.
1191: select nvl(max(VERSION), 1), count(1)
1192: into new_version, noinsert
1193: from WF_ACTIVITIES
1194: where ITEM_TYPE = x_item_type
1195: and NAME = x_name;
1196:
1197: else

Line 1201: from WF_ACTIVITIES

1197: else
1198: -- Get a new version number
1199: select nvl(max(VERSION), 0) + 1
1200: into new_version
1201: from WF_ACTIVITIES
1202: where ITEM_TYPE = x_item_type
1203: and NAME = x_name;
1204:
1205: -- Set the end_date of the old version covering x_effective_date to

Line 1207: update WF_ACTIVITIES set

1203: and NAME = x_name;
1204:
1205: -- Set the end_date of the old version covering x_effective_date to
1206: -- x_effective_date.
1207: update WF_ACTIVITIES set
1208: END_DATE = x_effective_date
1209: where ITEM_TYPE = x_item_type
1210: and NAME = x_name
1211: and VERSION = old_version;

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 1262: -- update WF_ACTIVITIES_TL

1258:
1259: -- ### Not needed any more
1260: -- update the old data with the new display name
1261: -- begin
1262: -- update WF_ACTIVITIES_TL
1263: -- set display_name = n_dname
1264: -- where NAME = l_name
1265: -- and ITEM_TYPE = x_item_type
1266: -- and VERSION = new_version

Line 1288: Wf_Activities_Pkg.Insert_Row(

1284: -- and ending at the end_date of the old version covering x_effective_date.
1285: if (noinsert <= 0) then
1286: if (x_event_filter is null and x_event_type = null) then
1287:
1288: Wf_Activities_Pkg.Insert_Row(
1289: x_rowid => row_id,
1290: x_item_type => x_item_type,
1291: x_name => x_name,
1292: x_version => new_version,

Line 1318: Wf_Activities_Pkg.Insert_Row(

1314: );
1315:
1316: else
1317:
1318: Wf_Activities_Pkg.Insert_Row(
1319: x_rowid => row_id,
1320: x_item_type => x_item_type,
1321: x_name => x_name,
1322: x_version => new_version,

Line 1392: update WF_ACTIVITIES

1388: -- in case it was set (deleted but not purged previously).
1389:
1390: if (old_begin_date is null) then
1391: -- only have future definition, need to update the begin date also
1392: update WF_ACTIVITIES
1393: set BEGIN_DATE = x_effective_date,
1394: END_DATE = to_date(NULL)
1395: where ITEM_TYPE = x_item_type
1396: and NAME = x_name

Line 1408: update WF_ACTIVITIES

1404: -- ### most customer would not have such problem.
1405: -- ### in order to delete these, we may need to do a more
1406: -- ### complicated cursor query.
1407: else
1408: update WF_ACTIVITIES
1409: set END_DATE = to_date(NULL)
1410: where ITEM_TYPE = x_item_type
1411: and NAME = x_name
1412: and VERSION = new_version;

Line 1871: from WF_ACTIVITIES

1867: --
1868: -- If version exists, noinsert is positive, that is not to insert.
1869: select nvl(max(VERSION), 1), count(1)
1870: into new_version, noinsert
1871: from WF_ACTIVITIES
1872: where ITEM_TYPE = x_process_item_type
1873: and NAME = 'ROOT';
1874:
1875: if (noinsert <= 0) then

Line 2034: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,

2030: --
2031: begin
2032: select WAA.TYPE
2033: into l_type
2034: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,
2035: WF_ACTIVITY_ATTRIBUTES WAA
2036: where WPA.INSTANCE_ID = x_process_activity_id
2037: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2038: and WPA.ACTIVITY_NAME = WA.NAME

Line 2461: from WF_ACTIVITIES

2457: from WF_LOOKUP_TYPES
2458: where ITEM_TYPE = x_name)
2459: and not exists
2460: (select 1
2461: from WF_ACTIVITIES
2462: where ITEM_TYPE = x_name)
2463: and not exists
2464: (select 1
2465: from WF_MESSAGES

Line 2624: from WF_ACTIVITIES

2620: into dummy
2621: from sys.dual
2622: where not exists
2623: (select 1
2624: from WF_ACTIVITIES
2625: where ITEM_TYPE = x_type
2626: and MESSAGE = x_name)
2627: and not exists
2628: (select 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 2785: update WF_ACTIVITIES set

2781: return;
2782: end if;
2783:
2784: -- Do not delete, only set end_date
2785: update WF_ACTIVITIES set
2786: end_date = sysdate
2787: where ITEM_TYPE = x_item_type
2788: and NAME = x_name
2789: and END_DATE is null;

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)

Line 4082: update WF_ACTIVITIES

4078: raise;
4079: end;
4080:
4081: -- Do the Update
4082: update WF_ACTIVITIES
4083: set expand_role = l_expand_role
4084: where ITEM_TYPE = p_item_type
4085: and NAME = p_name
4086: and VERSION = l_version;

Line 4088: update WF_ACTIVITIES_TL

4084: where ITEM_TYPE = p_item_type
4085: and NAME = p_name
4086: and VERSION = l_version;
4087:
4088: update WF_ACTIVITIES_TL
4089: set DISPLAY_NAME = n_dname,
4090: DESCRIPTION = l_description
4091: where ITEM_TYPE = p_item_type
4092: and NAME = p_name

Line 4340: from WF_ACTIVITIES

4336: p_names out NOCOPY t_nameTab
4337: )is
4338: cursor notfcur is
4339: select NAME
4340: from WF_ACTIVITIES
4341: where NAME like '%'||p_suffix
4342: and ITEM_TYPE = p_item_type
4343: and TYPE = 'NOTICE'
4344: and END_DATE is null;

Line 4587: WF_ACTIVITIES WA

4583:
4584: cursor actcur(ver number) is
4585: select WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME
4586: from WF_PROCESS_ACTIVITIES WPA,
4587: WF_ACTIVITIES WA
4588: where WPA.PROCESS_ITEM_TYPE = p_process_item_type
4589: and WPA.PROCESS_NAME = p_process_name
4590: and WPA.PROCESS_VERSION = ver
4591: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE

Line 4611: from WF_ACTIVITIES

4607:
4608: -- then get the active version
4609: begin
4610: select VERSION into m_version
4611: from WF_ACTIVITIES
4612: where ITEM_TYPE = p_process_item_type
4613: and NAME = p_process_name
4614: and active_date >= BEGIN_DATE
4615: and active_date < nvl(END_DATE, active_date + 1);

Line 4721: WFTable TableName:=TableName ('WF_ACTIVITIES',

4717: l_package_name varchar2(30) := 'WF_LOAD';
4718: l_module_name varchar2(30) := 'Prepare_NZDT_WFLOAD';
4719: l_tem_tab_name varchar2(50);
4720: TYPE TableName is VARRAY(17) OF VARCHAR2(50);
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',
4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',

Line 4722: 'WF_ACTIVITIES_TL',

4718: l_module_name varchar2(30) := 'Prepare_NZDT_WFLOAD';
4719: l_tem_tab_name varchar2(50);
4720: TYPE TableName is VARRAY(17) OF VARCHAR2(50);
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',
4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',