DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on WF_ITEM_ATTRIBUTES_VL

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