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_BUS_VARIABLES_TL

Line 1897: OKC_BUS_VARIABLES_TL BVT

1893: CURSOR l_var_name_csr (cp_variable_code IN VARCHAR2,
1894: cp_lang IN VARCHAR2) IS
1895: SELECT BVT.VARIABLE_NAME
1896: FROM
1897: OKC_BUS_VARIABLES_TL BVT
1898: WHERE BVT.VARIABLE_CODE = cp_variable_code
1899: AND BVT.LANGUAGE = cp_lang;
1900:
1901: -- Interface Rows

Line 2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%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;
2058: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2059: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2060: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
2061: l_return_status VARCHAR2(1);
2062: api_return_status VARCHAR2(1);

Line 4450: OKC_BUS_VARIABLES_TL VARTL

4446: VAR.VARIABLE_CODE EXISTING_CODE,
4447: VAR.DATE_PUBLISHED EXISTING_DPUBLISHED,
4448: VARTL.LANGUAGE EXISTING_LANGUAGE
4449: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,
4450: OKC_BUS_VARIABLES_TL VARTL
4451: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
4452: AND BATCH_NUMBER = cp_batch_number
4453: AND RTRIM(VARINT.VARIABLE_CODE) = VAR.VARIABLE_CODE(+)
4454: AND RTRIM(VARINT.VARIABLE_CODE) = VARTL.VARIABLE_CODE(+)

Line 4470: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL

4466: CURSOR get_var_unq_csr (cp_var_name IN VARCHAR2,
4467: cp_var_intent IN VARCHAR2) IS
4468: SELECT
4469: '1'
4470: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL
4471: WHERE B.VARIABLE_CODE = TL.VARIABLE_CODE AND
4472: B.VARIABLE_INTENT = cp_var_intent AND
4473: TL.VARIABLE_NAME = cp_var_name;
4474:

Line 4480: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL

4476:
4477: CURSOR get_var_info_csr (cp_var_code IN VARCHAR2 ) IS
4478: SELECT
4479: '1'
4480: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL
4481: WHERE B.VARIABLE_CODE = TL.VARIABLE_CODE AND
4482: B.VARIABLE_CODE = cp_var_code;
4483:
4484: -- Cursor to derive value set id from value set name

Line 4556: TYPE l_vinf_existing_language IS TABLE OF OKC_BUS_VARIABLES_TL.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;

4552:
4553: TYPE l_vinf_existing_code IS TABLE OF OKC_BUS_VARIABLES_B.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4554: TYPE l_vinf_existing_dpublished IS TABLE OF OKC_BUS_VARIABLES_B.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4555: TYPE l_vinf_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER ;
4556: TYPE l_vinf_existing_language IS TABLE OF OKC_BUS_VARIABLES_TL.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4557:
4558:
4559: l_return_status VARCHAR2(1);
4560: l_error_index NUMBER := 1;

