eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_BUSINESS_VARIABLES_PVT dependencies on OKC_VARIABLE_DOC_TYPES

Line 507: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES

503: ) is
504: l_existing_variables_tbl variable_code_tbl_type;
505:
506: CURSOR variable_doc_assoc_csr (cp_variable_code IN VARCHAR) IS
507: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES
508: WHERE VARIABLE_CODE = cp_variable_code;
509: begin
510: delete from OKC_BUS_VARIABLES_TL
511: where VARIABLE_CODE = X_VARIABLE_CODE;

Line 531: DELETE FROM OKC_VARIABLE_DOC_TYPES

527: CLOSE variable_doc_assoc_csr;
528:
529: IF l_existing_variables_tbl.COUNT > 0 Then
530: FORALL i in l_existing_variables_tbl.FIRST .. l_existing_variables_tbl.LAST
531: DELETE FROM OKC_VARIABLE_DOC_TYPES
532: WHERE VARIABLE_CODE = l_existing_variables_tbl(i);
533: END IF;
534:
535: