DBA Data[Home] [Help]

APPS.PON_AUCTION_APPROVAL_PKG dependencies on DUAL

Line 518: into l_seq from sys.dual;

514:
515: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);
516:
517: select to_char(PON_AUCTION_WF_APPROVALS_S.NEXTVAL)
518: into l_seq from sys.dual;
519:
520: l_itemKey := to_char (p_auction_header_id)|| '-' || l_seq;
521:
522: wf_engine.createProcess ( itemType => l_itemType,

Line 1045: from dual;

1041: end if;
1042:
1043: select sysdate+((l_reminder_date - sysdate) * l_timeout_factor)
1044: into l_reminder_date
1045: from dual;
1046:
1047: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1048: itemkey => l_itemKey,
1049: aname => 'TIMEOUT_USERPROCESS',

Line 2331: FROM dual;

2327: END IF;
2328:
2329: SELECT SYSDATE + ((l_reminder_date - SYSDATE) * l_timeout_factor)
2330: INTO l_reminder_date
2331: FROM dual;
2332:
2333:
2334: wf_engine.SetItemAttrDate( itemtype => l_itemType
2335: , itemkey => l_itemKey