DBA Data[Home] [Help]

APPS.BEN_PAC_LER dependencies on FF_EXEC

Line 79: p_param_tab in ff_exec.outputs_t ,

75: p_param34 in varchar2 ,
76: p_param34_value in varchar2 ,
77: p_param35 in varchar2 ,
78: p_param35_value in varchar2 ,
79: p_param_tab in ff_exec.outputs_t ,
80: p_ret_val out nocopy varchar2 ,
81: p_ret_date out nocopy date) is
82: --
83:

Line 86: l_outputs ff_exec.outputs_t;

82: --
83:
84: l_package varchar2(80) := g_package||'.exec_rule';
85: l_proc varchar2(80) := g_package||'.exec_rule';
86: l_outputs ff_exec.outputs_t;
87: l_loc_rec hr_locations_all%rowtype;
88: l_ass_rec per_all_assignments_f%rowtype;
89: l_jurisdiction_code varchar2(30);
90: l_env ben_env_object.g_global_env_rec_type;

Line 370: l_param_tab ff_exec.outputs_t ;

366: select *
367: from per_analysis_criteria
368: where ANALYSIS_CRITERIA_ID = p_id;
369: --
370: l_param_tab ff_exec.outputs_t ;
371: l_old_pac c_get_pac%rowtype ;
372: l_new_pac c_get_pac%rowtype ;
373: l_source_table ben_per_info_chg_cs_ler_f.source_table%TYPE ;
374: l_context varchar2(30);