100:
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
274: --19-jul-2007 ansethur R12B XML Publisher ends
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';
628: resultout OUT NOCOPY VARCHAR2 )IS
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;