APPS.WF_LOAD dependencies on WF_LOOKUP_TYPES

Line 448: from WF_LOOKUP_TYPES

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

Line 459: from WF_LOOKUP_TYPES

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

Line 480: -- update WF_LOOKUP_TYPES_TL

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

Line 500: from WF_LOOKUP_TYPES

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

Line 516: Wf_Lookup_Types_Pkg.Update_Row(

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

Line 540: Wf_Lookup_Types_Pkg.Insert_Row(

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

Line 2281: from WF_LOOKUP_TYPES

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

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

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

Line 2372: from WF_LOOKUP_TYPES_TL

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

Line 2456: from WF_LOOKUP_TYPES

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

Line 3072: from WF_LOOKUP_TYPES

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

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

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