APPS.WF_LOAD dependencies on WF_LOOKUP_TYPES

Line 449: from WF_LOOKUP_TYPES

445: -- to the incoming display name
446: begin
447: select LOOKUP_TYPE, DISPLAY_NAME, LOOKUP_TYPE
448: into conflict_name, l_dname, l_name
449: from WF_LOOKUP_TYPES
450: where DISPLAY_NAME = x_display_name
451: and LOOKUP_TYPE <> x_lookup_type;
452:
453: n_dname := substrb('@'||l_dname, 1, 80);

Line 460: from WF_LOOKUP_TYPES

456: loop
457: begin
458: select LOOKUP_TYPE, DISPLAY_NAME
459: into conflict_name, l_dname
460: from WF_LOOKUP_TYPES
461: where DISPLAY_NAME = n_dname
462: and LOOKUP_TYPE <> l_name;
463:
464: n_dname := substrb('@'||l_dname, 1, 80);

Line 481: -- update WF_LOOKUP_TYPES_TL

477: end loop;
478: -- ### No need to do this
479: -- update the old data with the new meaning
480: -- begin
481: -- update WF_LOOKUP_TYPES_TL
482: -- set DISPLAY_NAME = n_dname
483: -- where LOOKUP_TYPE = l_name
484: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
485: -- exception

Line 501: from WF_LOOKUP_TYPES

497: x_level_error := 0;
498: begin
499: select PROTECT_LEVEL, CUSTOM_LEVEL
500: into protection_level, customization_level
501: from WF_LOOKUP_TYPES
502: where LOOKUP_TYPE = x_lookup_type;
503:
504: if ((wf_core.upload_mode <> 'FORCE') and
505: (protection_level < wf_core.session_level)) then

Line 517: Wf_Lookup_Types_Pkg.Update_Row(

513: return;
514: end if;
515:
516: -- Update existing row
517: Wf_Lookup_Types_Pkg.Update_Row(
518: x_lookup_type => x_lookup_type,
519: x_item_type => x_item_type,
520: x_protect_level => x_protect_level,
521: x_custom_level => x_custom_level,

Line 541: Wf_Lookup_Types_Pkg.Insert_Row(

537: return;
538: end if;
539:
540: -- Insert new row
541: Wf_Lookup_Types_Pkg.Insert_Row(
542: x_rowid => row_id,
543: x_lookup_type => x_lookup_type,
544: x_item_type => x_item_type,
545: x_protect_level => x_protect_level,

Line 2282: from WF_LOOKUP_TYPES

2278: -- Check protection level
2279: x_level_error := 0;
2280: select PROTECT_LEVEL, CUSTOM_LEVEL
2281: into protection_level, customization_level
2282: from WF_LOOKUP_TYPES
2283: where LOOKUP_TYPE = x_lookup_type;
2284:
2285: if ((wf_core.upload_mode <> 'FORCE') and
2286: (protection_level < wf_core.session_level)) then

Line 2300: Wf_Lookup_Types_Pkg.Delete_Row(x_lookup_type => x_lookup_type);

2296:
2297: -- Delete child lookups of this type
2298: Delete_Lookups(x_lookup_type, x_level_error);
2299:
2300: Wf_Lookup_Types_Pkg.Delete_Row(x_lookup_type => x_lookup_type);
2301:
2302: exception
2303: when NO_DATA_FOUND then
2304: null;

Line 2373: from WF_LOOKUP_TYPES_TL

2369:
2370: X_LEVEL_ERROR := 0;
2371: select MIN(protect_level), MAX(custom_level)
2372: into protection_level, customization_level
2373: from WF_LOOKUP_TYPES_TL
2374: where LOOKUP_TYPE = X_LOOKUP_TYPE;
2375:
2376: if ((wf_core.upload_mode <> 'FORCE') and
2377: (protection_level < wf_core.session_level)) then

Line 2457: from WF_LOOKUP_TYPES

2453: into dummy
2454: from sys.dual
2455: where not exists
2456: (select 1
2457: from WF_LOOKUP_TYPES
2458: where ITEM_TYPE = x_name)
2459: and not exists
2460: (select 1
2461: from WF_ACTIVITIES

Line 3073: from WF_LOOKUP_TYPES

3069:
3070: cursor lutcur(itt in varchar2) is
3071: select PROTECT_LEVEL, CUSTOM_LEVEL, LOOKUP_TYPE, DISPLAY_NAME,
3072: DESCRIPTION
3073: from WF_LOOKUP_TYPES
3074: where ITEM_TYPE = itt
3075: order by LOOKUP_TYPE;
3076:
3077: type t_lutTable is table of WF_LOOKUP_TYPES.LOOKUP_TYPE%TYPE

Line 3077: type t_lutTable is table of WF_LOOKUP_TYPES.LOOKUP_TYPE%TYPE

3073: from WF_LOOKUP_TYPES
3074: where ITEM_TYPE = itt
3075: order by LOOKUP_TYPE;
3076:
3077: type t_lutTable is table of WF_LOOKUP_TYPES.LOOKUP_TYPE%TYPE
3078: index by binary_integer;
3079:
3080: v_lut t_lutTable;
3081:

Line 4732: 'WF_LOOKUP_TYPES_TL',

4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',
4732: 'WF_LOOKUP_TYPES_TL',
4733: 'WF_MESSAGES',
4734: 'WF_MESSAGES_TL',
4735: 'WF_MESSAGE_ATTRIBUTES',
4736: 'WF_MESSAGE_ATTRIBUTES_TL',