APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_CONDITION_LINES_B

Line 303: p_cnl_id IN okc_condition_lines_b.id%TYPE,

299:
300: -- Builds function expression with parameters and parameter
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

Line 320: from okc_condition_lines_b cnl,

316: where cnl_id = p_cnl_id;
317: fep_rec fep_cur%ROWTYPE;
318: CURSOR cnl_cur IS
319: select pdf.package_name||'.'||pdf.procedure_name function_name
320: from okc_condition_lines_b cnl,
321: okc_process_defs_b pdf
322: where cnl.pdf_id = pdf.id
323: and cnl.id = p_cnl_id
324: and UPPER(pdf.usage) = 'FUNCTION';

Line 574: p_cnl_id IN okc_condition_lines_b.id%TYPE

570:
571: -- This function evaluates the counter condition line and returns
572: -- a string of 'T = F/T' to be evaluated by condition lines procedure
573: FUNCTION evaluate_counter_condition (
574: p_cnl_id IN okc_condition_lines_b.id%TYPE
575: ,p_previous_counter_value IN csi_counter_readings.counter_reading%TYPE
576: ,p_current_counter_value IN csi_counter_readings.counter_reading%TYPE
577: )
578: RETURN VARCHAR2

Line 586: FROM okc_condition_lines_b cnl

582: SELECT left_counter_id
583: ,right_operand
584: ,tolerance
585: ,start_at
586: FROM okc_condition_lines_b cnl
587: WHERE id = p_cnl_id;
588: cnl_rec cnl_cur%ROWTYPE;
589: l_value NUMBER;
590: l_string VARCHAR2(20) := '''F'' = ''T''';

Line 727: FROM okc_condition_lines_b cnl,

723: cnl.start_at start_at,
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