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.

[Home] [Help]

APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_BUS_VARIABLES_B

Line 506: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;

502: l_dummy_num NUMBER := 0;
503: l_dummy_char VARCHAR2(1) := '?';
504:
505: TYPE l_variable_name IS TABLE OF OKC_BUS_VARIABLES_TL.variable_name%TYPE INDEX BY BINARY_INTEGER ;
506: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;
507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
509: -- Below Added for bug 5958643
510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;

Line 507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;

503: l_dummy_char VARCHAR2(1) := '?';
504:
505: TYPE l_variable_name IS TABLE OF OKC_BUS_VARIABLES_TL.variable_name%TYPE INDEX BY BINARY_INTEGER ;
506: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;
507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
509: -- Below Added for bug 5958643
510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;
511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;

Line 508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;

504:
505: TYPE l_variable_name IS TABLE OF OKC_BUS_VARIABLES_TL.variable_name%TYPE INDEX BY BINARY_INTEGER ;
506: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;
507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
509: -- Below Added for bug 5958643
510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;
511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;
512: -- Above Added for bug 5958643

Line 510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;

506: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;
507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
509: -- Below Added for bug 5958643
510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;
511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;
512: -- Above Added for bug 5958643
513:
514: -- MRV Project Changes Start

Line 511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;

507: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
508: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
509: -- Below Added for bug 5958643
510: TYPE l_variable_source IS TABLE OF OKC_BUS_VARIABLES_B.variable_source%TYPE INDEX BY BINARY_INTEGER ;
511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;
512: -- Above Added for bug 5958643
513:
514: -- MRV Project Changes Start
515: TYPE l_mrv_flag IS TABLE OF OKC_BUS_VARIABLES_B.mrv_flag%TYPE INDEX BY BINARY_INTEGER;

Line 515: TYPE l_mrv_flag IS TABLE OF OKC_BUS_VARIABLES_B.mrv_flag%TYPE INDEX BY BINARY_INTEGER;

511: TYPE l_procedure_name IS TABLE OF OKC_BUS_VARIABLES_B.procedure_name%TYPE INDEX BY BINARY_INTEGER ;
512: -- Above Added for bug 5958643
513:
514: -- MRV Project Changes Start
515: TYPE l_mrv_flag IS TABLE OF OKC_BUS_VARIABLES_B.mrv_flag%TYPE INDEX BY BINARY_INTEGER;
516: TYPE l_clm_source IS TABLE OF OKC_BUS_VARIABLES_B.clm_source%TYPE INDEX BY BINARY_INTEGER;
517: -- MRV Project Changes End
518:
519: l_variable_tbl l_variable_name;

Line 516: TYPE l_clm_source IS TABLE OF OKC_BUS_VARIABLES_B.clm_source%TYPE INDEX BY BINARY_INTEGER;

512: -- Above Added for bug 5958643
513:
514: -- MRV Project Changes Start
515: TYPE l_mrv_flag IS TABLE OF OKC_BUS_VARIABLES_B.mrv_flag%TYPE INDEX BY BINARY_INTEGER;
516: TYPE l_clm_source IS TABLE OF OKC_BUS_VARIABLES_B.clm_source%TYPE INDEX BY BINARY_INTEGER;
517: -- MRV Project Changes End
518:
519: l_variable_tbl l_variable_name;
520: l_disabled_yn_tbl l_disabled_yn;

Line 548: OKC_BUS_VARIABLES_B BVB,

544: BVB.MRV_FLAG, -- MRV Project
545: BVB.CLM_SOURCE -- MRV PROJECT
546: FROM
547: OKC_BUS_VARIABLES_TL BVT,
548: OKC_BUS_VARIABLES_B BVB,
549: OKC_ARTICLE_VARIABLES AAV
550: WHERE BVB.VARIABLE_CODE = BVT.VARIABLE_CODE
551: AND BVB.VARIABLE_CODE = AAV.VARIABLE_CODE
552: AND BVT.LANGUAGE = USERENV('LANG')