DBA Data[Home] [Help]

APPS.HZ_WORD_CONDITIONS_PKG dependencies on HZ_WORD_CONDITIONS_PKG

Line 1: PACKAGE BODY HZ_WORD_CONDITIONS_PKG as

1: PACKAGE BODY HZ_WORD_CONDITIONS_PKG as
2: /*$Header: ARHDQWCB.pls 120.3 2006/03/22 22:26:36 repuri noship $ */
3:
4: -- This is the TCA seeded condition function and any future conditions we seed
5: -- will have their logic here

Line 281: sql_str := 'select HZ_WORD_CONDITIONS_PKG.'||user_defined_proc_name||'(:p_input_str,:p_token_str,:p_repl_str, :p_condition_id,:p_user_spec_cond_val) from dual' ;

277: WHERE condition_id = p_condition_id ;
278:
279: -- Fix for Bug 5007558. Using bind variables for the dynamic procedure input parameters.
280: --dbms_output.put_line('user_defined_proc_name is ' || user_defined_proc_name);
281: sql_str := 'select HZ_WORD_CONDITIONS_PKG.'||user_defined_proc_name||'(:p_input_str,:p_token_str,:p_repl_str, :p_condition_id,:p_user_spec_cond_val) from dual' ;
282: --dbms_output.put_line('SQL string is ' || sql_str);
283: EXECUTE IMMEDIATE sql_str INTO result_str USING p_input_str, p_token_str, p_repl_str, p_condition_id, p_user_spec_cond_val;
284: --dbms_output.put_line('result_str after execute immediate is ' || result_str);
285: EXCEPTION WHEN OTHERS THEN