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 177: update WF_ITEM_ATTRIBUTES set

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

Line 185: update WF_ITEM_ATTRIBUTES set

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

Line 193: update WF_ITEM_ATTRIBUTES set

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

Line 201: update WF_ITEM_ATTRIBUTES set

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

Line 253: from WF_ITEM_ATTRIBUTES_VL

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

Line 265: from WF_ITEM_ATTRIBUTES_VL

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

Line 288: -- update WF_ITEM_ATTRIBUTES_TL

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

Line 321: from WF_ITEM_ATTRIBUTES_VL

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

Line 346: Wf_Item_Attributes_Pkg.Update_Row(

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

Line 381: from WF_ITEM_ATTRIBUTES

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

Line 392: Wf_Item_Attributes_Pkg.Insert_Row(

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

Line 2500: from WF_ITEM_ATTRIBUTES_VL

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

Line 2516: Wf_Item_Attributes_Pkg.Delete_Row(

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

Line 2560: delete from WF_ITEM_ATTRIBUTES_TL

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

Line 2563: delete from WF_ITEM_ATTRIBUTES

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

Line 3065: from WF_ITEM_ATTRIBUTES_VL

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

Line 3796: from WF_ITEM_ATTRIBUTES

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

Line 4305: from WF_ITEM_ATTRIBUTES

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