DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_JP_ISDF_DML_PKG

Line 240: pay_jp_isdf_dml_pkg.create_pact(

236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');
238: end if;
239: --
240: pay_jp_isdf_dml_pkg.create_pact(
241: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
242: p_payroll_action_id => p_payroll_action_id,
243: p_action_context_type => 'PA',
244: p_effective_date => g_effective_date,

Line 241: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

237: hr_utility.trace('start create_pact');
238: end if;
239: --
240: pay_jp_isdf_dml_pkg.create_pact(
241: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
242: p_payroll_action_id => p_payroll_action_id,
243: p_action_context_type => 'PA',
244: p_effective_date => g_effective_date,
245: p_action_information_category => 'JP_ISDF_PACT',

Line 1416: pay_jp_isdf_dml_pkg.create_emp(

1412: if g_debug then
1413: hr_utility.trace('start create_emp');
1414: end if;
1415: --
1416: pay_jp_isdf_dml_pkg.create_emp(
1417: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1418: p_assignment_action_id => p_assignment_action_id,
1419: p_action_context_type => 'AAP',
1420: p_assignment_id => p_assignment_id,

Line 1417: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1413: hr_utility.trace('start create_emp');
1414: end if;
1415: --
1416: pay_jp_isdf_dml_pkg.create_emp(
1417: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1418: p_assignment_action_id => p_assignment_action_id,
1419: p_action_context_type => 'AAP',
1420: p_assignment_id => p_assignment_id,
1421: p_effective_date => g_effective_date,

Line 1451: pay_jp_isdf_dml_pkg.create_entry(

1447: p_entry_rec => l_entry_rec);
1448: --
1449: if l_entry_rec.ins_entry_cnt + l_entry_rec.is_entry_cnt > 0 then
1450: --
1451: pay_jp_isdf_dml_pkg.create_entry(
1452: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1453: p_assignment_action_id => p_assignment_action_id,
1454: p_action_context_type => 'AAP',
1455: p_assignment_id => p_assignment_id,

Line 1452: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1448: --
1449: if l_entry_rec.ins_entry_cnt + l_entry_rec.is_entry_cnt > 0 then
1450: --
1451: pay_jp_isdf_dml_pkg.create_entry(
1452: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1453: p_assignment_action_id => p_assignment_action_id,
1454: p_action_context_type => 'AAP',
1455: p_assignment_id => p_assignment_id,
1456: p_effective_date => g_effective_date,

Line 1545: pay_jp_isdf_dml_pkg.create_life_gen(

1541: hr_utility.set_location(l_proc,70);
1542: hr_utility.trace('annual_prem : '||l_lig_prem);
1543: end if;
1544: --
1545: pay_jp_isdf_dml_pkg.create_life_gen(
1546: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1547: p_assignment_action_id => p_assignment_action_id,
1548: p_action_context_type => 'AAP',
1549: p_assignment_id => p_assignment_id,

Line 1546: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1542: hr_utility.trace('annual_prem : '||l_lig_prem);
1543: end if;
1544: --
1545: pay_jp_isdf_dml_pkg.create_life_gen(
1546: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1547: p_assignment_action_id => p_assignment_action_id,
1548: p_action_context_type => 'AAP',
1549: p_assignment_id => p_assignment_id,
1550: p_effective_date => g_effective_date,

Line 1625: pay_jp_isdf_dml_pkg.create_life_pens(

1621: hr_utility.set_location(l_proc,110);
1622: hr_utility.trace('annual_prem : '||l_lip_prem);
1623: end if;
1624: --
1625: pay_jp_isdf_dml_pkg.create_life_pens(
1626: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1627: p_assignment_action_id => p_assignment_action_id,
1628: p_action_context_type => 'AAP',
1629: p_assignment_id => p_assignment_id,

Line 1626: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1622: hr_utility.trace('annual_prem : '||l_lip_prem);
1623: end if;
1624: --
1625: pay_jp_isdf_dml_pkg.create_life_pens(
1626: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1627: p_assignment_action_id => p_assignment_action_id,
1628: p_action_context_type => 'AAP',
1629: p_assignment_id => p_assignment_id,
1630: p_effective_date => g_effective_date,

Line 1720: pay_jp_isdf_dml_pkg.create_nonlife(

1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;
1719: --
1720: pay_jp_isdf_dml_pkg.create_nonlife(
1721: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1722: p_assignment_action_id => p_assignment_action_id,
1723: p_action_context_type => 'AAP',
1724: p_assignment_id => p_assignment_id,

Line 1721: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;
1719: --
1720: pay_jp_isdf_dml_pkg.create_nonlife(
1721: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1722: p_assignment_action_id => p_assignment_action_id,
1723: p_action_context_type => 'AAP',
1724: p_assignment_id => p_assignment_id,
1725: p_effective_date => g_effective_date,

Line 1782: pay_jp_isdf_dml_pkg.create_spouse(

1778: end if;
1779: --
1780: end if;
1781: --
1782: pay_jp_isdf_dml_pkg.create_spouse(
1783: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1784: p_assignment_action_id => p_assignment_action_id,
1785: p_action_context_type => 'AAP',
1786: p_assignment_id => p_assignment_id,

Line 1783: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1779: --
1780: end if;
1781: --
1782: pay_jp_isdf_dml_pkg.create_spouse(
1783: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1784: p_assignment_action_id => p_assignment_action_id,
1785: p_action_context_type => 'AAP',
1786: p_assignment_id => p_assignment_id,
1787: p_effective_date => g_effective_date,

Line 1845: pay_jp_isdf_dml_pkg.create_life_gen(

1841: --
1842: fetch csr_copy_life_gen into l_csr_copy_life_gen;
1843: exit when csr_copy_life_gen%notfound;
1844: --
1845: pay_jp_isdf_dml_pkg.create_life_gen(
1846: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1847: p_assignment_action_id => p_assignment_action_id,
1848: p_action_context_type => 'AAP',
1849: p_assignment_id => p_assignment_id,

Line 1846: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1842: fetch csr_copy_life_gen into l_csr_copy_life_gen;
1843: exit when csr_copy_life_gen%notfound;
1844: --
1845: pay_jp_isdf_dml_pkg.create_life_gen(
1846: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1847: p_assignment_action_id => p_assignment_action_id,
1848: p_action_context_type => 'AAP',
1849: p_assignment_id => p_assignment_id,
1850: p_effective_date => g_effective_date,

Line 1881: pay_jp_isdf_dml_pkg.create_life_pens(

1877: --
1878: fetch csr_copy_life_pens into l_csr_copy_life_pens;
1879: exit when csr_copy_life_pens%notfound;
1880: --
1881: pay_jp_isdf_dml_pkg.create_life_pens(
1882: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1883: p_assignment_action_id => p_assignment_action_id,
1884: p_action_context_type => 'AAP',
1885: p_assignment_id => p_assignment_id,

Line 1882: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1878: fetch csr_copy_life_pens into l_csr_copy_life_pens;
1879: exit when csr_copy_life_pens%notfound;
1880: --
1881: pay_jp_isdf_dml_pkg.create_life_pens(
1882: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1883: p_assignment_action_id => p_assignment_action_id,
1884: p_action_context_type => 'AAP',
1885: p_assignment_id => p_assignment_id,
1886: p_effective_date => g_effective_date,

Line 1918: pay_jp_isdf_dml_pkg.create_nonlife(

1914: --
1915: fetch csr_copy_nonlife into l_csr_copy_nonlife;
1916: exit when csr_copy_nonlife%notfound;
1917: --
1918: pay_jp_isdf_dml_pkg.create_nonlife(
1919: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1920: p_assignment_action_id => p_assignment_action_id,
1921: p_action_context_type => 'AAP',
1922: p_assignment_id => p_assignment_id,

Line 1919: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1915: fetch csr_copy_nonlife into l_csr_copy_nonlife;
1916: exit when csr_copy_nonlife%notfound;
1917: --
1918: pay_jp_isdf_dml_pkg.create_nonlife(
1919: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1920: p_assignment_action_id => p_assignment_action_id,
1921: p_action_context_type => 'AAP',
1922: p_assignment_id => p_assignment_id,
1923: p_effective_date => g_effective_date,

Line 1956: pay_jp_isdf_dml_pkg.create_social(

1952: --
1953: fetch csr_copy_social into l_csr_copy_social;
1954: exit when csr_copy_social%notfound;
1955: --
1956: pay_jp_isdf_dml_pkg.create_social(
1957: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1958: p_assignment_action_id => p_assignment_action_id,
1959: p_action_context_type => 'AAP',
1960: p_assignment_id => p_assignment_id,

Line 1957: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1953: fetch csr_copy_social into l_csr_copy_social;
1954: exit when csr_copy_social%notfound;
1955: --
1956: pay_jp_isdf_dml_pkg.create_social(
1957: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1958: p_assignment_action_id => p_assignment_action_id,
1959: p_action_context_type => 'AAP',
1960: p_assignment_id => p_assignment_id,
1961: p_effective_date => g_effective_date,

Line 1987: pay_jp_isdf_dml_pkg.create_mutual_aid(

1983: --
1984: fetch csr_copy_mutual_aid into l_csr_copy_mutual_aid;
1985: exit when csr_copy_mutual_aid%notfound;
1986: --
1987: pay_jp_isdf_dml_pkg.create_mutual_aid(
1988: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1989: p_assignment_action_id => p_assignment_action_id,
1990: p_action_context_type => 'AAP',
1991: p_assignment_id => p_assignment_id,

Line 1988: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1984: fetch csr_copy_mutual_aid into l_csr_copy_mutual_aid;
1985: exit when csr_copy_mutual_aid%notfound;
1986: --
1987: pay_jp_isdf_dml_pkg.create_mutual_aid(
1988: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1989: p_assignment_action_id => p_assignment_action_id,
1990: p_action_context_type => 'AAP',
1991: p_assignment_id => p_assignment_id,
1992: p_effective_date => g_effective_date,

Line 2015: pay_jp_isdf_dml_pkg.create_spouse(

2011: --
2012: fetch csr_copy_spouse into l_csr_copy_spouse;
2013: exit when csr_copy_spouse%notfound;
2014: --
2015: pay_jp_isdf_dml_pkg.create_spouse(
2016: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2017: p_assignment_action_id => p_assignment_action_id,
2018: p_action_context_type => 'AAP',
2019: p_assignment_id => p_assignment_id,

Line 2016: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2012: fetch csr_copy_spouse into l_csr_copy_spouse;
2013: exit when csr_copy_spouse%notfound;
2014: --
2015: pay_jp_isdf_dml_pkg.create_spouse(
2016: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2017: p_assignment_action_id => p_assignment_action_id,
2018: p_action_context_type => 'AAP',
2019: p_assignment_id => p_assignment_id,
2020: p_effective_date => g_effective_date,

Line 2049: pay_jp_isdf_dml_pkg.create_spouse_inc(

2045: --
2046: fetch csr_copy_spouse_inc into l_csr_copy_spouse_inc;
2047: exit when csr_copy_spouse_inc%notfound;
2048: --
2049: pay_jp_isdf_dml_pkg.create_spouse_inc(
2050: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2051: p_assignment_action_id => p_assignment_action_id,
2052: p_action_context_type => 'AAP',
2053: p_assignment_id => p_assignment_id,

Line 2050: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2046: fetch csr_copy_spouse_inc into l_csr_copy_spouse_inc;
2047: exit when csr_copy_spouse_inc%notfound;
2048: --
2049: pay_jp_isdf_dml_pkg.create_spouse_inc(
2050: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2051: p_assignment_action_id => p_assignment_action_id,
2052: p_action_context_type => 'AAP',
2053: p_assignment_id => p_assignment_id,
2054: p_effective_date => g_effective_date,

Line 2129: pay_jp_isdf_dml_pkg.update_assact(

2125: hr_utility.trace('object_version_number : '||p_object_version_number);
2126: end if;
2127: --
2128: -- include lock assact (only transaction,ovn will be changed, others same as new condition)
2129: pay_jp_isdf_dml_pkg.update_assact(
2130: p_action_information_id => p_action_information_id,
2131: p_object_version_number => p_object_version_number,
2132: p_transaction_status => 'N',
2133: p_finalized_date => null,

Line 2208: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;

2204: hr_utility.set_location(l_proc,30);
2205: hr_utility.trace('start create_assact');
2206: end if;
2207: --
2208: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2209: --
2210: pay_jp_isdf_dml_pkg.create_assact(
2211: p_action_information_id => l_action_information_id,
2212: p_assignment_action_id => p_assignment_action_id,

Line 2210: pay_jp_isdf_dml_pkg.create_assact(

2206: end if;
2207: --
2208: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2209: --
2210: pay_jp_isdf_dml_pkg.create_assact(
2211: p_action_information_id => l_action_information_id,
2212: p_assignment_action_id => p_assignment_action_id,
2213: p_action_context_type => 'AAP',
2214: p_assignment_id => l_assignment_id,