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_ARTICLES_ALL

Line 1334: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

1330: p_object_type IN VARCHAR2,
1331: x_object_id OUT NOCOPY NUMBER
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

Line 1832: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART

1828: INTRFC.ATTRIBUTE13 ,
1829: INTRFC.ATTRIBUTE14 ,
1830: INTRFC.ATTRIBUTE15,
1831: TO_NUMBER(NULL) ARTICLE_VERSION_ID
1832: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART
1833: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
1834: AND INTRFC.ORG_ID = cp_local_org_id
1835: AND BATCH_NUMBER = cp_batch_number
1836: AND RTRIM(INTRFC.ARTICLE_TITLE) = ART.ARTICLE_TITLE(+)

Line 1861: FROM OKC_ARTICLES_ALL

1857: CURSOR get_article_info_csr (cp_article_id IN NUMBER) IS
1858: SELECT
1859: ARTICLE_INTENT,
1860: ARTICLE_LANGUAGE
1861: FROM OKC_ARTICLES_ALL
1862: WHERE ARTICLE_ID = cp_article_id;
1863:
1864: -- Cursor to validate article type
1865: -- If article type is not active any more but it is not valid

Line 1909: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

1905: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1906: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1907: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1908: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1909: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1910: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

Line 2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%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;
2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

Line 2605: OKC_ARTICLES_ALL_PVT.VALIDATE_RECORD(

2601:
2602: -- Validate attrs of the interface row
2603: IF inf_action_tbl(i) = 'N' THEN
2604: api_return_status :=
2605: OKC_ARTICLES_ALL_PVT.VALIDATE_RECORD(
2606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2607: p_import_action => inf_action_tbl(i),
2608: p_article_id => inf_article_id_tbl(i),
2609: p_article_title => inf_article_title_tbl(i),

Line 3306: INSERT INTO OKC_ARTICLES_ALL(

3302: BEGIN
3303: l_context := 'INSERTING NEW CLAUSE';
3304:
3305: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3306: INSERT INTO OKC_ARTICLES_ALL(
3307: ARTICLE_ID,
3308: ARTICLE_TITLE,
3309: ORG_ID,
3310: ARTICLE_NUMBER,

Line 3372: -- End of Insert into OKC_ARTICLES_ALL

3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3369: END;
3370:
3371: --
3372: -- End of Insert into OKC_ARTICLES_ALL
3373: --
3374: --
3375:
3376: i := 0;

Line 3491: FROM OKC_ARTICLES_ALL

3487: sysdate,
3488: l_user_id,
3489: l_login_id,
3490: sysdate
3491: FROM OKC_ARTICLES_ALL
3492: WHERE inf_action_tbl(i) IN ( 'N', 'V')
3493: AND inf_process_status_tbl(i) in ('S', 'W')
3494: AND article_id = inf_article_id_tbl(i);
3495:

Line 3604: UPDATE OKC_ARTICLES_ALL

3600: BEGIN
3601: l_context := 'UPDATING CLAUSE TYPE FOR ACTION V AND U';
3602:
3603: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3604: UPDATE OKC_ARTICLES_ALL
3605: SET ARTICLE_TYPE = inf_article_type_tbl(i),
3606: PROGRAM_ID = l_program_id,
3607: REQUEST_ID = l_request_id,
3608: PROGRAM_LOGIN_ID = l_program_login_id,

Line 5895: OKC_ARTICLES_ALL RELS, OKC_ARTICLES_ALL RELT

5891: RELS.ARTICLE_ID SOURCE_ARTICLE_ID ,
5892: RELT.ARTICLE_INTENT TARGET_INTENT,
5893: RELT.ARTICLE_ID TARGET_ARTICLE_ID
5894: FROM OKC_ART_RELS_INTERFACE RELINT,
5895: OKC_ARTICLES_ALL RELS, OKC_ARTICLES_ALL RELT
5896: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
5897: AND BATCH_NUMBER = cp_batch_number
5898: AND RELINT.ORG_ID = cp_local_org_id
5899: AND RELINT.SOURCE_ARTICLE_TITLE = RELS.ARTICLE_TITLE(+)

Line 5951: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

5947: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
5948: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
5949: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
5950:
5951: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5952: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5953: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5954: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5955:

Line 5952: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

5948: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
5949: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
5950:
5951: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5952: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5953: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5954: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5955:
5956:

Line 5953: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

5949: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
5950:
5951: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5952: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5953: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5954: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5955:
5956:
5957: l_return_status VARCHAR2(1);

Line 5954: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;

5950:
5951: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5952: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5953: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
5954: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
5955:
5956:
5957: l_return_status VARCHAR2(1);
5958: l_error_index NUMBER := 1;