APPS.WF_LOAD dependencies on WF_LOOKUPS

Line 589: from WF_LOOKUPS

585: begin
586: -- l_name will be the old data to update
587: select LOOKUP_TYPE||':'||LOOKUP_CODE, MEANING, LOOKUP_CODE
588: into conflict_name, l_dname, l_name
589: from WF_LOOKUPS
590: where MEANING = x_meaning
591: and LOOKUP_TYPE = x_lookup_type
592: and LOOKUP_CODE <> x_lookup_code;
593:

Line 601: from WF_LOOKUPS

597: loop
598: begin
599: select LOOKUP_TYPE||':'||LOOKUP_CODE, MEANING
600: into conflict_name, l_dname
601: from WF_LOOKUPS
602: where MEANING = n_dname
603: and LOOKUP_TYPE = x_lookup_type
604: and LOOKUP_CODE <> l_name;
605:

Line 624: -- update WF_LOOKUPS_TL

620:
621: -- ### No need to do this
622: -- update the old data with the new meaning
623: -- begin
624: -- update WF_LOOKUPS_TL
625: -- set MEANING = n_dname
626: -- where LOOKUP_TYPE = x_lookup_type
627: -- and LOOKUP_CODE = l_name
628: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 648: from WF_LOOKUPS

644: x_level_error := 0;
645: begin
646: select PROTECT_LEVEL, CUSTOM_LEVEL
647: into protection_level, customization_level
648: from WF_LOOKUPS
649: where LOOKUP_TYPE = x_lookup_type
650: and LOOKUP_CODE = x_lookup_code;
651:
652: if ((wf_core.upload_mode <> 'FORCE') and

Line 665: Wf_Lookups_Pkg.Update_Row(

661: return;
662: end if;
663:
664: -- Update existing row
665: Wf_Lookups_Pkg.Update_Row(
666: x_lookup_type => x_lookup_type,
667: x_lookup_code => x_lookup_code,
668: x_protect_level => x_protect_level,
669: x_custom_level => x_custom_level,

Line 690: Wf_Lookups_Pkg.Insert_Row(

686: return;
687: end if;
688:
689: -- Insert new row
690: Wf_Lookups_Pkg.Insert_Row(
691: x_rowid => row_id,
692: x_lookup_type => x_lookup_type,
693: x_lookup_code => x_lookup_code,
694: x_protect_level => x_protect_level,

Line 2328: from WF_LOOKUPS

2324: -- Check protection level
2325: x_level_error := 0;
2326: select PROTECT_LEVEL, CUSTOM_LEVEL
2327: into protection_level, customization_level
2328: from WF_LOOKUPS
2329: where LOOKUP_TYPE = x_lookup_type
2330: and LOOKUP_CODE = x_lookup_code;
2331:
2332: if ((wf_core.upload_mode <> 'FORCE') and

Line 2344: Wf_Lookups_Pkg.Delete_Row(

2340: x_level_error := 2;
2341: return;
2342: end if;
2343:
2344: Wf_Lookups_Pkg.Delete_Row(
2345: x_lookup_type => x_lookup_type,
2346: x_lookup_code => x_lookup_code
2347: );
2348:

Line 2388: delete from WF_LOOKUPS_TL

2384: x_level_error := 2;
2385: return;
2386: end if;
2387:
2388: delete from WF_LOOKUPS_TL
2389: where LOOKUP_TYPE = X_LOOKUP_TYPE;
2390:
2391: exception
2392: when NO_DATA_FOUND then

Line 3084: from WF_LOOKUPS

3080: v_lut t_lutTable;
3081:
3082: cursor luccur(lut in varchar2) is
3083: select PROTECT_LEVEL, CUSTOM_LEVEL, LOOKUP_CODE, MEANING, DESCRIPTION
3084: from WF_LOOKUPS
3085: where LOOKUP_TYPE = lut
3086: order by LOOKUP_CODE;
3087:
3088: cursor msgcur(itt in varchar2) is

Line 4453: from WF_LOOKUPS

4449: is
4450: begin
4451: select MEANING, DESCRIPTION, PROTECT_LEVEL, CUSTOM_LEVEL
4452: into x_meaning, x_description, x_protect_level, x_custom_level
4453: from WF_LOOKUPS
4454: where LOOKUP_TYPE = x_lookup_type
4455: and LOOKUP_CODE = x_lookup_code;
4456: exception
4457: when OTHERS then

Line 4543: from WF_LOOKUPS

4539: p_lookup_codes out NOCOPY t_resultcodeTab)
4540: is
4541: cursor luccur is
4542: select LOOKUP_CODE
4543: from WF_LOOKUPS
4544: where LOOKUP_TYPE = p_lookup_type;
4545:
4546: i pls_integer;
4547: begin

Line 4731: 'WF_LOOKUPS_TL',

4727: 'WF_ITEM_ATTRIBUTES',
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',