APPS.IEX_WF_DEL_CUR_STATUS_NOTE_PUB dependencies on DUAL

Line 248: from dual ;

244: END IF;
245:
246: select 'LIT_' || to_char(IEX_DEL_WF_S.Nextval)
247: INTO v_itemkey
248: from dual ;
249:
250: -- Setting all Numeric Attributes.
251: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_type_id ;
252: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_owner_id ;

Line 334: from dual ;

330: END IF;
331:
332: select 'BAN_' || to_char(IEX_DEL_WF_S.Nextval)
333: INTO v_itemkey
334: from dual ;
335:
336: -- Setting all Numeric Attributes.
337: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_type_id ;
338: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_owner_id ;

Line 415: from dual ;

411: END IF;
412:
413: select 'WRI_' || to_char(IEX_DEL_WF_S.Nextval)
414: INTO v_itemkey
415: from dual ;
416:
417: -- Setting all Numeric Attributes.
418: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_type_id ;
419: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_owner_id ;

Line 495: from dual ;

491: END IF;
492:
493: select 'REP_' || to_char(IEX_DEL_WF_S.Nextval)
494: INTO v_itemkey
495: from dual ;
496:
497: -- Setting all Numeric Attributes.
498: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_type_id ;
499: p_wf_item_number_value(p_wf_item_number_value.LAST + 1) := l_owner_id ;