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;
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: --
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;
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: --
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.
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;