APPS.PY_ROLLBACK_PKG dependencies on PAY_ACTION_PARAMETERS

Line 44: retro_purge pay_action_parameters.parameter_value%type,

40: dml_mode varchar2(10), -- 'NONE', 'PARTIAL, 'FULL'.
41: max_errors_allowed number,
42: max_single_undo number,
43: limit_dml boolean,
44: retro_purge pay_action_parameters.parameter_value%type,
45: single_bal_table pay_action_parameters.parameter_value%type,
46: set_date_earned pay_action_parameters.parameter_value%type,
47: sub_ledger_acc pay_action_parameters.parameter_value%type
48: );

Line 45: single_bal_table pay_action_parameters.parameter_value%type,

41: max_errors_allowed number,
42: max_single_undo number,
43: limit_dml boolean,
44: retro_purge pay_action_parameters.parameter_value%type,
45: single_bal_table pay_action_parameters.parameter_value%type,
46: set_date_earned pay_action_parameters.parameter_value%type,
47: sub_ledger_acc pay_action_parameters.parameter_value%type
48: );
49: --

Line 46: set_date_earned pay_action_parameters.parameter_value%type,

42: max_single_undo number,
43: limit_dml boolean,
44: retro_purge pay_action_parameters.parameter_value%type,
45: single_bal_table pay_action_parameters.parameter_value%type,
46: set_date_earned pay_action_parameters.parameter_value%type,
47: sub_ledger_acc pay_action_parameters.parameter_value%type
48: );
49: --
50: -- Data structure to hold information on next range.

Line 47: sub_ledger_acc pay_action_parameters.parameter_value%type

43: limit_dml boolean,
44: retro_purge pay_action_parameters.parameter_value%type,
45: single_bal_table pay_action_parameters.parameter_value%type,
46: set_date_earned pay_action_parameters.parameter_value%type,
47: sub_ledger_acc pay_action_parameters.parameter_value%type
48: );
49: --
50: -- Data structure to hold information on next range.
51: type range_rec is record

Line 62: mtgl_mode pay_action_parameters.parameter_value%type;

58: g_error_count number;
59: g_debug boolean := hr_utility.debug_enabled;
60: --
61: -- cache variables
62: mtgl_mode pay_action_parameters.parameter_value%type;
63: mtgl_mode_cached boolean := false;
64: --
65: -- The End of Time.
66: c_eot constant date := to_date('31/12/4712', 'DD/MM/YYYY');

Line 109: l_name pay_action_parameters.parameter_name%type;

105: * the relevant default value.
106: */
107: function action_parameter(p_param_name in varchar2)
108: return varchar2 is
109: l_name pay_action_parameters.parameter_name%type;
110: param_value pay_action_parameters.parameter_value%type;
111: c_indent constant varchar2(40) := 'py_rollback_pkg.action_parameter';
112: l_found boolean;
113: begin

Line 110: param_value pay_action_parameters.parameter_value%type;

106: */
107: function action_parameter(p_param_name in varchar2)
108: return varchar2 is
109: l_name pay_action_parameters.parameter_name%type;
110: param_value pay_action_parameters.parameter_value%type;
111: c_indent constant varchar2(40) := 'py_rollback_pkg.action_parameter';
112: l_found boolean;
113: begin
114: -- Attempt to find value of the parameter

Line 455: from pay_action_parameters

451: end if;
452: begin
453: select upper(parameter_value)
454: into mtgl_mode
455: from pay_action_parameters
456: where parameter_name = 'TRANSGL_THREAD';
457: exception
458: when others then
459: mtgl_mode := 'Y';