APPS.OKC_ARTICLES_IMPORT_GRP dependencies on OKC_ARTICLE_VARIABLES

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

1951:
1952:
1953:
1954: -- For Article Variables
1955: TYPE list_artv_article_version_id IS TABLE OF OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE list_artv_variable_code IS TABLE OF OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE list_artv_action IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
1958:
1959: l_article_language VARCHAR2(3);

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

1952:
1953:
1954: -- For Article Variables
1955: TYPE list_artv_article_version_id IS TABLE OF OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE list_artv_variable_code IS TABLE OF OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE list_artv_action IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
1958:
1959: l_article_language VARCHAR2(3);
1960:

Line 3517: INSERT INTO OKC_ARTICLE_VARIABLES

3513:
3514: i := 0;
3515:
3516: FORALL i in artv_variable_code_tbl.FIRST .. artv_variable_code_tbl.LAST
3517: INSERT INTO OKC_ARTICLE_VARIABLES
3518: (
3519: ARTICLE_VERSION_ID ,
3520: VARIABLE_CODE ,
3521: OBJECT_VERSION_NUMBER ,

Line 3546: DELETE FROM OKC_ARTICLE_VARIABLES

3542:
3543: IF artv_variable_code_tbl.COUNT > 0 Then
3544: l_context := 'DELETE ASSOCIATION FOR VARIABLES';
3545: FORALL i in artv_variable_code_tbl.FIRST .. artv_variable_code_tbl.LAST
3546: DELETE FROM OKC_ARTICLE_VARIABLES
3547: WHERE VARIABLE_CODE = artv_variable_code_tbl(i)
3548: AND ARTICLE_VERSION_ID = artv_article_version_id_tbl(i)
3549: AND artv_action_tbl(i) = 'D';
3550: END IF;