DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_ADD_ACTIONS_PKG dependencies on HR_GENERAL

Line 62: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');

58: lv_emp_num_heading varchar2(200);
59:
60: BEGIN
61:
62: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
63: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
64: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
66:

Line 63: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');

59:
60: BEGIN
61:
62: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
63: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
64: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
66:
67: if p_report_type in ('T4','T4A') then

Line 64: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');

60: BEGIN
61:
62: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
63: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
64: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
66:
67: if p_report_type in ('T4','T4A') then
68:

Line 65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');

61:
62: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
63: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
64: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
66:
67: if p_report_type in ('T4','T4A') then
68:
69: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');

Line 69: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');

65: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
66:
67: if p_report_type in ('T4','T4A') then
68:
69: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
70:
71: lv_format1 :=
72: pay_us_payroll_utils.formated_data_string
73: (p_input_string => lv_year_heading

Line 95: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');

91: ,p_output_file_type => p_output_file_type);
92:
93: elsif p_report_type in ('RL1','RL2') then
94:
95: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
96:
97: lv_format1 :=
98: pay_us_payroll_utils.formated_data_string
99: (p_input_string => lv_year_heading

Line 228: lvc_message1 := '1. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED_NONE');

224: lvc_message3 varchar2(200);
225:
226: BEGIN
227:
228: lvc_message1 := '1. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED_NONE');
229: lvc_message2 := '2. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE_NONE');
230: lvc_message3 := '3. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE_NONE');
231:
232: if output_file_type = 'HTML' then

Line 229: lvc_message2 := '2. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE_NONE');

225:
226: BEGIN
227:
228: lvc_message1 := '1. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED_NONE');
229: lvc_message2 := '2. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE_NONE');
230: lvc_message3 := '3. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE_NONE');
231:
232: if output_file_type = 'HTML' then
233: lvc_message1 := '

'||lvc_message1||'

';

Line 230: lvc_message3 := '3. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE_NONE');

226: BEGIN
227:
228: lvc_message1 := '1. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED_NONE');
229: lvc_message2 := '2. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE_NONE');
230: lvc_message3 := '3. '|| hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE_NONE');
231:
232: if output_file_type = 'HTML' then
233: lvc_message1 := '

'||lvc_message1||'

';
234: lvc_message2 := '

'||lvc_message2||'

';

Line 1667: lv_pre_name := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NO_PRE');

1663:
1664: else
1665:
1666: if l_pre_id is null then
1667: lv_pre_name := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NO_PRE');
1668: else
1669: open c_get_name(l_pre_id);
1670: fetch c_get_name into lv_pre_name;
1671: close c_get_name;

Line 1710: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ADD_ASG_HEADING');

1706:
1707: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1708:
1709: -- Add Assignment Actions Report
1710: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ADD_ASG_HEADING');
1711:
1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';
1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';
1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';

Line 1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';

1708:
1709: -- Add Assignment Actions Report
1710: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ADD_ASG_HEADING');
1711:
1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';
1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';
1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';
1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';
1716:

Line 1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';

1709: -- Add Assignment Actions Report
1710: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ADD_ASG_HEADING');
1711:
1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';
1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';
1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';
1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';
1716:
1717: if p_report_type in ('T4','T4A') then

Line 1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';

1710: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ADD_ASG_HEADING');
1711:
1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';
1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';
1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';
1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';
1716:
1717: if p_report_type in ('T4','T4A') then
1718:

Line 1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';

1711:
1712: l_elgbl_table_header := '2. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','ELIGIBLE')||':';
1713: l_prced_table_header := '1. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','PROCESSED')||':';
1714: l_nonelgbl_table_header := '3. '||hr_general.decode_lookup('PAY_CA_MISSING_ASG','NONELIGIBLE')||':';
1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';
1716:
1717: if p_report_type in ('T4','T4A') then
1718:
1719: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||

Line 1719: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||

1715: l_secasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','SECONDARY')||':';
1716:
1717: if p_report_type in ('T4','T4A') then
1718:
1719: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||
1720: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_GRE')||':';
1721:
1722: open c_name(p_gre_id);
1723: fetch c_name into lv_gre_name;

Line 1720: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_GRE')||':';

1716:
1717: if p_report_type in ('T4','T4A') then
1718:
1719: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||
1720: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_GRE')||':';
1721:
1722: open c_name(p_gre_id);
1723: fetch c_name into lv_gre_name;
1724: close c_name;

Line 1728: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||

1724: close c_name;
1725:
1726: elsif p_report_type in ('RL1','RL2') then
1727:
1728: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||
1729: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_PRE')||':';
1730:
1731: open c_name(p_pre_id);
1732: fetch c_name into lv_pre_name;

Line 1729: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_PRE')||':';

1725:
1726: elsif p_report_type in ('RL1','RL2') then
1727:
1728: l_othasg_table_header := hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER')||' '||
1729: hr_general.decode_lookup('PAY_CA_MISSING_ASG','OTHER_PRE')||':';
1730:
1731: open c_name(p_pre_id);
1732: fetch c_name into lv_pre_name;
1733: close c_name;

Line 1811: (p_input_string => hr_general.decode_lookup('PAY_CA_MISSING_ASG','MAG_RUN')

1807: end if;
1808:
1809: fnd_file.put_line(fnd_file.output,
1810: pay_us_payroll_utils.formated_data_string
1811: (p_input_string => hr_general.decode_lookup('PAY_CA_MISSING_ASG','MAG_RUN')
1812: ,p_bold => 'Y'
1813: ,p_output_file_type => p_output_file_type));
1814:
1815: if p_output_file_type ='HTML' then

Line 1822: (p_input_string => hr_general.decode_lookup('PAY_CA_MISSING_ASG','MAG_ROLLBACK')

1818: end if;
1819:
1820: fnd_file.put_line(fnd_file.output,
1821: pay_us_payroll_utils.formated_data_string
1822: (p_input_string => hr_general.decode_lookup('PAY_CA_MISSING_ASG','MAG_ROLLBACK')
1823: ,p_bold => 'Y'
1824: ,p_output_file_type => p_output_file_type));
1825:
1826: if p_output_file_type ='HTML' then