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_CONDITION_EVAL_PVT dependencies on OKC_CONDITION_EVAL_PVT

Line 1: package body okc_condition_eval_pvt as

1: package body okc_condition_eval_pvt as
2: /* $Header: OKCRCEVB.pls 120.3 2005/07/18 09:30:56 pnayani noship $ */
3:
4: --l_debug VARCHAR2(1) := 'Y';
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 36: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_attribute_id';

32: aae_rec aae_cur%ROWTYPE;
33: x_aae_id NUMBER;
34:
35: --
36: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_attribute_id';
37: --
38:
39: BEGIN
40:

Line 83: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_counter_reading';

79: ORDER BY coe.datetime desc;
80: aav_rec aav_cur%ROWTYPE;
81:
82: --
83: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_counter_reading';
84: --
85:
86: BEGIN
87:

Line 154: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_current_counter_val';

150: c.created_from_counter_tmpl_id = p_counter_id);*/
151: cv_rec cv_cur%ROWTYPE;
152:
153: --
154: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_current_counter_val';
155: --
156:
157: BEGIN
158:

Line 214: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_attribute_value';

210: IS
211: x_element_value VARCHAR2(32000);
212:
213: --
214: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_attribute_value';
215: --
216:
217: BEGIN
218:

Line 266: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_datetime';

262: -- The following format was introduced by msengupt
263: l_decode_format_mask VARCHAR2(20) := 'DD-MON-YY';
264:
265: --
266: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_datetime';
267: --
268:
269: BEGIN
270:

Line 480: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_master_counter_value';

476: x_counter_value VARCHAR2(2000) ;
477: counter_master_rec counter_master_cur%ROWTYPE;
478:
479: --
480: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_master_counter_value';
481: --
482:
483: BEGIN
484:

Line 535: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_counter_value';

531: x_counter_value VARCHAR2(2000) ;
532: counter_rec counter_cur%ROWTYPE;
533:
534: --
535: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'get_counter_value';
536: --
537:
538: BEGIN
539:

Line 594: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_counter_condition';

590: l_string VARCHAR2(20) := '''F'' = ''T''';
591:
592:
593: --
594: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_counter_condition';
595: --
596:
597: BEGIN
598:

Line 646: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluated_once';

642:
643:
644:
645: --
646: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluated_once';
647: --
648:
649: BEGIN
650:

Line 756: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition_lines';

752: i integer;
753: l_processed number;
754:
755: --
756: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition_lines';
757: --
758:
759: BEGIN
760:

Line 929: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,

925:
926:
927:
928: PROCEDURE build_outcome(
929: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,
930: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
931: p_init_msg_list IN VARCHAR2 ,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,

Line 935: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type

931: p_init_msg_list IN VARCHAR2 ,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
936: )
937: IS
938: CURSOR oce_cur (x IN NUMBER) IS
939: SELECT oce.id oce_id,

Line 1001: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'build_outcome';

997: param_exist number;
998: no_param number;
999:
1000: --
1001: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'build_outcome';
1002: --
1003:
1004: BEGIN
1005:

Line 1012: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();

1008: okc_debug.log('10: Entering build outcome ',2);
1009: END IF;
1010:
1011: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1012: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1013: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1014: l_string := NULL;
1015: FOR i IN 1..p_cnh_tab.COUNT LOOP
1016: IF oce_cur%ISOPEN THEN

Line 1317: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,

