APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 65: p_cnh_id IN okc_condition_headers_b.id%TYPE

61:
62: -- R12 changed function to get counter reading instead of counter_grp_log_id
63: --This function accepts cnh_id,acn_id and returns counter_reading
64: FUNCTION get_last_counter_reading(
65: p_cnh_id IN okc_condition_headers_b.id%TYPE
66: ,p_acn_id IN okc_actions_b.id%TYPE)
67: RETURN NUMBER
68: IS
69: l_counter_reading NUMBER ;

Line 694: p_cnh_id IN okc_condition_headers_b.id%TYPE,

690:
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,

Line 729: okc_condition_headers_b cnh

725: cnh.acn_id acn_id,
726: cnh.one_time_yn one_time_yn
727: FROM okc_condition_lines_b cnl,
728: okc_action_attributes_b aae,
729: okc_condition_headers_b cnh
730: WHERE cnl.cnh_id = p_cnh_id
731: AND cnl.cnh_id = cnh.id
732: AND cnl.aae_id = aae.id(+)
733: ORDER BY cnl.sortseq;

Line 987: p_cnh_id okc_condition_headers_b.id%TYPE;

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;
991: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;

Line 1374: p_cnh_id okc_condition_headers_b.id%TYPE;

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;
1378: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;

Line 1881: p_cnh_id IN okc_condition_headers_b.id%TYPE,

1877: p_init_msg_list IN VARCHAR2 ,
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

Line 2021: FROM okc_condition_headers_b

2017: )
2018: IS
2019: CURSOR cnh_cur IS
2020: SELECT id
2021: FROM okc_condition_headers_b
2022: WHERE acn_id = p_acn_id
2023: AND dnz_chr_id is null
2024: AND condition_valid_yn = 'Y'
2025: AND template_yn = 'N'

Line 2245: FROM okc_condition_headers_b cnh,

2241: cnh.one_time_yn one_time_yn,
2242: acn.counter_action_yn counter_action_yn,
2243: cnh.jtot_object_code jtot_object_code,
2244: cnh.counter_group_id counter_group_id
2245: FROM okc_condition_headers_b cnh,
2246: okc_actions_b acn
2247: WHERE cnh.acn_id = acn.id
2248: AND (cnh.dnz_chr_id = p_k_id or cnh.dnz_chr_id IS NULL)
2249: AND cnh.condition_valid_yn = 'Y'

Line 2500: p_cnh_id IN okc_condition_headers_b.id%TYPE,

2496: p_init_msg_list IN VARCHAR2 ,
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

Line 2509: FROM okc_condition_headers_b cnh

2505: CURSOR cnh_cur IS
2506: SELECT cnh.id id,
2507: cnh.acn_id acn_id,
2508: cnh.one_time_yn one_time_yn
2509: FROM okc_condition_headers_b cnh
2510: WHERE cnh.condition_valid_yn = 'Y'
2511: AND cnh.template_yn = 'N'
2512: AND trunc(cnh.date_active) <= trunc(SYSDATE)
2513: AND NVL(trunc(cnh.date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE)