APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_PROCESS_DEFS_B

Line 304: p_pdf_id IN okc_process_defs_b.id%TYPE,

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
308: IS

Line 321: okc_process_defs_b pdf

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';
325: cnl_rec cnl_cur%ROWTYPE;

Line 334: FROM okc_process_defs_b pdf,

330: pdp.default_value default_value,
331: decode(pdp.data_type,'CHAR','''',
332: 'DATE','''',NULL) prefix_param,
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

Line 991: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;

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;
992: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
993: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_OUTCOME';
994: l_msg_data varchar2(1000);
995: l_msg_count number;

Line 992: async_pdf_type okc_process_defs_b.pdf_type%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;
992: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
993: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_OUTCOME';
994: l_msg_data varchar2(1000);
995: l_msg_count number;
996: l_return_status varchar2(1);

Line 1378: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;

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;
1379: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
1380: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_DATE_OUTCOME';
1381: l_msg_data varchar2(1000);
1382: l_msg_count number;

Line 1379: async_pdf_type okc_process_defs_b.pdf_type%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;
1379: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
1380: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_DATE_OUTCOME';
1381: l_msg_data varchar2(1000);
1382: l_msg_count number;
1383: l_return_status varchar2(1);