[Home] [Help]
PACKAGE: APPS.PAY_JP_DEF_REPORT_PKG
Source
1 package pay_jp_def_report_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpdefr.pkh 120.0 2010/12/09 04:49:24 keyazawa noship $ */
3 --
4 g_show_tag varchar2(1) := 'Y';
5 --
6 g_ass_set_formula_id number;
7 g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;
8 --
9 g_payroll_action_id number;
10 g_arch_payroll_action_id number;
11 g_effective_date date;
12 g_effective_date_eeyy varchar2(30);
13 g_business_group_id number;
14 g_legislation_code per_business_groups.legislation_code%type;
15 g_assignment_set_id number;
16 g_sort_order varchar2(30); -- EMPLOYEE_NAME, EMPLOYEE_NUMBER
17 g_txn_status_b varchar2(1);
18 g_txn_status varchar2(1);
19 g_emp_no varchar2(1);
20 g_remove_act varchar2(1);
21 g_call_type varchar2(30); -- SS, CP
22 --
23 -- -------------------------------------------------------------------------
24 -- use in pay_magtape_generic cursor
25 -- -------------------------------------------------------------------------
26 level_cnt number;
27 --
28 -- -------------------------------------------------------------------------
29 -- csr_bg : unit of gen_xml_header
30 -- -------------------------------------------------------------------------
31 cursor csr_bg
32 is
33 select 1
34 from dual;
35 --
36 -- -------------------------------------------------------------------------
37 -- csr_emp : unit of gen_xml_body
38 -- -------------------------------------------------------------------------
39 cursor csr_emp
40 is
41 select 'TRANSFER_ACT_ID=P',
42 v.assignment_action_id
43 from
44 (select /*+ ORDERED */
45 proc_paa.assignment_action_id,
46 decode(pay_jp_def_report_pkg.g_sort_order,
47 'EMPLOYEE_NAME',pjde.last_name_kana||' '||pjde.first_name_kana,
48 lpad(pjde.employee_number,30,' ')) sort
49 from pay_assignment_actions proc_paa,
50 pay_jp_def_assact_v pjda,
51 pay_jp_def_emp_v pjde
52 where proc_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
53 and pjda.assignment_action_id = proc_paa.source_action_id
54 and pjde.assignment_action_id = pjda.assignment_action_id
55 and pjde.effective_date = pjda.effective_date) v
56 order by
57 v.sort;
58 --
59 -- -------------------------------------------------------------------------
60 -- csr_asg_act : unit of gen_xml_footer
61 -- -------------------------------------------------------------------------
62 cursor csr_asg_act
63 is
64 select 1
65 from dual;
66 --
67 procedure range_cursor(
68 p_payroll_action_id in number,
69 p_sqlstr out nocopy varchar2);
70 --
71 procedure assignment_action_creation(
72 p_payroll_action_id in number,
73 p_start_person_id in number,
74 p_end_person_id in number,
75 p_chunk_number in number);
76 --
77 procedure archinit(
78 p_payroll_action_id in number);
79 --
80 procedure gen_xml_header;
81 --
82 procedure gen_xml_body;
83 --
84 procedure gen_xml_footer;
85 --
86 procedure gen_xml_ss(
87 p_assignment_action_id in number,
88 p_xml out nocopy clob);
89 --
90 procedure archive_data(
91 p_assignment_action_id in number,
92 p_effective_date in date);
93 --
94 procedure deinitialize_code(
95 p_payroll_action_id in number);
96 --
97 --procedure sort_code(
98 -- p_payroll_action_id in number,
99 -- p_sqlstr in out nocopy varchar2,
100 -- p_length out number);
101 --
102 end pay_jp_def_report_pkg;