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_B

Line 1882: OKC_BUS_VARIABLES_B BVB,

1878: CURSOR l_check_valid_valueset_csr (cp_variable_code IN VARCHAR2) IS
1879: SELECT FLX.FLEX_VALUE_SET_ID,
1880: BVB.VARIABLE_TYPE
1881: FROM
1882: OKC_BUS_VARIABLES_B BVB,
1883: FND_FLEX_VALUE_SETS FLX
1884: WHERE BVB.VARIABLE_CODE = cp_variable_code
1885: --AND BVB.VARIABLE_TYPE = 'U'
1886: AND FLX.FLEX_VALUE_SET_ID(+) = BVB.VALUE_SET_ID;

Line 2045: l_variable_type OKC_BUS_VARIABLES_B.VARIABLE_TYPE%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);
2049: l_doc_sequence_type CHAR(1);

Line 4383: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,

4379: VARINT.ATTRIBUTE15 ,
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(+)

Line 4395: SELECT '1' FROM OKC_BUS_VARIABLES_B

4391:
4392: -- Cursor to check that variable code is unique in the system
4393:
4394: CURSOR l_code_exist_csr (cp_var_code IN VARCHAR2) IS
4395: SELECT '1' FROM OKC_BUS_VARIABLES_B
4396: WHERE variable_code = cp_var_code;
4397:
4398: -- Cursor to check that variable name and intent is unique in the system
4399:

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 4487: TYPE l_vinf_existing_code IS TABLE OF OKC_BUS_VARIABLES_B.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER ;

4483: TYPE l_vinf_attribute14 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER ;
4484: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4485:
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:

Line 4488: TYPE l_vinf_existing_dpublished IS TABLE OF OKC_BUS_VARIABLES_B.DATE_PUBLISHED%TYPE INDEX BY BINARY_INTEGER ;

4484: TYPE l_vinf_attribute15 IS TABLE OF OKC_VARIABLES_INTERFACE.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER ;
4485:
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:

Line 4489: TYPE l_vinf_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER ;

4485:
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);

Line 4566: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;

4562: l_dummy VARCHAR2(1) := '?';
4563: l_vs_id VARCHAR2(1) := NULL;
4564: l_language varchar2(1) := '?';
4565: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
4566: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4567:
4568: BEGIN
4569: IF (l_debug = 'Y') THEN
4570: okc_debug.log('100: Entered variables_import', 2);

Line 5172: INSERT INTO OKC_BUS_VARIABLES_B(

5168: BEGIN
5169: l_context := 'INSERTING NEW VARIABLE INTO B TABLE';
5170:
5171: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5172: INSERT INTO OKC_BUS_VARIABLES_B(
5173: VARIABLE_CODE,
5174: OBJECT_VERSION_NUMBER,
5175: VARIABLE_TYPE,
5176: EXTERNAL_YN,

Line 5277: -- End of Insert into OKC_BUS_VARIABLES_B

5273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5274: END;
5275:
5276: --
5277: -- End of Insert into OKC_BUS_VARIABLES_B
5278: --
5279: --
5280:
5281: i := 0;

Line 5308: FROM OKC_BUS_VARIABLES_B

5304: sysdate,
5305: l_user_id,
5306: l_login_id,
5307: sysdate
5308: FROM OKC_BUS_VARIABLES_B
5309: WHERE vinf_action_tbl(i) IN ('N')
5310: AND vinf_process_status_tbl(i) in ('S', 'W')
5311: AND variable_code = vinf_variable_code_tbl(i);
5312:

Line 5331: UPDATE OKC_BUS_VARIABLES_B

5327: BEGIN
5328: l_context := 'UPDATING DATE_PUBLISHED FOR ACTION U';
5329:
5330: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5331: UPDATE OKC_BUS_VARIABLES_B
5332: SET DATE_PUBLISHED = vinf_date_published_tbl(i),
5333: LAST_UPDATED_BY = l_user_id,
5334: LAST_UPDATE_LOGIN = l_login_id,
5335: LAST_UPDATE_DATE = SYSDATE

Line 5349: -- End of Update OKC_BUS_VARIABLES_B

5345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5346: END;
5347:
5348: --
5349: -- End of Update OKC_BUS_VARIABLES_B
5350: --
5351: --
5352: i := 0;
5353: BEGIN

Line 5410: FROM OKC_BUS_VARIABLES_B

5406: sysdate,
5407: l_user_id,
5408: l_login_id,
5409: sysdate
5410: FROM OKC_BUS_VARIABLES_B
5411: WHERE vinf_action_tbl(i) = ('U')
5412: AND vinf_process_status_tbl(i) in ('S', 'W')
5413: AND variable_code = vinf_variable_code_tbl(i)
5414: AND vinf_existing_language_tbl(i) IS NULL;

Line 5434: UPDATE OKC_BUS_VARIABLES_B

5430: BEGIN
5431: l_context := 'DISABLING VARIABLE FOR ACTION D';
5432:
5433: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5434: UPDATE OKC_BUS_VARIABLES_B
5435: SET DISABLED_YN = vinf_disabled_yn_tbl(i),
5436: --PROGRAM_ID = l_program_id,
5437: --REQUEST_ID = l_request_id,
5438: --PROGRAM_LOGIN_ID = l_program_login_id,