DBA Data[Home] [Help]

APPS.POS_UPDATE_CAPACITY_PKG dependencies on DUAL

Line 44: into l_seq from sys.dual;

40: BEGIN
41:
42: /* Update PO_ASL_ATTRIBUTES form ISP */
43: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL
44: into l_seq from sys.dual;
45:
46: insert into POS_MFG_CAPACITY_TEMP (
47: mfg_capacity_id,
48: asl_id,

Line 120: into l_seq from sys.dual;

116: BEGIN
117:
118: /* Update PO_ASL_ATTRIBUTES form ISP */
119: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL
120: into l_seq from sys.dual;
121:
122: insert into POS_CAPACITY_TOLERANCE_TEMP(
123: capacity_tolerance_id,
124: asl_id,

Line 213: into l_seq from sys.dual;

209: return;
210: end if;
211:
212: select to_char(POS_ASL_UPD_ITEMKEY_S.NEXTVAL)
213: into l_seq from sys.dual;
214:
215: l_itemkey:=to_char(p_asl_id)||'-'||l_seq;
216:
217: wf_engine.createProcess ( ItemType => l_ItemType,