APPS.OKL_POC_PVT dependencies on OKL_POOL_TRANSACTIONS_V

Line 825: FROM OKL_POOL_TRANSACTIONS_V

821:
822: -- Cursor For OKL_POL_KHR_FK;
823: CURSOR okl_poxv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pox_id%TYPE) IS
824: SELECT '1'
825: FROM OKL_POOL_TRANSACTIONS_V
826: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
827:
828: BEGIN
829: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 826: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;

822: -- Cursor For OKL_POL_KHR_FK;
823: CURSOR okl_poxv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pox_id%TYPE) IS
824: SELECT '1'
825: FROM OKL_POOL_TRANSACTIONS_V
826: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
827:
828: BEGIN
829: x_return_status := OKL_API.G_RET_STS_SUCCESS;
830:

Line 901: FROM OKL_POOL_TRANSACTIONS_V

897:
898: -- Cursor For OKL_CURRENCIES;
899: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_in%TYPE) IS
900: SELECT '1'
901: FROM OKL_POOL_TRANSACTIONS_V
902: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
903:
904:
905: BEGIN

Line 902: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;

898: -- Cursor For OKL_CURRENCIES;
899: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_in%TYPE) IS
900: SELECT '1'
901: FROM OKL_POOL_TRANSACTIONS_V
902: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
903:
904:
905: BEGIN
906: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 949: FROM OKL_POOL_TRANSACTIONS_V

945:
946: -- Cursor For OKL_CURRENCIES;
947: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_out%TYPE) IS
948: SELECT '1'
949: FROM OKL_POOL_TRANSACTIONS_V
950: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
951:
952: BEGIN
953: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 950: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;

946: -- Cursor For OKL_CURRENCIES;
947: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_out%TYPE) IS
948: SELECT '1'
949: FROM OKL_POOL_TRANSACTIONS_V
950: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
951:
952: BEGIN
953: x_return_status := OKL_API.G_RET_STS_SUCCESS;
954: IF (p_transaction_number_out = OKL_API.G_MISS_NUM AND p_transaction_number_out IS NOT NULL)