DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on DUAL

Line 476: select IEX_PTP_WF_S.NEXTVAL from dual;

472: l_ptp_wf_item_key NUMBER;
473:
474: -- generate new iex_ptp_wf item key
475: CURSOR ptp_wf_crs IS
476: select IEX_PTP_WF_S.NEXTVAL from dual;
477: begin
478: l_wf_process := 'PROMISE_WORKFLOW';
479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
480: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: start');

Line 1079: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

1075:
1076:
1077: -- generate new promise detail
1078: CURSOR prd_genid_crs IS
1079: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1080: --Begin bug 7237026 17-Nov-2208 barathsr
1081: CURSOR c_org_id (p_del_id number) IS
1082: select org_id
1083: from iex_delinquencies_all

Line 2395: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

2391: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2392:
2393: -- generate new promise detail
2394: CURSOR prd_genid_crs IS
2395: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
2396:
2397: --Begin bug 7237026 17-Nov-2008 barathsr
2398: CURSOR c_org_id (p_del_id number) IS
2399: select org_id