DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on DUAL

Line 491: select IEX_PTP_WF_S.NEXTVAL from dual;

487: l_ptp_wf_item_key NUMBER;
488:
489: -- generate new iex_ptp_wf item key
490: CURSOR ptp_wf_crs IS
491: select IEX_PTP_WF_S.NEXTVAL from dual;
492: begin
493: l_wf_process := 'PROMISE_WORKFLOW';
494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
495: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: start');

Line 1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

1090:
1091:
1092: -- generate new promise detail
1093: CURSOR prd_genid_crs IS
1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1095: --Begin bug 7237026 17-Nov-2208 barathsr
1096: CURSOR c_org_id (p_del_id number) IS
1097: select org_id
1098: from iex_delinquencies_all

Line 2496: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

2492: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2493:
2494: -- generate new promise detail
2495: CURSOR prd_genid_crs IS
2496: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
2497:
2498: --Begin bug 7237026 17-Nov-2008 barathsr
2499: CURSOR c_org_id (p_del_id number) IS
2500: select org_id