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_AQ_PVT

Line 207: p_msg_tab IN okc_aq_pvt.msg_tab_typ

203: -- message table and gives out the corresponding element value
204:
205: FUNCTION get_attribute_value (
206: p_element_name IN okc_action_attributes_b.element_name%TYPE,
207: p_msg_tab IN okc_aq_pvt.msg_tab_typ
208: )
209: RETURN VARCHAR2
210: IS
211: x_element_value VARCHAR2(32000);

Line 248: p_msg_tab IN okc_aq_pvt.msg_tab_typ

244: -- the date of intrest for that action
245:
246: FUNCTION get_datetime (
247: p_acn_id IN okc_actions_b.id%TYPE,
248: p_msg_tab IN okc_aq_pvt.msg_tab_typ
249: )
250: RETURN DATE
251: IS
252: CURSOR aae_cur IS

Line 305: p_msg_tab IN okc_aq_pvt.msg_tab_typ

301: -- values and returns the executable function for FEX in condition lines
302: FUNCTION get_function_value (
303: p_cnl_id IN okc_condition_lines_b.id%TYPE,
304: p_pdf_id IN okc_process_defs_b.id%TYPE,
305: p_msg_tab IN okc_aq_pvt.msg_tab_typ
306: )
307: RETURN VARCHAR2
308: IS
309: x_function_value VARCHAR2(1);

Line 695: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

691: END;
692:
693: PROCEDURE evaluate_condition_lines(
694: p_cnh_id IN okc_condition_headers_b.id%TYPE,
695: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
696: p_init_msg_list IN VARCHAR2 ,
697: x_return_status OUT NOCOPY VARCHAR2,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY VARCHAR2,

Line 930: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

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,
934: x_msg_data OUT NOCOPY VARCHAR2,

Line 985: l_msg_tab okc_aq_pvt.msg_tab_typ;

981: oat_rec oat_cur%ROWTYPE;
982:
983: sync_index NUMBER :=1;
984: async_index NUMBER :=1;
985: l_msg_tab okc_aq_pvt.msg_tab_typ;
986: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
987: p_cnh_id okc_condition_headers_b.id%TYPE;
988: l_string VARCHAR2(32000);
989: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760

Line 986: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

982:
983: sync_index NUMBER :=1;
984: async_index NUMBER :=1;
985: l_msg_tab okc_aq_pvt.msg_tab_typ;
986: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
987: p_cnh_id okc_condition_headers_b.id%TYPE;
988: l_string VARCHAR2(32000);
989: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760
990: v_oce_id NUMBER :=0;

Line 1013: l_msg_tab := okc_aq_pvt.msg_tab_typ();

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
1017: CLOSE oce_cur;

Line 1041: okc_aq_pvt.send_message (

1037: sync_index := sync_index+1;
1038: ELSIF l_msg_tab.COUNT <> 0 AND
1039: l_corrid_rec.corrid IS NOT NULL THEN
1040: -- put l_msg_tab and corrid_rec in the queue
1041: okc_aq_pvt.send_message (
1042: p_api_version => 1.0
1043: ,x_msg_count => l_msg_count
1044: ,x_msg_data => l_msg_data
1045: ,x_return_status => l_return_status

Line 1048: ,p_queue_name => okc_aq_pvt.g_outcome_queue_name);

1044: ,x_msg_data => l_msg_data
1045: ,x_return_status => l_return_status
1046: ,p_corrid_rec => l_corrid_rec
1047: ,p_msg_tab => l_msg_tab
1048: ,p_queue_name => okc_aq_pvt.g_outcome_queue_name);
1049: -- initialize l_msg_tab
1050: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1051: END IF;
1052: EXIT;

Line 1050: l_msg_tab := okc_aq_pvt.msg_tab_typ();

1046: ,p_corrid_rec => l_corrid_rec
1047: ,p_msg_tab => l_msg_tab
1048: ,p_queue_name => okc_aq_pvt.g_outcome_queue_name);
1049: -- initialize l_msg_tab
1050: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1051: END IF;
1052: EXIT;
1053: ELSE
1054:

Line 1082: okc_aq_pvt.send_message (

1078: sync_index := sync_index+1;
1079: ELSIF l_msg_tab.COUNT <> 0 AND
1080: l_corrid_rec.corrid IS NOT NULL THEN
1081: -- put l_msg_tab and corrid_rec in the queue
1082: okc_aq_pvt.send_message (
1083: p_api_version => 1.0
1084: , x_msg_count => l_msg_count
1085: , x_msg_data => l_msg_data
1086: , x_return_status => l_return_status

Line 1089: , p_queue_name => okc_aq_pvt.g_outcome_queue_name);

1085: , x_msg_data => l_msg_data
1086: , x_return_status => l_return_status
1087: , p_corrid_rec => l_corrid_rec
1088: , p_msg_tab => l_msg_tab
1089: , p_queue_name => okc_aq_pvt.g_outcome_queue_name);
1090: END IF;
1091: -- store new outcome id in a local variable
1092: -- build the new outcome string with first parameter
1093: IF upper(oce_rec.pdf_type) IN ('ALERT','SCRIPT') THEN

