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 1892: OKC_BUS_VARIABLES_TL BVT

1888: CURSOR l_var_name_csr (cp_variable_code IN VARCHAR2,
1889: cp_lang IN VARCHAR2) IS
1890: SELECT BVT.VARIABLE_NAME
1891: FROM
1892: OKC_BUS_VARIABLES_TL BVT
1893: WHERE BVT.VARIABLE_CODE = cp_variable_code
1894: AND BVT.LANGUAGE = cp_lang;
1895:
1896: -- Interface Rows

Line 2044: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%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;
2044: l_variable_name OKC_BUS_VARIABLES_TL.VARIABLE_NAME%TYPE;
2045: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%TYPE;
2046: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
2047: l_return_status VARCHAR2(1);
2048: api_return_status VARCHAR2(1);

Line 4384: OKC_BUS_VARIABLES_TL VARTL

4380: VAR.VARIABLE_CODE EXISTING_CODE,
4381: VAR.DATE_PUBLISHED EXISTING_DPUBLISHED,
4382: VARTL.LANGUAGE EXISTING_LANGUAGE
4383: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,
4384: OKC_BUS_VARIABLES_TL VARTL
4385: WHERE nvl(PROCESS_STATUS,'*') NOT IN ('W', 'S')
4386: AND BATCH_NUMBER = cp_batch_number
4387: AND RTRIM(VARINT.VARIABLE_CODE) = VAR.VARIABLE_CODE(+)
4388: AND RTRIM(VARINT.VARIABLE_CODE) = VARTL.VARIABLE_CODE(+)

Line 4404: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL

4400: CURSOR get_var_unq_csr (cp_var_name IN VARCHAR2,
4401: cp_var_intent IN VARCHAR2) IS
4402: SELECT
4403: '1'
4404: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL
4405: WHERE B.VARIABLE_CODE = TL.VARIABLE_CODE AND
4406: B.VARIABLE_INTENT = cp_var_intent AND
4407: TL.VARIABLE_NAME = cp_var_name;
4408:

Line 4414: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL

4410:
4411: CURSOR get_var_info_csr (cp_var_code IN VARCHAR2 ) IS
4412: SELECT
4413: '1'
4414: FROM OKC_BUS_VARIABLES_B B,OKC_BUS_VARIABLES_TL TL
4415: WHERE B.VARIABLE_CODE = TL.VARIABLE_CODE AND
4416: B.VARIABLE_CODE = cp_var_code;
4417:
4418: -- Cursor to derive value set id from value set name

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

4486:
4487: TYPE l_vinf_existing_code IS TABLE OF OKC_BUS_VARIABLES_B.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;
4488: TYPE l_vinf_existing_dpublished IS TABLE OF OKC_BUS_VARIABLES_B.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;
4489: TYPE l_vinf_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER ;
4490: TYPE l_vinf_existing_language IS TABLE OF OKC_BUS_VARIABLES_TL.LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
4491:
4492:
4493: l_return_status VARCHAR2(1);
4494: l_error_index NUMBER := 1;

