DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_MAG_TAPE

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

4104: rec_print_options csr_get_print_options%ROWTYPE;
4105: --
4106: BEGIN
4107: hr_utility.set_location('Entering: '||l_proc,1);
4108: -- get pertinent SRS parameters from the pay_mag_tape tables
4109: BEGIN
4110: LOOP
4111: l_count := l_count + 1;
4112: IF pay_mag_tape.internal_prm_names(l_count) =

Line 4112: IF pay_mag_tape.internal_prm_names(l_count) =

4108: -- get pertinent SRS parameters from the pay_mag_tape tables
4109: BEGIN
4110: LOOP
4111: l_count := l_count + 1;
4112: IF pay_mag_tape.internal_prm_names(l_count) =
4113: 'TRANSFER_PAYROLL_ACTION_ID'
4114: THEN
4115: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
4116: (l_count));

Line 4115: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values

4111: l_count := l_count + 1;
4112: IF pay_mag_tape.internal_prm_names(l_count) =
4113: 'TRANSFER_PAYROLL_ACTION_ID'
4114: THEN
4115: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
4116: (l_count));
4117: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
4118: THEN
4119: l_print_style := pay_mag_tape.internal_prm_values(l_count);

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

4113: 'TRANSFER_PAYROLL_ACTION_ID'
4114: THEN
4115: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
4116: (l_count));
4117: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
4118: THEN
4119: l_print_style := pay_mag_tape.internal_prm_values(l_count);
4120: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
4121: THEN

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

4115: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values
4116: (l_count));
4117: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
4118: THEN
4119: l_print_style := pay_mag_tape.internal_prm_values(l_count);
4120: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
4121: THEN
4122: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
4123: -- Defer printing param set to Y

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

4116: (l_count));
4117: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'P45'
4118: THEN
4119: l_print_style := pay_mag_tape.internal_prm_values(l_count);
4120: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
4121: THEN
4122: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
4123: -- Defer printing param set to Y
4124: l_number_of_copies := 0;

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

4118: THEN
4119: l_print_style := pay_mag_tape.internal_prm_values(l_count);
4120: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'PDEF'
4121: THEN
4122: IF pay_mag_tape.internal_prm_values(l_count) = 'Y' THEN
4123: -- Defer printing param set to Y
4124: l_number_of_copies := 0;
4125: ELSE
4126: l_number_of_copies := 1;

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

4254: OPEN csr_get_formula_id('PAY_GB_P45_REPORT_SUBMISSION');
4255: FETCH csr_get_formula_id INTO l_formula_id;
4256: CLOSE csr_get_formula_id;
4257: --
4258: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';

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

4255: FETCH csr_get_formula_id INTO l_formula_id;
4256: CLOSE csr_get_formula_id;
4257: --
4258: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);

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

4256: CLOSE csr_get_formula_id;
4257: --
4258: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';

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

4257: --
4258: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
4265: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);

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

4258: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
4265: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
4266: --

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

4259: pay_mag_tape.internal_prm_values(1) := '4';
4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
4265: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
4266: --
4267: -- Exit procedure, C code will fire formula

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

4260: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
4265: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
4266: --
4267: -- Exit procedure, C code will fire formula
4268: hr_utility.set_location(' Leaving: '||l_proc,999);

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

4261: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
4262: pay_mag_tape.internal_prm_names(3) := 'P45_REQUEST_ID';
4263: pay_mag_tape.internal_prm_values(3) := to_char(l_request_id);
4264: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
4265: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
4266: --
4267: -- Exit procedure, C code will fire formula
4268: hr_utility.set_location(' Leaving: '||l_proc,999);
4269: END spawn_reports;