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 1835: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART

1831: --Clause editing in word
1832: INTRFC.EDITED_IN_WORD,
1833: INTRFC.ARTICLE_TEXT_IN_WORD,
1834: TO_NUMBER(NULL) ARTICLE_VERSION_ID
1835: FROM OKC_ART_INTERFACE_ALL INTRFC, OKC_ARTICLES_ALL ART
1836: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
1837: AND INTRFC.ORG_ID = cp_local_org_id
1838: AND BATCH_NUMBER = cp_batch_number
1839: AND RTRIM(INTRFC.ARTICLE_TITLE) = ART.ARTICLE_TITLE(+)

Line 1866: FROM OKC_ARTICLES_ALL

1862: CURSOR get_article_info_csr (cp_article_id IN NUMBER) IS
1863: SELECT
1864: ARTICLE_INTENT,
1865: ARTICLE_LANGUAGE
1866: FROM OKC_ARTICLES_ALL
1867: WHERE ARTICLE_ID = cp_article_id;
1868:
1869: -- Cursor to validate article type
1870: -- If article type is not active any more but it is not valid

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

1910: TYPE l_inf_article_number IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
1911: TYPE l_inf_article_intent IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
1912: TYPE l_inf_article_language IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
1913: TYPE l_inf_article_type IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
1914: TYPE l_inf_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1915: TYPE l_inf_art_reference_code IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1916: TYPE l_inf_art_reference_id1 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
1917: TYPE l_inf_art_reference_id2 IS TABLE OF OKC_ART_INTERFACE_ALL.ART_SYSTEM_REFERENCE_ID2%TYPE INDEX BY BINARY_INTEGER ;
1918: TYPE l_inf_article_text IS TABLE OF OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

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

Line 2647: OKC_ARTICLES_ALL_PVT.VALIDATE_RECORD(

2643:
2644: -- Validate attrs of the interface row
2645: IF inf_action_tbl(i) = 'N' THEN
2646: api_return_status :=
2647: OKC_ARTICLES_ALL_PVT.VALIDATE_RECORD(
2648: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2649: p_import_action => inf_action_tbl(i),
2650: p_article_id => inf_article_id_tbl(i),
2651: p_article_title => inf_article_title_tbl(i),

Line 3357: INSERT INTO OKC_ARTICLES_ALL(

3353: BEGIN
3354: l_context := 'INSERTING NEW CLAUSE';
3355:
3356: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3357: INSERT INTO OKC_ARTICLES_ALL(
3358: ARTICLE_ID,
3359: ARTICLE_TITLE,
3360: ORG_ID,
3361: ARTICLE_NUMBER,

Line 3423: -- End of Insert into OKC_ARTICLES_ALL

3419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3420: END;
3421:
3422: --
3423: -- End of Insert into OKC_ARTICLES_ALL
3424: --
3425: --
3426:
3427: i := 0;

Line 3548: FROM OKC_ARTICLES_ALL

3544: sysdate,
3545: l_user_id,
3546: l_login_id,
3547: sysdate
3548: FROM OKC_ARTICLES_ALL
3549: WHERE inf_action_tbl(i) IN ( 'N', 'V')
3550: AND inf_process_status_tbl(i) in ('S', 'W')
3551: AND article_id = inf_article_id_tbl(i);
3552:

Line 3661: UPDATE OKC_ARTICLES_ALL

3657: BEGIN
3658: l_context := 'UPDATING CLAUSE TYPE FOR ACTION V AND U';
3659:
3660: FORALL i in inf_interface_id_tbl.FIRST ..inf_interface_id_tbl.LAST
3661: UPDATE OKC_ARTICLES_ALL
3662: SET ARTICLE_TYPE = inf_article_type_tbl(i),
3663: PROGRAM_ID = l_program_id,
3664: REQUEST_ID = l_request_id,
3665: PROGRAM_LOGIN_ID = l_program_login_id,

Line 5963: OKC_ARTICLES_ALL RELS, OKC_ARTICLES_ALL RELT

5959: RELS.ARTICLE_ID SOURCE_ARTICLE_ID ,
5960: RELT.ARTICLE_INTENT TARGET_INTENT,
5961: RELT.ARTICLE_ID TARGET_ARTICLE_ID
5962: FROM OKC_ART_RELS_INTERFACE RELINT,
5963: OKC_ARTICLES_ALL RELS, OKC_ARTICLES_ALL RELT
5964: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
5965: AND BATCH_NUMBER = cp_batch_number
5966: AND RELINT.ORG_ID = cp_local_org_id
5967: AND RELINT.SOURCE_ARTICLE_TITLE = RELS.ARTICLE_TITLE(+)

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

6015: TYPE l_rinf_relationship_type IS TABLE OF OKC_ART_RELS_INTERFACE.RELATIONSHIP_TYPE%TYPE INDEX BY BINARY_INTEGER ;
6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6021: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6022: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6023:

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

6016: TYPE l_rinf_process_status IS TABLE OF OKC_ART_RELS_INTERFACE.PROCESS_STATUS%TYPE INDEX BY BINARY_INTEGER ;
6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6021: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6022: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6023:
6024:

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

6017: TYPE l_rinf_action IS TABLE OF OKC_ART_RELS_INTERFACE.ACTION%TYPE INDEX BY BINARY_INTEGER ;
6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6021: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6022: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6023:
6024:
6025: l_return_status VARCHAR2(1);

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

6018:
6019: TYPE l_rinf_source_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6020: TYPE l_rinf_source_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6021: TYPE l_rinf_target_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
6022: TYPE l_rinf_target_intent IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE INDEX BY BINARY_INTEGER ;
6023:
6024:
6025: l_return_status VARCHAR2(1);
6026: l_error_index NUMBER := 1;

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