PACKAGE: APPS.PAY_KR_HIA_PKG

Source

1 PACKAGE pay_kr_hia_pkg AS
2 /* $Header: pykrhia.pkh 120.0 2005/05/29 02:08:53 appldev noship $ */
3   level_cnt NUMBER;
4   CURSOR csr_header
5   IS
6   SELECT 'REPORTED_DATE=P',
7          pay_magtape_generic.get_parameter_value('REPORTED_DATE'),
8          'CONCATENATED_BP_NAMES=P',
9          pay_kr_hia_func_pkg.get_concat_bp_names(
10              pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
11              pay_magtape_generic.get_parameter_value('BP_HI_NUMBER'),
12              94)
13     FROM dual;
14 
15   CURSOR csr_data(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')))
16   IS
17   SELECT 'ASSIGNMENT_ACTION_ID=C',
18          to_char(paa.assignment_action_id),
19          'HI_NUMBER=P',
20          pei.pei_information1
21     FROM per_people_extra_info     pei,
22          per_people_f              pp,
23          per_assignments_f         pa,
24          pay_assignment_actions    paa,
25          pay_payroll_actions       ppa,
26          per_periods_of_service    pds
27    WHERE ppa.payroll_action_id   = p_payroll_action_id
28      AND paa.payroll_action_id   = ppa.payroll_action_id
29      AND pa.assignment_id        = paa.assignment_id
30      AND pp.person_id            = pa.person_id
31      AND pds.person_id           = pa.person_id
32      AND NVL(pds.actual_termination_date,ppa.effective_date+1) > ppa.effective_date       -- Bug 3472653
33      AND pds.date_start         <= ppa.effective_date                                     -- Bug 3472653
34      AND ppa.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date     -- Bug 3472653
35      AND ppa.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
36      AND pei.person_id(+)        = pp.person_id
37      AND pei.information_type(+) = 'PER_KR_HEALTH_INSURANCE_INFO'
38      ORDER BY to_number(pei.pei_information1);
39 PROCEDURE range_code(
40                 p_payroll_action_id     IN  NUMBER,
41                 p_sqlstr                OUT NOCOPY VARCHAR2);
42 PROCEDURE assignment_action_code(
43                 p_payroll_action_id     IN NUMBER,
44                 p_start_person_id       IN NUMBER,
45                 p_end_person_id         IN NUMBER,
46                 p_chunk_number          IN NUMBER);
47 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
48 PROCEDURE archive_code(
49                 p_assignment_action_id  IN NUMBER,
50                 p_effective_date        IN DATE);
51 FUNCTION SUBMIT_REPORT
52          RETURN NUMBER;
53 END pay_kr_hia_pkg;