DBA Data[Home] [Help]

APPS.MSC_WS_NOTIFICATION_BPEL dependencies on MFG_LOOKUPS

Line 139: from mfg_lookups

135: begin
136: actTypeId := wf_engine.getitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE_ID');
137:
138: select meaning into actType
139: from mfg_lookups
140: where lookup_type = 'MSC_PROCESS_ACTIVITY_TYPES'
141: and lookup_code = to_number(actTypeId);
142:
143: wf_engine.setitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE', actType);

Line 207: from mfg_lookups

203: -- 1 => 'Primary Owner'
204: -- 2 => 'Alternate Owner'
205:
206: select meaning into escLevel
207: from mfg_lookups
208: where lookup_type = 'MSC_ESCALATION_LEVEL'
209: and lookup_code = to_number(escId);
210:
211: wf_engine.setitemattrtext(itemtype, itemkey, 'ESCALATION_LEVEL', escLevel);