DBA Data[Home] [Help]

APPS.OKC_BUSINESS_VARIABLES_PVT dependencies on OKC_VARIABLE_DOC_TYPES

Line 584: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES

580: ) is
581: l_existing_variables_tbl variable_code_tbl_type;
582:
583: CURSOR variable_doc_assoc_csr (cp_variable_code IN VARCHAR) IS
584: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES
585: WHERE VARIABLE_CODE = cp_variable_code;
586: begin
587: delete from OKC_BUS_VARIABLES_TL
588: where VARIABLE_CODE = X_VARIABLE_CODE;

Line 608: DELETE FROM OKC_VARIABLE_DOC_TYPES

604: CLOSE variable_doc_assoc_csr;
605:
606: IF l_existing_variables_tbl.COUNT > 0 Then
607: FORALL i in l_existing_variables_tbl.FIRST .. l_existing_variables_tbl.LAST
608: DELETE FROM OKC_VARIABLE_DOC_TYPES
609: WHERE VARIABLE_CODE = l_existing_variables_tbl(i);
610: END IF;
611:
612: