DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on DUAL

Line 105: FROM dual;

101:
102: -- Selects the nextval from sequence, used later for defining event key
103: CURSOR okl_key_csr IS
104: SELECT okl_wf_item_s.nextval
105: FROM dual;
106:
107:
108: -- vsgandhi bug 12959022 15-Sep-2011
109: CURSOR c_get_org_id (p_acd_id NUMBER) IS

Line 279: FROM dual;

275:
276: -- Selects the nextval from sequence, used later for defining event key
277: CURSOR okl_key_csr IS
278: SELECT okl_wf_item_s.nextval
279: FROM dual;
280:
281: -- for debug logging
282: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
283: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 633: FROM dual;

629:
630: -- Selects the nextval from sequence, used later for defining event key
631: CURSOR okl_key_csr IS
632: SELECT okl_wf_item_s.nextval
633: FROM dual;
634:
635: l_key VARCHAR2(240);
636: l_seq NUMBER;
637: l_itemtype VARCHAR2(30) := 'OKLAMAPP';