[Home] [Help]
123: -- ----------------------------------------------------------------------------
124: -- |------------------------< flush_plsql_template >--------------------------|
125: -- ----------------------------------------------------------------------------
126: procedure flush_plsql_template
127: (p_element_template in out nocopy pay_etm_shd.g_rec_type
128: ,p_core_objects in out nocopy t_core_objects
129: ,p_exclusion_rules in out nocopy t_exclusion_rules
130: ,p_formulas in out nocopy t_formulas
131: ,p_balance_types in out nocopy t_balance_types
168: -- |------------------------< get_element_template >--------------------------|
169: -- ----------------------------------------------------------------------------
170: procedure get_element_template
171: (p_template_id in number
172: ,p_element_template out nocopy pay_etm_shd.g_rec_type
173: ) is
174: l_proc varchar2(72) := g_package||'get_element_template';
175: --
176: cursor csr_element_template(p_template_id in number) is
1083: -- ----------------------------------------------------------------------------
1084: -- |----------------------------< exclusion_on >------------------------------|
1085: -- ----------------------------------------------------------------------------
1086: function exclusion_on
1087: (p_element_template in pay_etm_shd.g_rec_type
1088: ,p_rec in pay_ter_shd.g_rec_type
1089: ) return boolean is
1090: l_proc varchar2(72) := g_package||'exclusion_on';
1091: l_exclusion_on boolean;
1771: -- ----------------------------------------------------------------------------
1772: -- |-----------------------< apply_exclusion_rules >--------------------------|
1773: -- ----------------------------------------------------------------------------
1774: procedure apply_exclusion_rules
1775: (p_element_template in pay_etm_shd.g_rec_type
1776: ,p_exclusion_rules in t_exclusion_rules
1777: ,p_formulas in out nocopy t_formulas
1778: ,p_balance_types in out nocopy t_balance_types
1779: ,p_defined_balances in out nocopy t_defined_balances
2074: -- ----------------------------------------------------------------------------
2075: -- |----------------------< set_input_value_defaults >------------------------|
2076: -- ----------------------------------------------------------------------------
2077: procedure set_input_value_defaults
2078: (p_element_template in pay_etm_shd.g_rec_type
2079: ,p_input_values in out nocopy t_input_values
2080: ) is
2081: l_proc varchar2(72) := g_package||'set_input_value_defaults';
2082: i number;
2251: (p_lock in boolean default false
2252: ,p_template_id in number
2253: ,p_generate_part1 in boolean default false
2254: ,p_generate_part2 in boolean default false
2255: ,p_element_template in out nocopy pay_etm_shd.g_rec_type
2256: ,p_core_objects in out nocopy t_core_objects
2257: ,p_exclusion_rules in out nocopy t_exclusion_rules
2258: ,p_formulas in out nocopy t_formulas
2259: ,p_balance_types in out nocopy t_balance_types
2466: -- |------------------------< plsql_to_db_template >--------------------------|
2467: -- ----------------------------------------------------------------------------
2468: procedure plsql_to_db_template
2469: (p_effective_date in date
2470: ,p_element_template in out nocopy pay_etm_shd.g_rec_type
2471: ,p_exclusion_rules in out nocopy t_exclusion_rules
2472: ,p_formulas in out nocopy t_formulas
2473: ,p_balance_types in out nocopy t_balance_types
2474: ,p_defined_balances in out nocopy t_defined_balances
2874: ,p_configuration_information28 in varchar2 default null
2875: ,p_configuration_information29 in varchar2 default null
2876: ,p_configuration_information30 in varchar2 default null
2877: ,p_prefix_reporting_name in varchar2 default 'N'
2878: ,p_element_template in out nocopy pay_etm_shd.g_rec_type
2879: ,p_exclusion_rules in out nocopy t_exclusion_rules
2880: ,p_formulas in out nocopy t_formulas
2881: ,p_balance_types in out nocopy t_balance_types
2882: ,p_defined_balances in out nocopy t_defined_balances