[Home] [Help]
PACKAGE: APPS.PAY_JP_ITWB_REPORT_PKG
Source
1 package pay_jp_itwb_report_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpiwbr.pkh 120.0 2011/04/08 10:13:21 keyazawa noship $ */
3 --
4 g_sort_order1 varchar2(60);
5 g_sort_order2 varchar2(60);
6 g_sort_order3 varchar2(60);
7 --
8 g_set_max_col_cnt varchar2(1) := 'Y';
9 g_sal_earn_max_col_cnt number;
10 g_sal_dct_max_col_cnt number;
11 g_bon_earn_max_col_cnt number;
12 g_bon_dct_max_col_cnt number;
13 g_wrk_max_col_cnt number;
14 g_pjob_max_rec_cnt number;
15 --
16 g_detail_debug varchar2(1);
17 g_show_tag varchar2(1) := 'Y';
18 --
19 g_ass_set_formula_id number;
20 g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;
21 --
22 g_payroll_action_id number;
23 g_effective_date date;
24 g_effective_soy date;
25 g_effective_eoy date;
26 g_effective_som date;
27 g_effective_eom date;
28 g_business_group_id number;
29 g_legislation_code per_business_groups.legislation_code%type;
30 g_arch_option varchar2(30);
31 g_itax_organization_id number;
32 g_inc_org_hier_flag varchar2(1);
33 g_organization_id number;
34 g_payroll_id number;
35 g_location_id number;
36 g_assignment_set_id number;
37 g_payroll_action_id_o number;
38 g_inc_term_flag varchar2(1);
39 g_term_date_from date;
40 g_term_date_to date;
41 g_remove_act varchar2(1);
42 g_msg_nres varchar2(80);
43 --
44 -- -------------------------------------------------------------------------
45 -- use in pay_magtape_generic cursor
46 -- -------------------------------------------------------------------------
47 level_cnt number;
48 --
49 -- -------------------------------------------------------------------------
50 -- csr_bg : unit of gen_xml_header
51 -- -------------------------------------------------------------------------
52 cursor csr_bg
53 is
54 select 1
55 from dual;
56 --
57 -- -------------------------------------------------------------------------
58 -- csr_emp : unit of gen_xml_body
59 -- -------------------------------------------------------------------------
60 cursor csr_emp
61 is
62 select 'TRANSFER_ACT_ID=P',
63 v.assignment_action_id
64 from
65 (select /*+ ORDERED */
66 proc_paa.assignment_action_id,
67 decode(pay_jp_itwb_report_pkg.g_sort_order1,
68 'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
69 'ORGANIZATION_NAME',pjieas.organization_name,
70 lpad(pjie.employee_number,30,' ')) sort1,
71 decode(pay_jp_itwb_report_pkg.g_sort_order2,
72 'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
73 'ORGANIZATION_NAME',pjieas.organization_name,
74 lpad(pjie.employee_number,30,' ')) sort2,
75 decode(pay_jp_itwb_report_pkg.g_sort_order3,
76 'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
77 'ORGANIZATION_NAME',pjieas.organization_name,
78 lpad(pjie.employee_number,30,' ')) sort3
79 from pay_assignment_actions proc_paa,
80 pay_jp_itwb_assact_latest_v pjia,
81 pay_jp_itwb_emp_v pjie,
82 pay_jp_itwb_emp_ass_v pjieas
83 where proc_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
84 and pjia.assignment_action_id = proc_paa.source_action_id
85 and pjie.assignment_action_id = pjia.assignment_action_id
86 and pjie.effective_date = pjia.effective_date
87 and pjieas.assignment_action_id = pjia.assignment_action_id
88 and pjieas.effective_date = pjia.effective_date) v
89 order by
90 v.sort1,
91 v.sort2,
92 v.sort3;
93 --
94 -- -------------------------------------------------------------------------
95 -- csr_asg_act : unit of gen_xml_footer
96 -- -------------------------------------------------------------------------
97 cursor csr_asg_act
98 is
99 select 1
100 from dual;
101 --
102 procedure set_detail_debug(
103 p_yn in varchar2);
104 --
105 procedure range_cursor(
106 p_payroll_action_id in number,
107 p_sqlstr out nocopy varchar2);
108 --
109 procedure assignment_action_creation(
110 p_payroll_action_id in number,
111 p_start_person_id in number,
112 p_end_person_id in number,
113 p_chunk_number in number);
114 --
115 procedure archinit(
116 p_payroll_action_id in number);
117 --
118 procedure gen_xml_header;
119 --
120 procedure gen_xml_body;
121 --
122 procedure gen_xml_footer;
123 --
124 procedure archive_data(
125 p_assignment_action_id in number,
126 p_effective_date in date);
127 --
128 procedure deinitialize_code(
129 p_payroll_action_id in number);
130 --
131 --procedure sort_code(
132 -- p_payroll_action_id in number,
133 -- p_sqlstr in out nocopy varchar2,
134 -- p_length out number);
135 --
136 end pay_jp_itwb_report_pkg;