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_ARTICLES_IMPORT_GRP dependencies on OKC_ARTICLE_VARIABLES

Line 1963: TYPE list_artv_article_version_id IS TABLE OF OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

1959: --clm
1960: -- TYPE l_inf_variable_code IS TABLE OF OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1961:
1962: -- For Article Variables
1963: TYPE list_artv_article_version_id IS TABLE OF OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1964: TYPE list_artv_variable_code IS TABLE OF OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1965: TYPE list_artv_action IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
1966:
1967: l_article_language VARCHAR2(3);

Line 1964: TYPE list_artv_variable_code IS TABLE OF OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;

1960: -- TYPE l_inf_variable_code IS TABLE OF OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1961:
1962: -- For Article Variables
1963: TYPE list_artv_article_version_id IS TABLE OF OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1964: TYPE list_artv_variable_code IS TABLE OF OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1965: TYPE list_artv_action IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
1966:
1967: l_article_language VARCHAR2(3);
1968:

Line 3574: INSERT INTO OKC_ARTICLE_VARIABLES

3570:
3571: i := 0;
3572:
3573: FORALL i in artv_variable_code_tbl.FIRST .. artv_variable_code_tbl.LAST
3574: INSERT INTO OKC_ARTICLE_VARIABLES
3575: (
3576: ARTICLE_VERSION_ID ,
3577: VARIABLE_CODE ,
3578: OBJECT_VERSION_NUMBER ,

Line 3603: DELETE FROM OKC_ARTICLE_VARIABLES

3599:
3600: IF artv_variable_code_tbl.COUNT > 0 Then
3601: l_context := 'DELETE ASSOCIATION FOR VARIABLES';
3602: FORALL i in artv_variable_code_tbl.FIRST .. artv_variable_code_tbl.LAST
3603: DELETE FROM OKC_ARTICLE_VARIABLES
3604: WHERE VARIABLE_CODE = artv_variable_code_tbl(i)
3605: AND ARTICLE_VERSION_ID = artv_article_version_id_tbl(i)
3606: AND artv_action_tbl(i) = 'D';
3607: END IF;