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 1887: OKC_BUS_VARIABLES_B BVB,

1883: CURSOR l_check_valid_valueset_csr (cp_variable_code IN VARCHAR2) IS
1884: SELECT FLX.FLEX_VALUE_SET_ID,
1885: BVB.VARIABLE_TYPE
1886: FROM
1887: OKC_BUS_VARIABLES_B BVB,
1888: FND_FLEX_VALUE_SETS FLX
1889: WHERE BVB.VARIABLE_CODE = cp_variable_code
1890: --AND BVB.VARIABLE_TYPE = 'U'
1891: AND FLX.FLEX_VALUE_SET_ID(+) = BVB.VALUE_SET_ID;

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

Line 4449: FROM OKC_VARIABLES_INTERFACE VARINT, OKC_BUS_VARIABLES_B VAR,

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

Line 4461: SELECT '1' FROM OKC_BUS_VARIABLES_B

4457:
4458: -- Cursor to check that variable code is unique in the system
4459:
4460: CURSOR l_code_exist_csr (cp_var_code IN VARCHAR2) IS
4461: SELECT '1' FROM OKC_BUS_VARIABLES_B
4462: WHERE variable_code = cp_var_code;
4463:
4464: -- Cursor to check that variable name and intent is unique in the system
4465:

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

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

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

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

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

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

Line 4632: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;

4628: l_dummy VARCHAR2(1) := '?';
4629: l_vs_id VARCHAR2(1) := NULL;
4630: l_language varchar2(1) := '?';
4631: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
4632: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4633:
4634: BEGIN
4635: IF (l_debug = 'Y') THEN
4636: okc_debug.log('100: Entered variables_import', 2);

Line 5238: INSERT INTO OKC_BUS_VARIABLES_B(

5234: BEGIN
5235: l_context := 'INSERTING NEW VARIABLE INTO B TABLE';
5236:
5237: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5238: INSERT INTO OKC_BUS_VARIABLES_B(
5239: VARIABLE_CODE,
5240: OBJECT_VERSION_NUMBER,
5241: VARIABLE_TYPE,
5242: EXTERNAL_YN,

Line 5345: -- End of Insert into OKC_BUS_VARIABLES_B

5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5342: END;
5343:
5344: --
5345: -- End of Insert into OKC_BUS_VARIABLES_B
5346: --
5347: --
5348:
5349: i := 0;

Line 5376: FROM OKC_BUS_VARIABLES_B

5372: sysdate,
5373: l_user_id,
5374: l_login_id,
5375: sysdate
5376: FROM OKC_BUS_VARIABLES_B
5377: WHERE vinf_action_tbl(i) IN ('N')
5378: AND vinf_process_status_tbl(i) in ('S', 'W')
5379: AND variable_code = vinf_variable_code_tbl(i);
5380:

Line 5399: UPDATE OKC_BUS_VARIABLES_B

5395: BEGIN
5396: l_context := 'UPDATING DATE_PUBLISHED FOR ACTION U';
5397:
5398: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5399: UPDATE OKC_BUS_VARIABLES_B
5400: SET DATE_PUBLISHED = vinf_date_published_tbl(i),
5401: LAST_UPDATED_BY = l_user_id,
5402: LAST_UPDATE_LOGIN = l_login_id,
5403: LAST_UPDATE_DATE = SYSDATE

Line 5417: -- End of Update OKC_BUS_VARIABLES_B

5413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5414: END;
5415:
5416: --
5417: -- End of Update OKC_BUS_VARIABLES_B
5418: --
5419: --
5420: i := 0;
5421: BEGIN

Line 5478: FROM OKC_BUS_VARIABLES_B

5474: sysdate,
5475: l_user_id,
5476: l_login_id,
5477: sysdate
5478: FROM OKC_BUS_VARIABLES_B
5479: WHERE vinf_action_tbl(i) = ('U')
5480: AND vinf_process_status_tbl(i) in ('S', 'W')
5481: AND variable_code = vinf_variable_code_tbl(i)
5482: AND vinf_existing_language_tbl(i) IS NULL;

Line 5502: UPDATE OKC_BUS_VARIABLES_B

5498: BEGIN
5499: l_context := 'DISABLING VARIABLE FOR ACTION D';
5500:
5501: FORALL i in vinf_interface_id_tbl.FIRST ..vinf_interface_id_tbl.LAST
5502: UPDATE OKC_BUS_VARIABLES_B
5503: SET DISABLED_YN = vinf_disabled_yn_tbl(i),
5504: --PROGRAM_ID = l_program_id,
5505: --REQUEST_ID = l_request_id,
5506: --PROGRAM_LOGIN_ID = l_program_login_id,

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