DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_GB_P11D_ARCHIVE_SS

Line 726: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,

722: into l_pactid
723: from pay_assignment_actions
724: where assignment_action_id = p_assignment_action_id;
725:
726: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
727: p_token_name => 'Rep_Run',
728: p_token_value => l_rep_run);
729:
730: if to_number(l_rep_run) < 2005

Line 1242: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,

1238: into l_pactid
1239: from pay_assignment_actions
1240: where assignment_action_id = p_assignment_action_id;
1241:
1242: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
1243: p_token_name => 'Rep_Run',
1244: p_token_value => l_rep_run);
1245:
1246: if to_number(l_rep_run) < 2005

Line 1888: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1884: exception
1885: when Others then
1886: l_effective_date := sysdate;
1887: end;
1888: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1889: p_payroll_action_id => p_payroll_action_id,
1890: p_token_name => 'PAYROLL',
1891: p_token_value => l_payroll_id);
1892: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1892: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1888: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1889: p_payroll_action_id => p_payroll_action_id,
1890: p_token_name => 'PAYROLL',
1891: p_token_value => l_payroll_id);
1892: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1893: p_payroll_action_id => p_payroll_action_id,
1894: p_token_name => 'PERSON',
1895: p_token_value => l_person_id);
1896: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1896: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1892: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1893: p_payroll_action_id => p_payroll_action_id,
1894: p_token_name => 'PERSON',
1895: p_token_value => l_person_id);
1896: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1897: p_payroll_action_id => p_payroll_action_id,
1898: p_token_name => 'CONSOLIDATION_SET',
1899: p_token_value => l_consolidation_set_id);
1900: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1900: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1896: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1897: p_payroll_action_id => p_payroll_action_id,
1898: p_token_name => 'CONSOLIDATION_SET',
1899: p_token_value => l_consolidation_set_id);
1900: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1901: p_payroll_action_id => p_payroll_action_id,
1902: p_token_name => 'TAX_REFERENCE',
1903: p_token_value => l_tax_reference);
1904: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1904: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1900: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1901: p_payroll_action_id => p_payroll_action_id,
1902: p_token_name => 'TAX_REFERENCE',
1903: p_token_value => l_tax_reference);
1904: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1905: p_payroll_action_id => p_payroll_action_id,
1906: p_token_name => 'ASSIGNMENT_SET_ID',
1907: p_token_value => l_assignment_set_id);
1908: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1908: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1904: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1905: p_payroll_action_id => p_payroll_action_id,
1906: p_token_name => 'ASSIGNMENT_SET_ID',
1907: p_token_value => l_assignment_set_id);
1908: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1909: p_payroll_action_id => p_payroll_action_id,
1910: p_token_name => 'BENEFIT_START_DATE',
1911: p_token_value => l_benefit_start_date);
1912: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1912: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1908: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1909: p_payroll_action_id => p_payroll_action_id,
1910: p_token_name => 'BENEFIT_START_DATE',
1911: p_token_value => l_benefit_start_date);
1912: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1913: p_payroll_action_id => p_payroll_action_id,
1914: p_token_name => 'BENEFIT_END_DATE',
1915: p_token_value => l_benefit_end_date);
1916: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1916: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1912: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1913: p_payroll_action_id => p_payroll_action_id,
1914: p_token_name => 'BENEFIT_END_DATE',
1915: p_token_value => l_benefit_end_date);
1916: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1917: p_payroll_action_id => p_payroll_action_id,
1918: p_token_name => 'Rep_Run',
1919: p_token_value => l_rep_run);
1920: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1920: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1916: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1917: p_payroll_action_id => p_payroll_action_id,
1918: p_token_name => 'Rep_Run',
1919: p_token_value => l_rep_run);
1920: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1921: p_payroll_action_id => p_payroll_action_id,
1922: p_token_name => 'Status',
1923: p_token_value => l_status_code);
1924: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1924: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1920: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1921: p_payroll_action_id => p_payroll_action_id,
1922: p_token_name => 'Status',
1923: p_token_value => l_status_code);
1924: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1925: p_payroll_action_id => p_payroll_action_id,
1926: p_token_name => 'Run_Type',
1927: p_token_value => l_run_type_code);
1928: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',

Line 1994: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1990: l_benefit_start_date VARCHAR2(20);
1991: l_status_code varchar2(10);
1992: l_status_meaning varchar2(20);
1993: begin
1994: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1995: p_payroll_action_id => p_payroll_action_id,
1996: p_token_name => 'BENEFIT_END_DATE',
1997: p_token_value => l_benefit_end_date);
1998: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 1998: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

1994: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1995: p_payroll_action_id => p_payroll_action_id,
1996: p_token_name => 'BENEFIT_END_DATE',
1997: p_token_value => l_benefit_end_date);
1998: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
1999: p_payroll_action_id => p_payroll_action_id,
2000: p_token_name => 'Status',
2001: p_token_value => l_status_code);
2002: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',

Line 2014: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2010: l_benefit_end_date VARCHAR2(20);
2011: l_run_type_code varchar2(10);
2012: l_run_type_meaning varchar2(20);
2013: begin
2014: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2015: p_payroll_action_id => p_payroll_action_id,
2016: p_token_name => 'BENEFIT_END_DATE',
2017: p_token_value => l_benefit_end_date);
2018: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2018: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2014: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2015: p_payroll_action_id => p_payroll_action_id,
2016: p_token_name => 'BENEFIT_END_DATE',
2017: p_token_value => l_benefit_end_date);
2018: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2019: p_payroll_action_id => p_payroll_action_id,
2020: p_token_name => 'Run_Type',
2021: p_token_value => l_run_type_code);
2022: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',

Line 2777: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2773: l_national_ins_no,
2774: l_employee_number);
2775: l_pactid := get_pactid(p_assignment_action_id);
2776: l_person_id := get_person_id (p_assignment_action_id );
2777: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2778: p_payroll_action_id => l_pactid,
2779: p_token_name => 'Rep_Run',
2780: p_token_value => l_rep_run);
2781:

Line 3671: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

3667: l_pactid := get_pactid(p_assignment_action_id);
3668: l_person_id := get_person_id (p_assignment_action_id );
3669: l_loop_count := 0;
3670:
3671: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
3672: p_payroll_action_id => l_pactid,
3673: p_token_name => 'Rep_Run',
3674: p_token_value => l_rep_run);
3675:

Line 4102: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

4098: l_national_ins_no,
4099: l_employee_number);
4100: l_pactid := get_pactid(p_assignment_action_id);
4101: l_person_id := get_person_id (p_assignment_action_id );
4102: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
4103: p_payroll_action_id => l_pactid,
4104: p_token_name => 'Rep_Run',
4105: p_token_value => l_rep_run);
4106:

Line 5148: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

5144: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);
5145: dbms_lob.open(l_xfdf_str,dbms_lob.lob_readwrite);
5146:
5147:
5148: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
5149: p_payroll_action_id => l_pactid,
5150: p_token_name => 'Rep_Run',
5151: p_token_value => l_rep_run);
5152: l_loop_count := 0;

Line 5700: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => p_arch_payroll_action_id,

5696: l_rep_run varchar2(10);
5697:
5698: BEGIN
5699:
5700: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => p_arch_payroll_action_id,
5701: p_token_name => 'Rep_Run',
5702: p_token_value => l_rep_run);
5703:
5704: OPEN get_assignment_action_id;