APPS.WF_LOAD dependencies on WF_LOOKUPS

Line 588: from WF_LOOKUPS

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

Line 600: from WF_LOOKUPS

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

Line 623: -- update WF_LOOKUPS_TL

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

Line 647: from WF_LOOKUPS

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

Line 664: Wf_Lookups_Pkg.Update_Row(

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

Line 689: Wf_Lookups_Pkg.Insert_Row(

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

Line 2327: from WF_LOOKUPS

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

Line 2343: Wf_Lookups_Pkg.Delete_Row(

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

Line 2387: delete from WF_LOOKUPS_TL

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

Line 3083: from WF_LOOKUPS

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

Line 4452: from WF_LOOKUPS

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

Line 4542: from WF_LOOKUPS

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