APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_ACTIONS_B

Line 23: p_acn_id IN okc_actions_b.id%TYPE,

19: -- This function takes the action attribute element name
20: -- and returns the corresponding aae_id
21:
22: FUNCTION get_attribute_id (
23: p_acn_id IN okc_actions_b.id%TYPE,
24: p_element_name IN okc_action_attributes_b.element_name%TYPE
25: )
26: RETURN NUMBER
27: IS

Line 66: ,p_acn_id IN okc_actions_b.id%TYPE)

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 ;
70: l_aae_id NUMBER;

Line 247: p_acn_id IN okc_actions_b.id%TYPE,

243: -- and returns attribute value of date datatype which is
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

Line 1737: p_acn_id IN okc_actions_b.id%TYPE,

1733: p_init_msg_list IN VARCHAR2 ,
1734: x_return_status OUT NOCOPY VARCHAR2,
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:

Line 2014: p_acn_id IN okc_actions_b.id%TYPE,

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

Line 2234: p_acn_id IN okc_actions_b.id%TYPE,

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

Line 2246: okc_actions_b acn

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'
2250: AND cnh.template_yn = 'N'