1313: This API is used for KEXPIRE event. This will bypass the outcome queue **/
1314:
1315:
1316: PROCEDURE build_date_outcome(
1317: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,
1318: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
1319: p_init_msg_list IN VARCHAR2 ,
1320: x_return_status OUT NOCOPY VARCHAR2,
1321: x_msg_count OUT NOCOPY NUMBER,

Line 1388: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'build_date_outcome';

1384: param_exist number;
1385: no_param number;
1386:
1387: --
1388: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'build_date_outcome';
1389: --
1390:
1391: BEGIN
1392:

Line 1398: --x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();

1394: okc_debug.Set_Indentation(l_proc);
1395: okc_debug.log('10: Entering build date outcome ',2);
1396: END IF;
1397: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1398: --x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1399: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1400: l_string := NULL;
1401: FOR i IN 1..p_cnh_tab.COUNT LOOP
1402: IF oce_cur%ISOPEN THEN

Line 1579: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,

1575: /**Release 12 code END **/
1576:
1577:
1578: PROCEDURE create_condition_occurrence (
1579: p_cnh_tab IN okc_condition_eval_pvt.id_tab_type,
1580: p_datetime IN DATE,
1581: p_init_msg_list IN VARCHAR2 ,
1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_count OUT NOCOPY NUMBER,

Line 1594: l_coe_tab okc_condition_eval_pvt.id_tab_type;

1590: l_api_version NUMBER := 1.0;
1591: l_msg_data varchar2(1000);
1592: l_msg_count number;
1593: l_return_status varchar2(1);
1594: l_coe_tab okc_condition_eval_pvt.id_tab_type;
1595: l_coev_tbl okc_coe_pvt.coev_tbl_type;
1596: v_coev_tbl okc_coe_pvt.coev_tbl_type;
1597: l_count number := 1;
1598: l_task_id jtf_tasks_b.task_id%TYPE;

Line 1611: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'create_condition_occurrence';

1607: WHERE id = x;
1608: cnh_rec cnh_cur%ROWTYPE;
1609:
1610: --
1611: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'create_condition_occurrence';
1612: --
1613:
1614: BEGIN
1615:

Line 1767: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'create_action_att_values';

1763: l_task_id jtf_tasks_b.task_id%TYPE;
1764: -- bug 1757364 end.
1765:
1766: --
1767: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'create_action_att_values';
1768: --
1769:
1770: BEGIN
1771:

Line 1883: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type

1879: x_msg_count OUT NOCOPY NUMBER,
1880: x_msg_data OUT NOCOPY VARCHAR2,
1881: p_cnh_id IN okc_condition_headers_b.id%TYPE,
1882: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
1883: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
1884: )
1885: IS
1886: l_status VARCHAR2(10);
1887: l_cnh_tab okc_condition_eval_pvt.id_tab_type;

Line 1887: l_cnh_tab okc_condition_eval_pvt.id_tab_type;

1883: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
1884: )
1885: IS
1886: l_status VARCHAR2(10);
1887: l_cnh_tab okc_condition_eval_pvt.id_tab_type;
1888: l_return_status varchar2(1);
1889: l_api_name CONSTANT VARCHAR2(30) := 'EVALUATE_PLAN_CONDITION';
1890: OKC_PROCESS_FAILED EXCEPTION;
1891: --

Line 1892: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_plan_condition';

1888: l_return_status varchar2(1);
1889: l_api_name CONSTANT VARCHAR2(30) := 'EVALUATE_PLAN_CONDITION';
1890: OKC_PROCESS_FAILED EXCEPTION;
1891: --
1892: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_plan_condition';
1893: --
1894: BEGIN
1895: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
1896: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();

Line 1895: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

1891: --
1892: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_plan_condition';
1893: --
1894: BEGIN
1895: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
1896: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1897:
1898: IF (l_debug = 'Y') THEN
1899: okc_debug.Set_Indentation(l_proc);

Line 1896: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();

1892: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_plan_condition';
1893: --
1894: BEGIN
1895: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
1896: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1897:
1898: IF (l_debug = 'Y') THEN
1899: okc_debug.Set_Indentation(l_proc);
1900: okc_debug.log('10: Entering evaluate_plan_condition',2);

Line 2016: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type

2012: x_msg_count OUT NOCOPY NUMBER,
2013: x_msg_data OUT NOCOPY VARCHAR2,
2014: p_acn_id IN okc_actions_b.id%TYPE,
2015: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
2016: x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
2017: )
2018: IS
2019: CURSOR cnh_cur IS
2020: SELECT id

Line 2031: l_cnh_tab okc_condition_eval_pvt.id_tab_type;

