[Home] [Help]
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
28: CURSOR aae_cur IS
26: RETURN NUMBER
27: IS
28: CURSOR aae_cur IS
29: SELECT id,element_name
30: FROM okc_action_attributes_b
31: WHERE acn_id = p_acn_id;
32: aae_rec aae_cur%ROWTYPE;
33: x_aae_id NUMBER;
34:
202: -- This function takes the action attribute element name loops thro
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
250: RETURN DATE
251: IS
252: CURSOR aae_cur IS
253: SELECT element_name,format_mask
254: FROM okc_action_attributes_b
255: WHERE acn_id = p_acn_id
256: AND data_type = 'DATE'
257: AND date_of_interest_yn = 'Y'
258: AND rownum = 1;
333: fep.value fep_value
334: FROM okc_process_defs_b pdf,
335: okc_process_def_parameters_v pdp,
336: okc_function_expr_params fep,
337: okc_action_attributes_b aae
338: WHERE pdf.id = p_pdf_id
339: AND pdp.pdf_id = pdf.id
340: AND pdp.id = fep.pdp_id
341: AND fep.cnl_id = p_cnl_id
724: cnh.counter_group_id counter_group_id,
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(+)
968:
969: l_oce_id okc_outcomes_b.id%TYPE;
970: l_pdp_id okc_process_def_parms_b.id%TYPE;
971: l_value okc_outcome_arguments.value%TYPE;
972: l_element_name okc_action_attributes_b.element_name%TYPE;
973: CURSOR oat_cur(l_oce_id IN NUMBER,
974: l_pdp_id IN NUMBER) IS
975: SELECT oat.value value,aae.element_name element_name
976: FROM okc_outcome_arguments oat,
973: CURSOR oat_cur(l_oce_id IN NUMBER,
974: l_pdp_id IN NUMBER) IS
975: SELECT oat.value value,aae.element_name element_name
976: FROM okc_outcome_arguments oat,
977: okc_action_attributes_b aae
978: WHERE oat.oce_id = l_oce_id
979: AND oat.pdp_id = l_pdp_id
980: AND oat.aae_id = aae.id(+);
981: oat_rec oat_cur%ROWTYPE;
1355:
1356: l_oce_id okc_outcomes_b.id%TYPE;
1357: l_pdp_id okc_process_def_parms_b.id%TYPE;
1358: l_value okc_outcome_arguments.value%TYPE;
1359: l_element_name okc_action_attributes_b.element_name%TYPE;
1360: CURSOR oat_cur(l_oce_id IN NUMBER,
1361: l_pdp_id IN NUMBER) IS
1362: SELECT oat.value value,aae.element_name element_name
1363: FROM okc_outcome_arguments oat,
1360: CURSOR oat_cur(l_oce_id IN NUMBER,
1361: l_pdp_id IN NUMBER) IS
1362: SELECT oat.value value,aae.element_name element_name
1363: FROM okc_outcome_arguments oat,
1364: okc_action_attributes_b aae
1365: WHERE oat.oce_id = l_oce_id
1366: AND oat.pdp_id = l_pdp_id
1367: AND oat.aae_id = aae.id(+);
1368: oat_rec oat_cur%ROWTYPE;
2251: AND trunc(cnh.date_active) <= trunc(SYSDATE)
2252: AND NVL(trunc(cnh.date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE)
2253: AND acn.id = p_acn_id;
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);
2512: AND trunc(cnh.date_active) <= trunc(SYSDATE)
2513: AND NVL(trunc(cnh.date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE)
2514: AND cnh.id = p_cnh_id;
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);