DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PAY_ACTION_PARAMETERS

Line 19: LOGGING CONSTANT pay_action_parameters.parameter_name%TYPE

15: g_log_level VARCHAR2 (1) := g_regular_log;
16: --
17: -- Package (private) constants.
18: --
19: LOGGING CONSTANT pay_action_parameters.parameter_name%TYPE
20: := 'LOGGING';
21: max_errors CONSTANT pay_action_parameters.parameter_name%TYPE
22: := 'MAX_ERRORS_ALLOWED';
23: NEWLINE CONSTANT VARCHAR2 (10) := fnd_global.NEWLINE;

Line 21: max_errors CONSTANT pay_action_parameters.parameter_name%TYPE

17: -- Package (private) constants.
18: --
19: LOGGING CONSTANT pay_action_parameters.parameter_name%TYPE
20: := 'LOGGING';
21: max_errors CONSTANT pay_action_parameters.parameter_name%TYPE
22: := 'MAX_ERRORS_ALLOWED';
23: NEWLINE CONSTANT VARCHAR2 (10) := fnd_global.NEWLINE;
24: tab CONSTANT VARCHAR2 (30) := fnd_global.tab;
25: --

Line 171: FROM pay_action_parameters pap

167: --
168: CURSOR csr_get_action_param (p_parameter_name IN VARCHAR2)
169: IS
170: SELECT pap.parameter_value
171: FROM pay_action_parameters pap
172: WHERE pap.parameter_name = p_parameter_name;
173:
174: l_logging pay_action_parameters.parameter_value%TYPE;
175: l_max_errors pay_action_parameters.parameter_value%TYPE;

Line 174: l_logging pay_action_parameters.parameter_value%TYPE;

170: SELECT pap.parameter_value
171: FROM pay_action_parameters pap
172: WHERE pap.parameter_name = p_parameter_name;
173:
174: l_logging pay_action_parameters.parameter_value%TYPE;
175: l_max_errors pay_action_parameters.parameter_value%TYPE;
176: l_string VARCHAR2 (500);
177: BEGIN
178: --

Line 175: l_max_errors pay_action_parameters.parameter_value%TYPE;

171: FROM pay_action_parameters pap
172: WHERE pap.parameter_name = p_parameter_name;
173:
174: l_logging pay_action_parameters.parameter_value%TYPE;
175: l_max_errors pay_action_parameters.parameter_value%TYPE;
176: l_string VARCHAR2 (500);
177: BEGIN
178: --
179: -- Reset the package globals.

Line 2363: l_logging pay_action_parameters.parameter_value%TYPE;

2359: -- Declare cursors and local variables
2360: --
2361: l_proc VARCHAR2 (72)
2362: := g_package || 'appraisal_push';
2363: l_logging pay_action_parameters.parameter_value%TYPE;
2364: l_debug BOOLEAN := FALSE;
2365: l_effective_date DATE
2366: := TRUNC (NVL (p_effective_date, SYSDATE));
2367: l_object_version_number NUMBER;