PACKAGE: APPS.PAY_KR_NPA_PKG

Source

1 PACKAGE pay_kr_npa_pkg AS
2 /* $Header: pykrnpa.pkh 120.0 2005/05/29 02:09:14 appldev noship $ */
3   level_cnt NUMBER;
4 
5   CURSOR csr_header
6   IS
7   SELECT 'REPORTED_DATE=P',
8          fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTED_DATE')),
9 	 -- Bug 3506172
10          'BUSINESS_PLACE_NAME=P',
11 	 pay_kr_npa_func_pkg.get_bp_list(fnd_profile.value('PER_BUSINESS_GROUP_ID'), pay_magtape_generic.get_parameter_value('BP_NP_NUMBER'))
12     FROM dual ;
13     -- End of 3506172
14 
15 
16   CURSOR csr_data(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')))
17   IS
18   SELECT 'ASSIGNMENT_ACTION_ID=C',
19          to_char(paa.assignment_action_id),
20          'REGISTRATION_NUMBER=P',
21          pp.national_identifier
22   FROM   pay_payroll_actions ppa
23          ,pay_assignment_actions paa
24          ,per_assignments_f ass
25          ,per_people_f pp
26          ,hr_organization_information hoi
27          ,per_people_extra_info pei
28   WHERE  ppa.payroll_action_id = p_payroll_action_id
29     AND  ppa.payroll_action_id = paa.payroll_action_id
30     AND  paa.assignment_id = ass.assignment_id
31     AND  ass.person_id = pp.person_id
32     AND  ass.establishment_id = hoi.organization_id
33     AND  hoi.org_information_context = 'KR_NP_INFORMATION'
34     AND  pp.person_id = pei.person_id(+)
35     AND  pei.information_type(+) = 'PER_KR_NATIONAL_PENSION_INFO'
36     AND  ppa.effective_date BETWEEN ass.effective_start_date AND ass.effective_end_date
37     AND  ppa.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
38   ORDER BY hoi.org_information1,fnd_date.canonical_to_date(pei.pei_information3),pp.national_identifier;
39 
40 
41 PROCEDURE range_code(
42                 p_payroll_action_id     IN  NUMBER,
43                 p_sqlstr                OUT NOCOPY VARCHAR2);
44 
45 PROCEDURE assignment_action_code(
46                 p_payroll_action_id     IN NUMBER,
47                 p_start_person_id       IN NUMBER,
48                 p_end_person_id         IN NUMBER,
49                 p_chunk_number          IN NUMBER);
50 
51 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
52 
53 PROCEDURE archive_code(
54                 p_assignment_action_id  IN NUMBER,
55                 p_effective_date        IN DATE);
56 
57 FUNCTION return_header(
58                 P_lookup_type IN VARCHAR2,
59                 p_lookup_code IN VARCHAR2 )
60 RETURN VARCHAR2;
61 
62 END pay_kr_npa_pkg;
63