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_VERSIONS

Line 1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

1332: ) RETURN VARCHAR2 IS
1333: CURSOR l_art_csr IS
1334: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
1335: CURSOR l_ver_csr IS
1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
1337: BEGIN
1338: IF (l_debug = 'Y') THEN
1339: Okc_Debug.Log('100: Entered get_seq_id', 2);
1340: END IF;

Line 1855: FROM OKC_ARTICLE_VERSIONS A

1851: ARTICLE_STATUS,
1852: START_DATE,
1853: --Clause Editing
1854: EDITED_IN_WORD
1855: FROM OKC_ARTICLE_VERSIONS A
1856: WHERE article_id = cp_article_id
1857: and start_date = (SELECT max(start_date)
1858: FROM okc_article_versions
1859: WHERE article_id = a.article_id);

Line 1858: FROM okc_article_versions

1854: EDITED_IN_WORD
1855: FROM OKC_ARTICLE_VERSIONS A
1856: WHERE article_id = cp_article_id
1857: and start_date = (SELECT max(start_date)
1858: FROM okc_article_versions
1859: WHERE article_id = a.article_id);
1860:
1861: -- Cursor to get article level information for V, U interface row
1862: CURSOR get_article_info_csr (cp_article_id IN NUMBER) IS

Line 1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

1952: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1953: --Clause Editing
1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%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 ;

Line 1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;

1954: TYPE l_inf_edited_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.EDITED_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1955: TYPE l_inf_article_text_in_word IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER ;
1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%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

Line 1960: -- TYPE l_inf_variable_code IS TABLE OF OKC_ARTICLE_VERSIONS.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;

1956: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1957: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1958: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%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 ;

Line 2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

2037: I NUMBER := 0;
2038: j NUMBER := 0;
2039: k NUMBER := 0;
2040: x NUMBER := 0;
2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

Line 2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

2038: j NUMBER := 0;
2039: k NUMBER := 0;
2040: x NUMBER := 0;
2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2039: k NUMBER := 0;
2040: x NUMBER := 0;
2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

2040: x NUMBER := 0;
2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;

2041: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

Line 2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2042: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2043: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

Line 2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2044: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2045: l_edited_in_word OKC_ARTICLE_VERSIONS.EDITED_IN_WORD%TYPE;
2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

Line 2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2046: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;

Line 2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2057: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;