Line 5354: INSERT INTO OKC_BUS_VARIABLES_TL(

5350: BEGIN
5351: l_context := 'INSERTING VARIABLE INTO TL TABLE';
5352:
5353: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5354: INSERT INTO OKC_BUS_VARIABLES_TL(
5355: VARIABLE_CODE,
5356: VARIABLE_NAME,
5357: LANGUAGE,
5358: SOURCE_LANG,

Line 5390: -- End of Insert into OKC_BUS_VARIABLES_TL

5386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5387: END;
5388:
5389: --
5390: -- End of Insert into OKC_BUS_VARIABLES_TL
5391: --
5392: --
5393:
5394: i := 0;

Line 5425: UPDATE OKC_BUS_VARIABLES_TL

5421: BEGIN
5422: l_context := 'UPDATING DESCRIPTION FOR ACTION U';
5423:
5424: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5425: UPDATE OKC_BUS_VARIABLES_TL
5426: SET DESCRIPTION = vinf_description_tbl(i),
5427: --PROGRAM_ID = l_program_id,
5428: --REQUEST_ID = l_request_id,
5429: --PROGRAM_LOGIN_ID = l_program_login_id,

Line 5447: -- End of Update OKC_BUS_VARIABLES_TL

5443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5444: END;
5445:
5446: --
5447: -- End of Update OKC_BUS_VARIABLES_TL
5448: --
5449: --
5450:
5451: i := 0;

Line 5456: INSERT INTO OKC_BUS_VARIABLES_TL(

5452: BEGIN
5453: l_context := 'INSERTING VARIABLE INTO TL TABLE FOR ACTION U';
5454:
5455: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5456: INSERT INTO OKC_BUS_VARIABLES_TL(
5457: VARIABLE_CODE,
5458: VARIABLE_NAME,
5459: LANGUAGE,
5460: SOURCE_LANG,

Line 5493: -- End of Insert into OKC_BUS_VARIABLES_TL for Action U

5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5490: END;
5491:
5492: --
5493: -- End of Insert into OKC_BUS_VARIABLES_TL for Action U
5494: --
5495: --
5496:
5497: i := 0;

Line 5523: -- End of Update OKC_BUS_VARIABLES_TL for Disable

5519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5520: END;
5521:
5522: --
5523: -- End of Update OKC_BUS_VARIABLES_TL for Disable
5524: --
5525: --
5526:
5527:

Line 5732: -- Insert records into OKC_BUS_VARIABLES_TL for missing languages

5728: IF l_var_interface_csr%ISOPEN THEN
5729: CLOSE l_var_interface_csr;
5730: END IF;
5731:
5732: -- Insert records into OKC_BUS_VARIABLES_TL for missing languages
5733: IF p_validate_only = 'N' THEN
5734: BEGIN
5735: SAVEPOINT bulklanginsert;
5736: IF (l_debug = 'Y') THEN

Line 5740: INSERT INTO OKC_BUS_VARIABLES_TL (

5736: IF (l_debug = 'Y') THEN
5737: okc_debug.log('1000: Entering Insert Missing Lang Records', 2);
5738: END IF;
5739:
5740: INSERT INTO OKC_BUS_VARIABLES_TL (
5741: VARIABLE_CODE,
5742: VARIABLE_NAME,
5743: DESCRIPTION,
5744: CREATED_BY,

Line 5763: FROM OKC_BUS_VARIABLES_TL VART,

5759: l_user_id,
5760: l_login_id,
5761: LANG.LANGUAGE_CODE,
5762: VART.SOURCE_LANG
5763: FROM OKC_BUS_VARIABLES_TL VART,
5764: FND_LANGUAGES LANG,
5765: OKC_VARIABLES_INTERFACE VARI
5766: WHERE LANG.INSTALLED_FLAG IN ('I', 'B')
5767: AND VART.VARIABLE_CODE = RTRIM(VARI.VARIABLE_CODE)

Line 5773: FROM OKC_BUS_VARIABLES_TL VART1

5769: AND VARI.BATCH_NUMBER = p_batch_number
5770: AND VARI.ACTION <> 'D'
5771: AND NOT EXISTS
5772: (SELECT NULL
5773: FROM OKC_BUS_VARIABLES_TL VART1
5774: WHERE VART1.VARIABLE_CODE = VART.VARIABLE_CODE
5775: AND VART1.LANGUAGE = LANG.LANGUAGE_CODE)
5776: AND VART.ROWID = (SELECT MIN(VART2.ROWID)
5777: FROM OKC_BUS_VARIABLES_TL VART2

Line 5777: FROM OKC_BUS_VARIABLES_TL VART2

5773: FROM OKC_BUS_VARIABLES_TL VART1
5774: WHERE VART1.VARIABLE_CODE = VART.VARIABLE_CODE
5775: AND VART1.LANGUAGE = LANG.LANGUAGE_CODE)
5776: AND VART.ROWID = (SELECT MIN(VART2.ROWID)
5777: FROM OKC_BUS_VARIABLES_TL VART2
5778: WHERE VART2.VARIABLE_CODE = VART.VARIABLE_CODE)
5779: AND VARI.ROWID = (SELECT MIN(VARI1.ROWID)
5780: FROM OKC_VARIABLES_INTERFACE VARI1
5781: WHERE RTRIM(VARI1.VARIABLE_CODE) = RTRIM(VARI.VARIABLE_CODE)