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_ITEM_ATTRIBUTES

Line 178: update WF_ITEM_ATTRIBUTES set

174: newseq in number)
175: is
176: begin
177: -- Move attr being updated to a placeholder out of the way.
178: update WF_ITEM_ATTRIBUTES set
179: SEQUENCE = -1
180: where ITEM_TYPE = itemtype
181: and SEQUENCE = oldseq;
182:

Line 186: update WF_ITEM_ATTRIBUTES set

182:
183: if (oldseq < newseq) then
184: -- Move attrs DOWN in sequence to make room at higher position
185: for i in (oldseq + 1) .. newseq loop
186: update WF_ITEM_ATTRIBUTES set
187: SEQUENCE = SEQUENCE - 1
188: where ITEM_TYPE = itemtype
189: and SEQUENCE = i;
190: end loop;

Line 194: update WF_ITEM_ATTRIBUTES set

190: end loop;
191: elsif (oldseq > newseq) then
192: -- Move attrs UP in sequence to make room at lower position
193: for i in reverse newseq .. (oldseq - 1) loop
194: update WF_ITEM_ATTRIBUTES set
195: SEQUENCE = SEQUENCE + 1
196: where ITEM_TYPE = itemtype
197: and SEQUENCE = i;
198: end loop;

Line 202: update WF_ITEM_ATTRIBUTES set

198: end loop;
199: end if;
200:
201: -- Move attr being updated into new sequence position
202: update WF_ITEM_ATTRIBUTES set
203: SEQUENCE = newseq
204: where ITEM_TYPE = itemtype
205: and SEQUENCE = -1;
206:

Line 254: from WF_ITEM_ATTRIBUTES_VL

250: begin
251: -- l_name will be the old data to update
252: select ITEM_TYPE||':'||NAME, DISPLAY_NAME, NAME
253: into conflict_name, l_dname, l_name
254: from WF_ITEM_ATTRIBUTES_VL
255: where DISPLAY_NAME = x_display_name
256: and ITEM_TYPE = x_item_type
257: and NAME <> x_name;
258:

Line 266: from WF_ITEM_ATTRIBUTES_VL

262: loop
263: begin
264: select ITEM_TYPE||':'||NAME, DISPLAY_NAME
265: into conflict_name, l_dname
266: from WF_ITEM_ATTRIBUTES_VL
267: where DISPLAY_NAME = n_dname
268: and ITEM_TYPE = x_item_type
269: and NAME <> l_name;
270:

Line 289: -- update WF_ITEM_ATTRIBUTES_TL

285:
286: -- ### Not needed any more
287: -- update the old data with the new display name
288: -- begin
289: -- update WF_ITEM_ATTRIBUTES_TL
290: -- set display_name = n_dname
291: -- where ITEM_TYPE = x_item_type
292: -- and NAME = l_name
293: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 322: from WF_ITEM_ATTRIBUTES_VL

318: x_level_error := 0;
319: begin
320: select PROTECT_LEVEL, CUSTOM_LEVEL, SEQUENCE
321: into protection_level, customization_level, old_sequence
322: from WF_ITEM_ATTRIBUTES_VL
323: where ITEM_TYPE = x_item_type
324: and NAME = x_name;
325:
326: if ((wf_core.upload_mode <> 'FORCE') and

Line 347: Wf_Item_Attributes_Pkg.Update_Row(

343: newseq => x_sequence);
344: end if;
345:
346: -- Update existing row
347: Wf_Item_Attributes_Pkg.Update_Row(
348: x_item_type => x_item_type,
349: x_name => x_name,
350: x_sequence => x_sequence,
351: x_type => x_type,

Line 382: from WF_ITEM_ATTRIBUTES

378: -- Resequence attrs so that everything below the attr being
379: -- inserted is shoved out of the way.
380: select nvl(max(SEQUENCE), -1)+1
381: into old_sequence
382: from WF_ITEM_ATTRIBUTES
383: where ITEM_TYPE = x_item_type;
384:
385: if (old_sequence <> x_sequence) then
386: Wf_Load.Reseq_Item_Attribute(

Line 393: Wf_Item_Attributes_Pkg.Insert_Row(

389: newseq => x_sequence);
390: end if;
391:
392: -- Insert new row
393: Wf_Item_Attributes_Pkg.Insert_Row(
394: x_rowid => row_id,
395: x_item_type => x_item_type,
396: x_name => x_name,
397: x_sequence => x_sequence,

Line 2501: from WF_ITEM_ATTRIBUTES_VL

2497: -- Check protection level
2498: x_level_error := 0;
2499: select PROTECT_LEVEL, CUSTOM_LEVEL
2500: into protection_level, customization_level
2501: from WF_ITEM_ATTRIBUTES_VL
2502: where ITEM_TYPE = x_item_type
2503: and NAME = x_name;
2504:
2505: if ((wf_core.upload_mode <> 'FORCE') and

Line 2517: Wf_Item_Attributes_Pkg.Delete_Row(

2513: x_level_error := 2;
2514: return;
2515: end if;
2516:
2517: Wf_Item_Attributes_Pkg.Delete_Row(
2518: x_item_type => x_item_type,
2519: x_name => x_name);
2520:
2521: exception

Line 2561: delete from WF_ITEM_ATTRIBUTES_TL

2557: x_level_error := 2;
2558: return;
2559: end if;
2560:
2561: delete from WF_ITEM_ATTRIBUTES_TL
2562: where ITEM_TYPE = X_ITEM_TYPE;
2563:
2564: delete from WF_ITEM_ATTRIBUTES
2565: where ITEM_TYPE = X_ITEM_TYPE;

Line 2564: delete from WF_ITEM_ATTRIBUTES

2560:
2561: delete from WF_ITEM_ATTRIBUTES_TL
2562: where ITEM_TYPE = X_ITEM_TYPE;
2563:
2564: delete from WF_ITEM_ATTRIBUTES
2565: where ITEM_TYPE = X_ITEM_TYPE;
2566: exception
2567: when NO_DATA_FOUND then
2568: null;

Line 3066: from WF_ITEM_ATTRIBUTES_VL

3062: TYPE, SUBTYPE, FORMAT, TEXT_DEFAULT,
3063: to_char(NUMBER_DEFAULT) NUMBER_DEFAULT,
3064: to_char(DATE_DEFAULT, 'YYYY/MM/DD HH24:MI:SS') DATE_DEFAULT,
3065: SEQUENCE
3066: from WF_ITEM_ATTRIBUTES_VL
3067: where ITEM_TYPE = itt
3068: order by SEQUENCE;
3069:
3070: cursor lutcur(itt in varchar2) is

Line 3797: from WF_ITEM_ATTRIBUTES

3793: into p_attribute_type,
3794: p_attribute_value,
3795: l_number,
3796: l_date
3797: from WF_ITEM_ATTRIBUTES
3798: where ITEM_TYPE = p_item_type
3799: and NAME = p_attribute_name;
3800:
3801: if (p_attribute_type = 'DATE') then

Line 4306: from WF_ITEM_ATTRIBUTES

4302: p_names out NOCOPY t_nameTab
4303: )is
4304: cursor itancur is
4305: select NAME
4306: from WF_ITEM_ATTRIBUTES
4307: where ITEM_TYPE = p_item_type
4308: and NAME like '%'||p_suffix;
4309:
4310: i pls_integer;

Line 4727: 'WF_ITEM_ATTRIBUTES',

4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',

Line 4728: 'WF_ITEM_ATTRIBUTES_TL',

4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',
4732: 'WF_LOOKUP_TYPES_TL',