APPS.OKC_CNH_PVT dependencies on OKC_ACTIONS_V

Line 777: FROM Okc_Actions_V

773: CREATION_DATE,
774: LAST_UPDATED_BY,
775: LAST_UPDATE_DATE,
776: LAST_UPDATE_LOGIN
777: FROM Okc_Actions_V
778: WHERE okc_actions_v.id = p_id;
779: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
780: CURSOR okx_counter_groups_v_pk_csr (p_counter_group_id IN NUMBER) IS
781: SELECT

Line 778: WHERE okc_actions_v.id = p_id;

774: LAST_UPDATED_BY,
775: LAST_UPDATE_DATE,
776: LAST_UPDATE_LOGIN
777: FROM Okc_Actions_V
778: WHERE okc_actions_v.id = p_id;
779: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
780: CURSOR okx_counter_groups_v_pk_csr (p_counter_group_id IN NUMBER) IS
781: SELECT
782: COUNTER_GROUP_ID,

Line 857: SELECT 'X' FROM okc_actions_v acn

853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
854: l_temp NUMBER ;
855: acn_rec VARCHAR2(1);
856: CURSOR acn_cur IS
857: SELECT 'X' FROM okc_actions_v acn
858: WHERE acn.id = p_cnhv_rec.acn_id;
859: BEGIN
860: -- initialize return status
861: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1715: l_acn_type okc_actions_v.acn_type%TYPE;

1711: ,p_cnhv_rec IN cnhv_rec_type)
1712: IS
1713:
1714: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1715: l_acn_type okc_actions_v.acn_type%TYPE;
1716: BEGIN
1717: -- initialize return status
1718: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1719:

Line 1762: select acn.acn_type into l_acn_type from okc_actions_v acn

1758: END IF;
1759:
1760: -- verify if cnh_type corresponds to acn_type
1761: IF p_cnhv_rec.cnh_type = 'ABC' THEN
1762: select acn.acn_type into l_acn_type from okc_actions_v acn
1763: where acn.id = p_cnhv_rec.acn_id;
1764: IF l_acn_type <> 'ABA' THEN
1765: -- notify caller of an error
1766: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1771: select acn.acn_type into l_acn_type from okc_actions_v acn

1767: -- halt further validation of this column
1768: RAISE G_EXCEPTION_HALT_VALIDATION;
1769: END IF;
1770: ELSIF p_cnhv_rec.cnh_type = 'DBC' THEN
1771: select acn.acn_type into l_acn_type from okc_actions_v acn
1772: where acn.id = p_cnhv_rec.acn_id;
1773: IF l_acn_type <> 'DBA' THEN
1774: -- notify caller of an error
1775: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 2245: FROM Okc_Actions_V

2241: item_not_found_error EXCEPTION;
2242:
2243: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
2244: SELECT '1'
2245: FROM Okc_Actions_V
2246: WHERE okc_actions_v.id = p_id;
2247: l_dummy_var VARCHAR2(1);
2248: l_dummy VARCHAR2(1);
2249: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2246: WHERE okc_actions_v.id = p_id;

2242:
2243: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
2244: SELECT '1'
2245: FROM Okc_Actions_V
2246: WHERE okc_actions_v.id = p_id;
2247: l_dummy_var VARCHAR2(1);
2248: l_dummy VARCHAR2(1);
2249: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2250: l_row_notfound BOOLEAN := TRUE;