DBA Data[Home] [Help]

APPS.OKL_CIN_PVT dependencies on DUAL

Line 67: -- CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_all_s.NEXTVAL FROM DUAL;

63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: --start:| May 3, 2007 cklee -- fixed sequence issue | |
67: -- CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_all_s.NEXTVAL FROM DUAL;
68: CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_s.NEXTVAL FROM DUAL;
69: --end:| May 3, 2007 cklee -- fixed sequence issue | |
70: BEGIN
71: /* Fetch the pk value from the sequence */

Line 68: CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_s.NEXTVAL FROM DUAL;

64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: --start:| May 3, 2007 cklee -- fixed sequence issue | |
67: -- CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_all_s.NEXTVAL FROM DUAL;
68: CURSOR c_pk_csr IS SELECT okl_cnsld_ap_invs_s.NEXTVAL FROM DUAL;
69: --end:| May 3, 2007 cklee -- fixed sequence issue | |
70: BEGIN
71: /* Fetch the pk value from the sequence */
72: OPEN c_pk_csr;