DBA Data[Home] [Help]

APPS.OKC_AAV_PVT dependencies on OKC_ACTION_ATTRIBUTES_V

Line 463: FROM Okc_Action_Attributes_V

459: ) RETURN VARCHAR2 IS
460: item_not_found_error EXCEPTION;
461: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
462: SELECT '1'
463: FROM Okc_Action_Attributes_V
464: WHERE okc_action_attributes_v.id = p_id;
465:
466: l_dummy_var VARCHAR2(1);
467:

Line 464: WHERE okc_action_attributes_v.id = p_id;

460: item_not_found_error EXCEPTION;
461: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
462: SELECT '1'
463: FROM Okc_Action_Attributes_V
464: WHERE okc_action_attributes_v.id = p_id;
465:
466: l_dummy_var VARCHAR2(1);
467:
468: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS

Line 659: FROM Okc_Action_Attributes_V

655: CREATION_DATE,
656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Action_Attributes_V
660: WHERE okc_action_attributes_v.id = p_id;
661: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
662: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
663: SELECT

Line 660: WHERE okc_action_attributes_v.id = p_id;

656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Action_Attributes_V
660: WHERE okc_action_attributes_v.id = p_id;
661: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
662: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
663: SELECT
664: ID,

Line 2144: -- Procedure for mass insert in OKC_ACTION_ATTRIBUTES_VALS _B and TL tables

2140: '_PVT'
2141: );
2142: END delete_row;
2143: ---------------------------------------------------------------
2144: -- Procedure for mass insert in OKC_ACTION_ATTRIBUTES_VALS _B and TL tables
2145: ---------------------------------------------------------------
2146: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_aavv_tbl aavv_tbl_type) IS
2147: l_tabsize NUMBER := p_aavv_tbl.COUNT;
2148: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;