DBA Data[Home] [Help]

APPS.POS_ORDER_MODIFIERS_PKG dependencies on DUAL

Line 23: into l_seq from sys.dual;

19: BEGIN
20:
21: /* Update PO_ASL_ATTRIBUTES form ISP */
22: select POS_ORDER_MODIFIERS_TEMP_ID_S.NEXTVAL
23: into l_seq from sys.dual;
24:
25: insert into POS_ORDER_MODIFIERS_TEMP (
26: order_mod_request_id,
27: asl_id,

Line 94: into l_seq from sys.dual;

90: return;
91: end if;
92:
93: select to_char(POS_ASL_UPD_ITEMKEY_S.NEXTVAL)
94: into l_seq from sys.dual;
95:
96: l_itemkey:=to_char(p_asl_id)||'-'||l_seq;
97:
98: wf_engine.createProcess ( ItemType => l_ItemType,