DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on WF_LOOKUPS

Line 753: from WF_LOOKUPS

749: lk_type in varchar2)
750: return varchar2 is
751: cursor c is
752: select MEANING
753: from WF_LOOKUPS
754: where LOOKUP_TYPE = lk_type
755: order by MEANING;
756:
757: buffer varchar2(32000);

Line 1107: from WF_LOOKUPS

1103:
1104: begin
1105: select MEANING
1106: into buf
1107: from WF_LOOKUPS
1108: where LOOKUP_TYPE = lk_type and LOOKUP_CODE = lk_code;
1109: exception
1110: when no_data_found then
1111: wf_core.token('TYPE', lk_type);

Line 1146: from WF_LOOKUPS

1142: -- Exact match
1143: begin
1144: select LOOKUP_CODE
1145: into buf
1146: from WF_LOOKUPS
1147: where LOOKUP_TYPE = lk_type
1148: and MEANING = lk_meaning;
1149:
1150: return buf;

Line 1160: from WF_LOOKUPS

1156: -- Case-insensitive match
1157: begin
1158: select LOOKUP_CODE
1159: into buf
1160: from WF_LOOKUPS
1161: where LOOKUP_TYPE = lk_type
1162: and upper(MEANING) = upper(lk_meaning);
1163: exception
1164: when no_data_found then

Line 1192: from WF_LOOKUPS

1188: lk_type in varchar2)
1189: return varchar2 is
1190: cursor c is
1191: select LOOKUP_CODE
1192: from WF_LOOKUPS
1193: where LOOKUP_TYPE = lk_type
1194: order by LOOKUP_CODE;
1195:
1196: buffer varchar2(32000);