DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_MAG_TAPE

Line 3399: -- get pertinent SRS parameters from the pay_mag_tape tables

3395: rec_print_options csr_get_print_options%ROWTYPE;
3396: --
3397: BEGIN
3398: hr_utility.set_location('Entering: '||l_proc,1);
3399: -- get pertinent SRS parameters from the pay_mag_tape tables
3400: BEGIN
3401: LOOP
3402: l_count := l_count + 1;
3403: IF pay_mag_tape.internal_prm_names(l_count) =

Line 3403: IF pay_mag_tape.internal_prm_names(l_count) =

3399: -- get pertinent SRS parameters from the pay_mag_tape tables
3400: BEGIN
3401: LOOP
3402: l_count := l_count + 1;
3403: IF pay_mag_tape.internal_prm_names(l_count) =
3404: 'TRANSFER_PAYROLL_ACTION_ID'
3405: THEN
3406: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
3407: (l_count));

Line 3406: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values

3402: l_count := l_count + 1;
3403: IF pay_mag_tape.internal_prm_names(l_count) =
3404: 'TRANSFER_PAYROLL_ACTION_ID'
3405: THEN
3406: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
3407: (l_count));
3408: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
3409: THEN
3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);

Line 3408: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'

3404: 'TRANSFER_PAYROLL_ACTION_ID'
3405: THEN
3406: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
3407: (l_count));
3408: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
3409: THEN
3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);
3411: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
3412: THEN

Line 3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);

3406: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
3407: (l_count));
3408: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
3409: THEN
3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);
3411: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
3412: THEN
3413: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
3414: -- Defer printing param set to Y

Line 3411: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'

3407: (l_count));
3408: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
3409: THEN
3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);
3411: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
3412: THEN
3413: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
3414: -- Defer printing param set to Y
3415: l_number_of_copies := 0;

Line 3413: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN

3409: THEN
3410: l_print_style := pay_mag_tape.internal_prm_values(l_count);
3411: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
3412: THEN
3413: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
3414: -- Defer printing param set to Y
3415: l_number_of_copies := 0;
3416: ELSE
3417: l_number_of_copies := 1;

Line 3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';

3472: OPEN csr_get_formula_id('PAY_GB_P45_REPORT_SUBMISSION');
3473: FETCH csr_get_formula_id INTO l_formula_id;
3474: CLOSE csr_get_formula_id;
3475: --
3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';

Line 3477: pay_mag_tape.internal_prm_values(1) := '4';

3473: FETCH csr_get_formula_id INTO l_formula_id;
3474: CLOSE csr_get_formula_id;
3475: --
3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);

Line 3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';

3474: CLOSE csr_get_formula_id;
3475: --
3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';

Line 3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);

3475: --
3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);

Line 3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';

3476: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
3484: --

Line 3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);

3477: pay_mag_tape.internal_prm_values(1) := '4';
3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
3484: --
3485: -- Exit procedure, C code will fire formula

Line 3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';

3478: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
3484: --
3485: -- Exit procedure, C code will fire formula
3486: hr_utility.set_location(' Leaving: '||l_proc,999);

Line 3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);

3479: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
3480: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
3481: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
3482: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
3483: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
3484: --
3485: -- Exit procedure, C code will fire formula
3486: hr_utility.set_location(' Leaving: '||l_proc,999);
3487: END spawn_reports;