DBA Data[Home] [Help]

APPS.OKC_AAE_PVT dependencies on OKC_ACTIONS_V

Line 659: FROM Okc_Actions_V

655: CREATION_DATE,
656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Actions_V
660: WHERE okc_actions_v.id = p_id;
661: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
663: l_row_notfound BOOLEAN := TRUE;

Line 660: WHERE okc_actions_v.id = p_id;

656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Actions_V
660: WHERE okc_actions_v.id = p_id;
661: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
663: l_row_notfound BOOLEAN := TRUE;
664: BEGIN

Line 1719: FROM Okc_Actions_V

1715: item_not_found_error EXCEPTION;
1716:
1717: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
1718: SELECT '1'
1719: FROM Okc_Actions_V
1720: WHERE okc_actions_v.id = p_id;
1721:
1722: l_dummy_var VARCHAR2(1);
1723:

Line 1720: WHERE okc_actions_v.id = p_id;

1716:
1717: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
1718: SELECT '1'
1719: FROM Okc_Actions_V
1720: WHERE okc_actions_v.id = p_id;
1721:
1722: l_dummy_var VARCHAR2(1);
1723:
1724: CURSOR okc_aalv_pk_csr (p_id IN NUMBER) IS