DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on WF_ITEM_ATTRIBUTES_VL

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 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 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 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