Line 1150: l_msg_tab := okc_aq_pvt.msg_tab_typ();

1146: END IF;
1147: ELSE
1148: -- initialize l_msg_tab,async_index and assign new pdf_type to corrid_rec
1149: l_corrid_rec.corrid := oce_rec.pdf_type;
1150: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1151: l_msg_tab.extend;
1152: async_index := 1;
1153: l_msg_tab(async_index).element_name := 'K_ID';
1154: l_msg_tab(async_index).element_value:= get_attribute_value('K_ID',p_msg_tab);

Line 1318: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

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,
1322: x_msg_data OUT NOCOPY VARCHAR2

Line 1372: l_msg_tab okc_aq_pvt.msg_tab_typ;

1368: oat_rec oat_cur%ROWTYPE;
1369:
1370: sync_index NUMBER :=1;
1371: async_index NUMBER :=1;
1372: l_msg_tab okc_aq_pvt.msg_tab_typ;
1373: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
1374: p_cnh_id okc_condition_headers_b.id%TYPE;
1375: l_string VARCHAR2(32000);
1376: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760

Line 1373: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

1369:
1370: sync_index NUMBER :=1;
1371: async_index NUMBER :=1;
1372: l_msg_tab okc_aq_pvt.msg_tab_typ;
1373: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
1374: p_cnh_id okc_condition_headers_b.id%TYPE;
1375: l_string VARCHAR2(32000);
1376: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760
1377: v_oce_id NUMBER :=0;

Line 1399: l_msg_tab := okc_aq_pvt.msg_tab_typ();

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
1403: CLOSE oce_cur;

Line 1427: l_msg_tab := okc_aq_pvt.msg_tab_typ();

1423: x_return_status => l_return_status
1424: );
1425:
1426: -- initialize l_msg_tab
1427: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1428: END IF;
1429: EXIT;
1430: ELSE
1431:

Line 1464: l_msg_tab := okc_aq_pvt.msg_tab_typ();

1460: END IF; -- l_msg_tab.COUNT <> 0
1461:
1462: -- initialize l_msg_tab,async_index and assign new pdf_type to corrid_rec
1463: l_corrid_rec.corrid := oce_rec.pdf_type;
1464: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1465: l_msg_tab.extend;
1466: async_index := 1;
1467: l_msg_tab(async_index).element_name := 'K_ID';
1468: l_msg_tab(async_index).element_value:= get_attribute_value('K_ID',p_msg_tab);

Line 1739: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

1735: x_msg_count OUT NOCOPY NUMBER,
1736: x_msg_data OUT NOCOPY VARCHAR2,
1737: p_acn_id IN okc_actions_b.id%TYPE,
1738: p_coev_tab IN okc_coe_pvt.coev_tbl_type,
1739: p_msg_tab IN okc_aq_pvt.msg_tab_typ,
1740: x_aavv_tbl OUT NOCOPY okc_aav_pvt.aavv_tbl_type)
1741:
1742: IS
1743: l_aavv_tbl okc_aav_pvt.aavv_tbl_type;

Line 1882: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

1878: x_return_status OUT NOCOPY VARCHAR2,
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);

Line 2015: p_msg_tab IN okc_aq_pvt.msg_tab_typ,

2011: x_return_status OUT NOCOPY VARCHAR2,
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

Line 2235: p_msg_tab IN okc_aq_pvt.msg_tab_typ

2231: x_return_status OUT NOCOPY VARCHAR2,
2232: x_msg_count OUT NOCOPY NUMBER,
2233: x_msg_data OUT NOCOPY VARCHAR2,
2234: p_acn_id IN okc_actions_b.id%TYPE,
2235: p_msg_tab IN okc_aq_pvt.msg_tab_typ
2236: )
2237: IS
2238: -- cursor for conditions based on action that occured
2239: CURSOR cnh_cur(p_k_id IN NUMBER) IS

Line 2501: p_msg_tab IN okc_aq_pvt.msg_tab_typ

2497: x_return_status OUT NOCOPY VARCHAR2,
2498: x_msg_count OUT NOCOPY NUMBER,
2499: x_msg_data OUT NOCOPY VARCHAR2,
2500: p_cnh_id IN okc_condition_headers_b.id%TYPE,
2501: p_msg_tab IN okc_aq_pvt.msg_tab_typ
2502: )
2503: IS
2504: -- cursor for conditions based on action that occured
2505: CURSOR cnh_cur IS