[Home] [Help]
PACKAGE: APPS.PAY_PAYJPBON_XMLP_PKG
Source
1 PACKAGE PAY_PAYJPBON_XMLP_PKG AS
2 /* $Header: PAYJPBONS.pls 120.0 2007/12/13 11:59:26 amakrish noship $ */
3 p_sort_order varchar2(30);
4 p_business_group_id number;
5 p_organization_id number;
6 p_output_flag varchar2(30);
7 p_reported_date date;
8 p_organization_context varchar2(40);
9 p_si_submit_type number;
10 p_payroll_action_id number;
11 p_bon_wp_std_prem_ele_id number;
12 p_bon_hi_std_prem_ele_id number;
13 p_bon_wp_prem_iv_id number;
14 p_bon_hi_prem_iv_id number;
15 p_payment_date date;
16 p_scheduled_payment_yyyymm varchar2(32767);
17 p_where_clause_for_assid varchar2(150) := ' ';
18 p_assignment_id1 number;
19 p_assignment_id2 number;
20 p_assignment_id3 number;
21 p_assignment_id4 number;
22 p_assignment_id5 number;
23 p_assignment_id6 number;
24 p_assignment_id7 number;
25 p_assignment_id8 number;
26 p_assignment_id9 number;
27 p_assignment_id10 number;
28 P_CONC_REQUEST_ID number;
29 cp_full_name varchar2(310);
30 cp_birth_date_era varchar2(5);
31 cp_d_birth_date_era varchar2(80);
32 cp_birth_date_yy varchar2(5);
33 cp_birth_date_mm varchar2(5);
34 cp_birth_date_dd varchar2(5);
35 cp_birth_date_erayymmdd varchar2(15);
36 cp_si_sex_code varchar2(5);
37 cp_bon_payment_date date;
38 cp_bon_payment_date_yy varchar2(5);
39 cp_bon_payment_date_mm varchar2(5);
40 cp_bon_payment_date_dd varchar2(5);
41 cp_bon_payment_date_yymmdd varchar2(32767);
42 cp_bon_comp varchar2(60);
43 cp_bon_mtr_comp varchar2(60);
44 cp_bon_comp_total varchar2(60);
45 cp_d_bon_comp_total varchar2(60);
46 cp_hi_only varchar2(80);
47 cp_wp_only varchar2(80);
48 cp_exclude varchar2(80);
49 cp_emp_failure_item varchar2(2000);
50 cp_error_message varchar2(2000);
51 cp_payment_date_yy varchar2(2);
52 cp_payment_date_mm varchar2(2);
53 cp_payment_date_dd varchar2(2);
54 cp_scheduled_payment_yy varchar2(2);
55 cp_scheduled_payment_mm varchar2(2);
56 cp_reported_date_yy varchar2(2);
57 cp_reported_date_mm varchar2(2);
58 cp_reported_date_dd varchar2(2);
59 cp_payment_date_yymmdd varchar2(32767);
60 cp_scheduled_payment_yymm varchar2(32767);
61 cp_reported_date_yymmdd varchar2(32767);
62 function BeforeReport return boolean ;
63 function cf_dataformula(sort_order in varchar2, si_type in number,date_of_birth in date,
64 effective_date in date,
65 ASSIGNMENT_ACTION_ID in number,assignment_id in number,
66 LAST_NAME in varchar2, FIRST_NAME in varchar2, ins_number in number, last_name_kana in varchar2, first_name_kana in varchar2) return number ;
67 function AfterPForm return boolean ;
68
69 function validate_output(
70 p_qualified_date_iv_id in number,
71 p_disqualified_date_iv_id in number, ASSIGNMENT_ID in number, EFFECTIVE_DATE in date) return varchar2 ;
72
73 function AfterReport return boolean ;
74 Function cp_full_name_p return varchar2;
75 Function cp_birth_date_era_p return varchar2;
76 Function cp_d_birth_date_era_p return varchar2;
77 Function cp_birth_date_yy_p return varchar2;
78 Function cp_birth_date_mm_p return varchar2;
79 Function cp_birth_date_dd_p return varchar2;
80 Function cp_birth_date_erayymmdd_p return varchar2;
81 Function cp_si_sex_code_p return varchar2;
82 Function cp_bon_payment_date_p return date;
83 Function cp_bon_payment_date_yy_p return varchar2;
84 Function cp_bon_payment_date_mm_p return varchar2;
85 Function cp_bon_payment_date_dd_p return varchar2;
86 Function cp_bon_payment_date_yymmdd_p return varchar2;
87 Function cp_bon_comp_p return varchar2;
88 Function cp_bon_mtr_comp_p return varchar2;
89 Function cp_bon_comp_total_p return varchar2;
90 Function cp_d_bon_comp_total_p return varchar2;
91 Function cp_hi_only_p return varchar2;
92 Function cp_wp_only_p return varchar2;
93 Function cp_exclude_p return varchar2;
94 Function cp_emp_failure_item_p return varchar2;
95 Function cp_error_message_p return varchar2;
96 Function cp_payment_date_yy_p return varchar2;
97 Function cp_payment_date_mm_p return varchar2;
98 Function cp_payment_date_dd_p return varchar2;
99 Function cp_scheduled_payment_yy_p return varchar2;
100 Function cp_scheduled_payment_mm_p return varchar2;
101 Function cp_reported_date_yy_p return varchar2;
102 Function cp_reported_date_mm_p return varchar2;
103 Function cp_reported_date_dd_p return varchar2;
104 Function cp_payment_date_yymmdd_p return varchar2;
105 Function cp_scheduled_payment_yymm_p return varchar2;
106 Function cp_reported_date_yymmdd_p return varchar2;
107
108
109 g_rec_cnt number;
110 g_sot date := fnd_date.canonical_to_date('0001/01/01');
111 g_eot date := fnd_date.canonical_to_date('4712/12/31');
112
113 g_hi_qualified_date_iv_id number;
114 g_hi_disqualified_date_iv_id number;
115 g_wp_qualified_date_iv_id number;
116 g_wp_disqualified_date_iv_id number;
117 g_wpf_qualified_date_iv_id number;
118 g_wpf_disqualified_date_iv_id number;
119 g_si_sex_iv_id number;
120 g_bon_hi_std_prem_elm_id number;
121 g_earn_sj_hi_prem_iv_id number;
122 g_earn_kind_sj_hi_prem_iv_id number;
123 g_bon_wp_std_prem_elm_id number;
124 g_earn_sj_wp_prem_iv_id number;
125 g_earn_kind_sj_wp_prem_iv_id number;
126
127
128 END PAY_PAYJPBON_XMLP_PKG;