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 1850: FROM OKC_ARTICLE_VERSIONS A

1846: ARTICLE_VERSION_ID,
1847: ARTICLE_VERSION_NUMBER,
1848: ARTICLE_STATUS,
1849: START_DATE
1850: FROM OKC_ARTICLE_VERSIONS A
1851: WHERE article_id = cp_article_id
1852: and start_date = (SELECT max(start_date)
1853: FROM okc_article_versions
1854: WHERE article_id = a.article_id);

Line 1853: FROM okc_article_versions

1849: START_DATE
1850: FROM OKC_ARTICLE_VERSIONS A
1851: WHERE article_id = cp_article_id
1852: and start_date = (SELECT max(start_date)
1853: FROM okc_article_versions
1854: WHERE article_id = a.article_id);
1855:
1856: -- Cursor to get article level information for V, U interface row
1857: CURSOR get_article_info_csr (cp_article_id IN NUMBER) IS

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

1944: TYPE l_inf_attribute12 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER ;
1945: TYPE l_inf_attribute13 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER ;
1946: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1951:
1952:

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

1946: TYPE l_inf_attribute14 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
1947: TYPE l_inf_attribute15 IS TABLE OF OKC_ART_INTERFACE_ALL.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
1948: TYPE l_inf_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1949: TYPE l_inf_article_version_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1950: TYPE l_inf_adoption_type IS TABLE OF OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1951:
1952:
1953:
1954: -- For Article Variables

Line 2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

2024: I NUMBER := 0;
2025: j NUMBER := 0;
2026: k NUMBER := 0;
2027: x NUMBER := 0;
2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

Line 2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

2025: j NUMBER := 0;
2026: k NUMBER := 0;
2027: x NUMBER := 0;
2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2026: k NUMBER := 0;
2027: x NUMBER := 0;
2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;

2027: x NUMBER := 0;
2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

Line 2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;

2028: l_earlier_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

Line 2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2029: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

Line 2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2030: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2031: l_start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE;
2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

Line 2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;

2032: l_tmp_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2040: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;

Line 2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2040: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2041: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2042: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;
2043: l_request_id OKC_ART_INTERFACE_ALL.REQUEST_ID%TYPE;

Line 2646: OKC_ARTICLE_VERSIONS_PVT.validate_record(

2642: ELSIF (api_return_status = G_RET_STS_ERROR) THEN
2643: l_return_status := G_RET_STS_ERROR;
2644: END IF;
2645: api_return_status :=
2646: OKC_ARTICLE_VERSIONS_PVT.validate_record(
2647: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2648: p_import_action => inf_action_tbl(i),
2649: x_earlier_adoption_type => l_earlier_adoption_type,
2650: x_earlier_version_id => l_earlier_version_id,

Line 2730: OKC_ARTICLE_VERSIONS_PVT.validate_record(

2726:
2727: -- nvl for nullable column to avoid getting database value
2728: -- in the validate API
2729: api_return_status :=
2730: OKC_ARTICLE_VERSIONS_PVT.validate_record(
2731: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2732: p_import_action => inf_action_tbl(i),
2733: x_earlier_adoption_type => l_earlier_adoption_type,
2734: x_earlier_version_id => l_earlier_version_id,

Line 3381: INSERT INTO OKC_ARTICLE_VERSIONS(

3377: BEGIN
3378: l_context := 'INSERTING NEW VERSION OF CLAUSE';
3379:
3380: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3381: INSERT INTO OKC_ARTICLE_VERSIONS(
3382: ARTICLE_VERSION_ID,
3383: ARTICLE_ID,
3384: ARTICLE_VERSION_NUMBER,
3385: ARTICLE_TEXT,

Line 3505: -- End of Insert into OKC_ARTICLE_VERSIONS

3501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3502: END;
3503:
3504: --
3505: -- End of Insert into OKC_ARTICLE_VERSIONS
3506: --
3507: --
3508:
3509: i := 0;

Line 3537: FROM OKC_ARTICLE_VERSIONS

3533: sysdate,
3534: sysdate,
3535: l_user_id,
3536: l_login_id
3537: FROM OKC_ARTICLE_VERSIONS
3538: WHERE artv_action_tbl(i) = 'N'
3539: AND article_version_id = artv_article_version_id_tbl(i);
3540:
3541: END IF;

Line 3573: UPDATE OKC_ARTICLE_VERSIONS

3569: BEGIN
3570: l_context := 'SET END DATE IN PREV. VER';
3571:
3572: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3573: UPDATE OKC_ARTICLE_VERSIONS
3574: SET END_DATE = trunc(inf_start_date_tbl(i)-1),
3575: PROGRAM_ID = l_program_id,
3576: REQUEST_ID = l_request_id,
3577: PROGRAM_LOGIN_ID = l_program_login_id,

Line 3595: -- End of Insert into OKC_ARTICLE_VERSIONS

3591: END IF;
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3593: END;
3594: --
3595: -- End of Insert into OKC_ARTICLE_VERSIONS
3596: --
3597: --
3598:
3599: i := 0;

Line 3632: UPDATE OKC_ARTICLE_VERSIONS

3628: BEGIN
3629: l_context := 'UPDATING CLAUSE END DATE FOR ACTION D ';
3630:
3631: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3632: UPDATE OKC_ARTICLE_VERSIONS
3633: SET END_DATE = trunc(inf_end_date_tbl(i)),
3634: PROGRAM_ID = l_program_id,
3635: REQUEST_ID = l_request_id,
3636: PROGRAM_LOGIN_ID = l_program_login_id,

Line 3661: UPDATE OKC_ARTICLE_VERSIONS VO SET (

3657: BEGIN
3658: l_context := 'UPDATING CLAUSE VERSION';
3659:
3660: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3661: UPDATE OKC_ARTICLE_VERSIONS VO SET (
3662: ARTICLE_TEXT,
3663: PROVISION_YN,
3664: INSERT_BY_REFERENCE,
3665: LOCK_TEXT,

Line 3764: -- End of Update OKC_ARTICLE_VERSIONS

3760: END IF;
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3762: END;
3763: --
3764: -- End of Update OKC_ARTICLE_VERSIONS
3765: --
3766: --
3767:
3768:

Line 5923: SELECT provision_yn FROM OKC_ARTICLE_VERSIONS

5919: AND orgi.organization_id = orgu.organization_id
5920: AND orgi.organization_id = cp_org_id;
5921:
5922: CURSOR l_provision_csr (cp_article_id IN NUMBER) IS
5923: SELECT provision_yn FROM OKC_ARTICLE_VERSIONS
5924: WHERE article_id = cp_article_id
5925: AND article_version_number = 1;
5926:
5927: -- Cursor to check clause in the clause interface Table