Line 5286: INSERT INTO OKC_BUS_VARIABLES_TL(

5282: BEGIN
5283: l_context := 'INSERTING VARIABLE INTO TL TABLE';
5284:
5285: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5286: INSERT INTO OKC_BUS_VARIABLES_TL(
5287: VARIABLE_CODE,
5288: VARIABLE_NAME,
5289: LANGUAGE,
5290: SOURCE_LANG,

Line 5322: -- End of Insert into OKC_BUS_VARIABLES_TL

5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5319: END;
5320:
5321: --
5322: -- End of Insert into OKC_BUS_VARIABLES_TL
5323: --
5324: --
5325:
5326: i := 0;

Line 5357: UPDATE OKC_BUS_VARIABLES_TL

5353: BEGIN
5354: l_context := 'UPDATING DESCRIPTION FOR ACTION U';
5355:
5356: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5357: UPDATE OKC_BUS_VARIABLES_TL
5358: SET DESCRIPTION = vinf_description_tbl(i),
5359: --PROGRAM_ID = l_program_id,
5360: --REQUEST_ID = l_request_id,
5361: --PROGRAM_LOGIN_ID = l_program_login_id,

Line 5379: -- End of Update OKC_BUS_VARIABLES_TL

5375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5376: END;
5377:
5378: --
5379: -- End of Update OKC_BUS_VARIABLES_TL
5380: --
5381: --
5382:
5383: i := 0;

Line 5388: INSERT INTO OKC_BUS_VARIABLES_TL(

5384: BEGIN
5385: l_context := 'INSERTING VARIABLE INTO TL TABLE FOR ACTION U';
5386:
5387: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5388: INSERT INTO OKC_BUS_VARIABLES_TL(
5389: VARIABLE_CODE,
5390: VARIABLE_NAME,
5391: LANGUAGE,
5392: SOURCE_LANG,

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

5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5422: END;
5423:
5424: --
5425: -- End of Insert into OKC_BUS_VARIABLES_TL for Action U
5426: --
5427: --
5428:
5429: i := 0;

Line 5455: -- End of Update OKC_BUS_VARIABLES_TL for Disable

5451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5452: END;
5453:
5454: --
5455: -- End of Update OKC_BUS_VARIABLES_TL for Disable
5456: --
5457: --
5458:
5459:

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

5660: IF l_var_interface_csr%ISOPEN THEN
5661: CLOSE l_var_interface_csr;
5662: END IF;
5663:
5664: -- Insert records into OKC_BUS_VARIABLES_TL for missing languages
5665: IF p_validate_only = 'N' THEN
5666: BEGIN
5667: SAVEPOINT bulklanginsert;
5668: IF (l_debug = 'Y') THEN

Line 5672: INSERT INTO OKC_BUS_VARIABLES_TL (

5668: IF (l_debug = 'Y') THEN
5669: okc_debug.log('1000: Entering Insert Missing Lang Records', 2);
5670: END IF;
5671:
5672: INSERT INTO OKC_BUS_VARIABLES_TL (
5673: VARIABLE_CODE,
5674: VARIABLE_NAME,
5675: DESCRIPTION,
5676: CREATED_BY,

Line 5695: FROM OKC_BUS_VARIABLES_TL VART,

5691: l_user_id,
5692: l_login_id,
5693: LANG.LANGUAGE_CODE,
5694: VART.SOURCE_LANG
5695: FROM OKC_BUS_VARIABLES_TL VART,
5696: FND_LANGUAGES LANG,
5697: OKC_VARIABLES_INTERFACE VARI
5698: WHERE LANG.INSTALLED_FLAG IN ('I', 'B')
5699: AND VART.VARIABLE_CODE = RTRIM(VARI.VARIABLE_CODE)

Line 5705: FROM OKC_BUS_VARIABLES_TL VART1

5701: AND VARI.BATCH_NUMBER = p_batch_number
5702: AND VARI.ACTION <> 'D'
5703: AND NOT EXISTS
5704: (SELECT NULL
5705: FROM OKC_BUS_VARIABLES_TL VART1
5706: WHERE VART1.VARIABLE_CODE = VART.VARIABLE_CODE
5707: AND VART1.LANGUAGE = LANG.LANGUAGE_CODE)
5708: AND VART.ROWID = (SELECT MIN(VART2.ROWID)
5709: FROM OKC_BUS_VARIABLES_TL VART2

Line 5709: FROM OKC_BUS_VARIABLES_TL VART2

5705: FROM OKC_BUS_VARIABLES_TL VART1
5706: WHERE VART1.VARIABLE_CODE = VART.VARIABLE_CODE
5707: AND VART1.LANGUAGE = LANG.LANGUAGE_CODE)
5708: AND VART.ROWID = (SELECT MIN(VART2.ROWID)
5709: FROM OKC_BUS_VARIABLES_TL VART2
5710: WHERE VART2.VARIABLE_CODE = VART.VARIABLE_CODE)
5711: AND VARI.ROWID = (SELECT MIN(VARI1.ROWID)
5712: FROM OKC_VARIABLES_INTERFACE VARI1
5713: WHERE RTRIM(VARI1.VARIABLE_CODE) = RTRIM(VARI.VARIABLE_CODE)