Line 2688: OKC_ARTICLE_VERSIONS_PVT.validate_record(

2684: ELSIF (api_return_status = G_RET_STS_ERROR) THEN
2685: l_return_status := G_RET_STS_ERROR;
2686: END IF;
2687: api_return_status :=
2688: OKC_ARTICLE_VERSIONS_PVT.validate_record(
2689: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2690: p_import_action => inf_action_tbl(i),
2691: x_earlier_adoption_type => l_earlier_adoption_type,
2692: x_earlier_version_id => l_earlier_version_id,

Line 2777: OKC_ARTICLE_VERSIONS_PVT.validate_record(

2773:
2774: -- nvl for nullable column to avoid getting database value
2775: -- in the validate API
2776: api_return_status :=
2777: OKC_ARTICLE_VERSIONS_PVT.validate_record(
2778: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2779: p_import_action => inf_action_tbl(i),
2780: x_earlier_adoption_type => l_earlier_adoption_type,
2781: x_earlier_version_id => l_earlier_version_id,

Line 3432: INSERT INTO OKC_ARTICLE_VERSIONS(

3428: BEGIN
3429: l_context := 'INSERTING NEW VERSION OF CLAUSE';
3430:
3431: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3432: INSERT INTO OKC_ARTICLE_VERSIONS(
3433: ARTICLE_VERSION_ID,
3434: ARTICLE_ID,
3435: ARTICLE_VERSION_NUMBER,
3436: ARTICLE_TEXT,

Line 3562: -- End of Insert into OKC_ARTICLE_VERSIONS

3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3559: END;
3560:
3561: --
3562: -- End of Insert into OKC_ARTICLE_VERSIONS
3563: --
3564: --
3565:
3566: i := 0;

Line 3594: FROM OKC_ARTICLE_VERSIONS

3590: sysdate,
3591: sysdate,
3592: l_user_id,
3593: l_login_id
3594: FROM OKC_ARTICLE_VERSIONS
3595: WHERE artv_action_tbl(i) = 'N'
3596: AND article_version_id = artv_article_version_id_tbl(i);
3597:
3598: END IF;

Line 3630: UPDATE OKC_ARTICLE_VERSIONS

3626: BEGIN
3627: l_context := 'SET END DATE IN PREV. VER';
3628:
3629: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3630: UPDATE OKC_ARTICLE_VERSIONS
3631: SET END_DATE = trunc(inf_start_date_tbl(i)-1),
3632: PROGRAM_ID = l_program_id,
3633: REQUEST_ID = l_request_id,
3634: PROGRAM_LOGIN_ID = l_program_login_id,

Line 3652: -- End of Insert into OKC_ARTICLE_VERSIONS

3648: END IF;
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3650: END;
3651: --
3652: -- End of Insert into OKC_ARTICLE_VERSIONS
3653: --
3654: --
3655:
3656: i := 0;

Line 3689: UPDATE OKC_ARTICLE_VERSIONS

3685: BEGIN
3686: l_context := 'UPDATING CLAUSE END DATE FOR ACTION D ';
3687:
3688: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3689: UPDATE OKC_ARTICLE_VERSIONS
3690: SET END_DATE = trunc(inf_end_date_tbl(i)),
3691: PROGRAM_ID = l_program_id,
3692: REQUEST_ID = l_request_id,
3693: PROGRAM_LOGIN_ID = l_program_login_id,

Line 3718: UPDATE OKC_ARTICLE_VERSIONS VO SET (

3714: BEGIN
3715: l_context := 'UPDATING CLAUSE VERSION';
3716:
3717: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3718: UPDATE OKC_ARTICLE_VERSIONS VO SET (
3719: ARTICLE_TEXT,
3720: PROVISION_YN,
3721: INSERT_BY_REFERENCE,
3722: LOCK_TEXT,

Line 3827: -- End of Update OKC_ARTICLE_VERSIONS

3823: END IF;
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3825: END;
3826: --
3827: -- End of Update OKC_ARTICLE_VERSIONS
3828: --
3829: --
3830:
3831:

Line 5991: SELECT provision_yn FROM OKC_ARTICLE_VERSIONS

5987: AND orgi.organization_id = orgu.organization_id
5988: AND orgi.organization_id = cp_org_id;
5989:
5990: CURSOR l_provision_csr (cp_article_id IN NUMBER) IS
5991: SELECT provision_yn FROM OKC_ARTICLE_VERSIONS
5992: WHERE article_id = cp_article_id
5993: AND article_version_number = 1;
5994:
5995: -- Cursor to check clause in the clause interface Table

Line 9236: FROM okc_articles_all art,okc_scn_map_interface intf,fnd_flex_values flx,okc_bus_variables_b bus,okc_article_versions av

9232: l_scn_code OKC_ART_VAR_SECTIONS.SCN_CODE%TYPE;
9233:
9234: CURSOR okc_art_var_ins_csr(p_article_title IN VARCHAR2,p_batch_number IN VARCHAR2,p_org_id IN NUMBER,p_variable_value IN VARCHAR2) IS
9235: SELECT art.article_id,av.article_version_id,art.variable_code,intf.variable_value,flx.flex_value_id,intf.scn_code
9236: FROM okc_articles_all art,okc_scn_map_interface intf,fnd_flex_values flx,okc_bus_variables_b bus,okc_article_versions av
9237: WHERE art.article_title = intf.article_title
9238: AND art.org_id=intf.org_id
9239: AND art.variable_code = bus.variable_code
9240: AND bus.value_set_id = flx.flex_value_set_id