2027: AND NVL(trunc(date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE);
2028: cnh_rec cnh_cur%ROWTYPE;
2029: l_status VARCHAR2(10);
2030: l_count NUMBER := 1;
2031: l_cnh_tab okc_condition_eval_pvt.id_tab_type;
2032: l_msg_data varchar2(1000);
2033: l_msg_count number;
2034: l_return_status varchar2(1);
2035: x_coev_tbl okc_coe_pvt.coev_tbl_type;

Line 2044: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition';

2040: OKC_PROCESS_FAILED EXCEPTION;
2041: l_datetime DATE;
2042:
2043: --
2044: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition';
2045: --
2046:
2047: BEGIN
2048:

Line 2067: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065:
2066: -- initializing and extending table type variables
2067: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
2068: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
2069: IF cnh_cur%ISOPEN THEN
2070: CLOSE cnh_cur;
2071: END IF;

Line 2068: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();

2064: END IF;
2065:
2066: -- initializing and extending table type variables
2067: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
2068: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
2069: IF cnh_cur%ISOPEN THEN
2070: CLOSE cnh_cur;
2071: END IF;
2072:

Line 2258: l_cnh_tab okc_condition_eval_pvt.id_tab_type;

2254: cnh_rec cnh_cur%ROWTYPE;
2255: l_element_name okc_action_attributes_b.element_name%TYPE:='CTR_GROUP_ID';
2256: l_status VARCHAR2(10);
2257: l_count NUMBER := 0;
2258: l_cnh_tab okc_condition_eval_pvt.id_tab_type;
2259: l_msg_data varchar2(1000);
2260: l_msg_count number;
2261: l_return_status varchar2(1);
2262: x_coev_tbl okc_coe_pvt.coev_tbl_type;

Line 2266: x_sync_outcome_tab okc_condition_eval_pvt.outcome_tab_type;

2262: x_coev_tbl okc_coe_pvt.coev_tbl_type;
2263: l_coev_tbl okc_coe_pvt.coev_tbl_type;
2264: x_aavv_tbl okc_aav_pvt.aavv_tbl_type;
2265: l_api_name CONSTANT VARCHAR2(30) := 'EVALUATE_CONDITION';
2266: x_sync_outcome_tab okc_condition_eval_pvt.outcome_tab_type;
2267: OKC_PROCESS_FAILED EXCEPTION;
2268: i NUMBER;
2269: l_k_id NUMBER;
2270: l_datetime DATE;

Line 2273: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition';

2269: l_k_id NUMBER;
2270: l_datetime DATE;
2271:
2272: --
2273: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_condition';
2274: --
2275:
2276: BEGIN
2277:

Line 2301: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

2297: l_k_id := get_attribute_value('K_ID',p_msg_tab);
2298:
2299:
2300: -- initializing and extending table type variables
2301: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
2302: -- build the conditions table based on counter_action_yn
2303: IF cnh_cur%ISOPEN THEN
2304: CLOSE cnh_cur;
2305: END IF;

Line 2519: l_cnh_tab okc_condition_eval_pvt.id_tab_type;

2515: cnh_rec cnh_cur%ROWTYPE;
2516: l_element_name okc_action_attributes_b.element_name%TYPE:='CTR_GROUP_ID';
2517: l_status VARCHAR2(10);
2518: l_count NUMBER := 0;
2519: l_cnh_tab okc_condition_eval_pvt.id_tab_type;
2520: l_msg_data varchar2(1000);
2521: l_msg_count number;
2522: l_return_status varchar2(1);
2523: x_coev_tbl okc_coe_pvt.coev_tbl_type;

Line 2527: x_sync_outcome_tab okc_condition_eval_pvt.outcome_tab_type;

2523: x_coev_tbl okc_coe_pvt.coev_tbl_type;
2524: l_coev_tbl okc_coe_pvt.coev_tbl_type;
2525: x_aavv_tbl okc_aav_pvt.aavv_tbl_type;
2526: l_api_name CONSTANT VARCHAR2(30) := 'EVALUATE_DATE_CONDITION';
2527: x_sync_outcome_tab okc_condition_eval_pvt.outcome_tab_type;
2528: OKC_PROCESS_FAILED EXCEPTION;
2529: l_datetime DATE;
2530:
2531: --

Line 2532: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_date_condition';

2528: OKC_PROCESS_FAILED EXCEPTION;
2529: l_datetime DATE;
2530:
2531: --
2532: l_proc varchar2(72) := ' okc_condition_eval_pvt.'||'evaluate_date_condition';
2533: --
2534:
2535: BEGIN
2536:

Line 2555: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

2551: RAISE OKC_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:
2554: -- initializing and extending table type variables
2555: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();
2556: -- build the conditions table based on counter_action_yn
2557: IF cnh_cur%ISOPEN THEN
2558: CLOSE cnh_cur;
2559: END IF;

Line 2692: END okc_condition_eval_pvt;

2688: END evaluate_date_condition;
2689:
2690:
2691:
2692: END okc_condition_eval_pvt;