DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on WF_LOOKUPS

Line 742: from WF_LOOKUPS

738: lk_type in varchar2)
739: return varchar2 is
740: cursor c is
741: select MEANING
742: from WF_LOOKUPS
743: where LOOKUP_TYPE = lk_type
744: order by MEANING;
745:
746: buffer varchar2(32000);

Line 1096: from WF_LOOKUPS

1092:
1093: begin
1094: select MEANING
1095: into buf
1096: from WF_LOOKUPS
1097: where LOOKUP_TYPE = lk_type and LOOKUP_CODE = lk_code;
1098: exception
1099: when no_data_found then
1100: wf_core.token('TYPE', lk_type);

Line 1135: from WF_LOOKUPS

1131: -- Exact match
1132: begin
1133: select LOOKUP_CODE
1134: into buf
1135: from WF_LOOKUPS
1136: where LOOKUP_TYPE = lk_type
1137: and MEANING = lk_meaning;
1138:
1139: return buf;

Line 1149: from WF_LOOKUPS

1145: -- Case-insensitive match
1146: begin
1147: select LOOKUP_CODE
1148: into buf
1149: from WF_LOOKUPS
1150: where LOOKUP_TYPE = lk_type
1151: and upper(MEANING) = upper(lk_meaning);
1152: exception
1153: when no_data_found then

Line 1181: from WF_LOOKUPS

1177: lk_type in varchar2)
1178: return varchar2 is
1179: cursor c is
1180: select LOOKUP_CODE
1181: from WF_LOOKUPS
1182: where LOOKUP_TYPE = lk_type
1183: order by LOOKUP_CODE;
1184:
1185: buffer varchar2(32000);