APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_JP_ISDF_DML_PKG

Line 243: pay_jp_isdf_dml_pkg.create_pact(

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

Line 244: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

Line 1526: pay_jp_isdf_dml_pkg.create_emp(

1522: if g_debug then
1523: hr_utility.trace('start create_emp');
1524: end if;
1525: --
1526: pay_jp_isdf_dml_pkg.create_emp(
1527: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1528: p_assignment_action_id => p_assignment_action_id,
1529: p_action_context_type => 'AAP',
1530: p_assignment_id => p_assignment_id,

Line 1527: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1523: hr_utility.trace('start create_emp');
1524: end if;
1525: --
1526: pay_jp_isdf_dml_pkg.create_emp(
1527: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1528: p_assignment_action_id => p_assignment_action_id,
1529: p_action_context_type => 'AAP',
1530: p_assignment_id => p_assignment_id,
1531: p_effective_date => g_effective_date,

Line 1561: pay_jp_isdf_dml_pkg.create_entry(

1557: p_entry_rec => l_entry_rec);
1558: --
1559: if l_entry_rec.ins_entry_cnt + l_entry_rec.is_entry_cnt > 0 then
1560: --
1561: pay_jp_isdf_dml_pkg.create_entry(
1562: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1563: p_assignment_action_id => p_assignment_action_id,
1564: p_action_context_type => 'AAP',
1565: p_assignment_id => p_assignment_id,

Line 1562: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1558: --
1559: if l_entry_rec.ins_entry_cnt + l_entry_rec.is_entry_cnt > 0 then
1560: --
1561: pay_jp_isdf_dml_pkg.create_entry(
1562: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1563: p_assignment_action_id => p_assignment_action_id,
1564: p_action_context_type => 'AAP',
1565: p_assignment_id => p_assignment_id,
1566: p_effective_date => g_effective_date,

Line 1660: pay_jp_isdf_dml_pkg.create_life_gen(

1656: hr_utility.set_location(l_proc,70);
1657: hr_utility.trace('annual_prem : '||l_lig_prem);
1658: end if;
1659: --
1660: pay_jp_isdf_dml_pkg.create_life_gen(
1661: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1662: p_assignment_action_id => p_assignment_action_id,
1663: p_action_context_type => 'AAP',
1664: p_assignment_id => p_assignment_id,

Line 1661: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1657: hr_utility.trace('annual_prem : '||l_lig_prem);
1658: end if;
1659: --
1660: pay_jp_isdf_dml_pkg.create_life_gen(
1661: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1662: p_assignment_action_id => p_assignment_action_id,
1663: p_action_context_type => 'AAP',
1664: p_assignment_id => p_assignment_id,
1665: p_effective_date => g_effective_date,

Line 1744: pay_jp_isdf_dml_pkg.create_care_med(

1740: hr_utility.set_location(l_proc,87);
1741: hr_utility.trace('annual_prem : '||l_cmi_prem);
1742: end if;
1743: --
1744: pay_jp_isdf_dml_pkg.create_care_med(
1745: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1746: p_assignment_action_id => p_assignment_action_id,
1747: p_action_context_type => 'AAP',
1748: p_assignment_id => p_assignment_id,

Line 1745: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1741: hr_utility.trace('annual_prem : '||l_cmi_prem);
1742: end if;
1743: --
1744: pay_jp_isdf_dml_pkg.create_care_med(
1745: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1746: p_assignment_action_id => p_assignment_action_id,
1747: p_action_context_type => 'AAP',
1748: p_assignment_id => p_assignment_id,
1749: p_effective_date => g_effective_date,

Line 1828: pay_jp_isdf_dml_pkg.create_life_pens(

1824: hr_utility.set_location(l_proc,110);
1825: hr_utility.trace('annual_prem : '||l_lip_prem);
1826: end if;
1827: --
1828: pay_jp_isdf_dml_pkg.create_life_pens(
1829: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1830: p_assignment_action_id => p_assignment_action_id,
1831: p_action_context_type => 'AAP',
1832: p_assignment_id => p_assignment_id,

Line 1829: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1825: hr_utility.trace('annual_prem : '||l_lip_prem);
1826: end if;
1827: --
1828: pay_jp_isdf_dml_pkg.create_life_pens(
1829: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1830: p_assignment_action_id => p_assignment_action_id,
1831: p_action_context_type => 'AAP',
1832: p_assignment_id => p_assignment_id,
1833: p_effective_date => g_effective_date,

Line 1924: pay_jp_isdf_dml_pkg.create_nonlife(

1920: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;
1923: --
1924: pay_jp_isdf_dml_pkg.create_nonlife(
1925: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1926: p_assignment_action_id => p_assignment_action_id,
1927: p_action_context_type => 'AAP',
1928: p_assignment_id => p_assignment_id,

Line 1925: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;
1923: --
1924: pay_jp_isdf_dml_pkg.create_nonlife(
1925: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1926: p_assignment_action_id => p_assignment_action_id,
1927: p_action_context_type => 'AAP',
1928: p_assignment_id => p_assignment_id,
1929: p_effective_date => g_effective_date,

Line 1986: pay_jp_isdf_dml_pkg.create_spouse(

1982: end if;
1983: --
1984: end if;
1985: --
1986: pay_jp_isdf_dml_pkg.create_spouse(
1987: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1988: p_assignment_action_id => p_assignment_action_id,
1989: p_action_context_type => 'AAP',
1990: p_assignment_id => p_assignment_id,

Line 1987: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

1983: --
1984: end if;
1985: --
1986: pay_jp_isdf_dml_pkg.create_spouse(
1987: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
1988: p_assignment_action_id => p_assignment_action_id,
1989: p_action_context_type => 'AAP',
1990: p_assignment_id => p_assignment_id,
1991: p_effective_date => g_effective_date,

Line 2049: pay_jp_isdf_dml_pkg.create_life_gen(

2045: --
2046: fetch csr_copy_life_gen into l_csr_copy_life_gen;
2047: exit when csr_copy_life_gen%notfound;
2048: --
2049: pay_jp_isdf_dml_pkg.create_life_gen(
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_life_gen into l_csr_copy_life_gen;
2047: exit when csr_copy_life_gen%notfound;
2048: --
2049: pay_jp_isdf_dml_pkg.create_life_gen(
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 2086: pay_jp_isdf_dml_pkg.create_care_med(

2082: --
2083: fetch csr_copy_care_med into l_csr_copy_care_med;
2084: exit when csr_copy_care_med%notfound;
2085: --
2086: pay_jp_isdf_dml_pkg.create_care_med(
2087: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2088: p_assignment_action_id => p_assignment_action_id,
2089: p_action_context_type => 'AAP',
2090: p_assignment_id => p_assignment_id,

Line 2087: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2083: fetch csr_copy_care_med into l_csr_copy_care_med;
2084: exit when csr_copy_care_med%notfound;
2085: --
2086: pay_jp_isdf_dml_pkg.create_care_med(
2087: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2088: p_assignment_action_id => p_assignment_action_id,
2089: p_action_context_type => 'AAP',
2090: p_assignment_id => p_assignment_id,
2091: p_effective_date => g_effective_date,

Line 2124: pay_jp_isdf_dml_pkg.create_life_pens(

2120: --
2121: fetch csr_copy_life_pens into l_csr_copy_life_pens;
2122: exit when csr_copy_life_pens%notfound;
2123: --
2124: pay_jp_isdf_dml_pkg.create_life_pens(
2125: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2126: p_assignment_action_id => p_assignment_action_id,
2127: p_action_context_type => 'AAP',
2128: p_assignment_id => p_assignment_id,

Line 2125: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2121: fetch csr_copy_life_pens into l_csr_copy_life_pens;
2122: exit when csr_copy_life_pens%notfound;
2123: --
2124: pay_jp_isdf_dml_pkg.create_life_pens(
2125: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2126: p_assignment_action_id => p_assignment_action_id,
2127: p_action_context_type => 'AAP',
2128: p_assignment_id => p_assignment_id,
2129: p_effective_date => g_effective_date,

Line 2162: pay_jp_isdf_dml_pkg.create_nonlife(

2158: --
2159: fetch csr_copy_nonlife into l_csr_copy_nonlife;
2160: exit when csr_copy_nonlife%notfound;
2161: --
2162: pay_jp_isdf_dml_pkg.create_nonlife(
2163: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2164: p_assignment_action_id => p_assignment_action_id,
2165: p_action_context_type => 'AAP',
2166: p_assignment_id => p_assignment_id,

Line 2163: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2159: fetch csr_copy_nonlife into l_csr_copy_nonlife;
2160: exit when csr_copy_nonlife%notfound;
2161: --
2162: pay_jp_isdf_dml_pkg.create_nonlife(
2163: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2164: p_assignment_action_id => p_assignment_action_id,
2165: p_action_context_type => 'AAP',
2166: p_assignment_id => p_assignment_id,
2167: p_effective_date => g_effective_date,

Line 2200: pay_jp_isdf_dml_pkg.create_social(

2196: --
2197: fetch csr_copy_social into l_csr_copy_social;
2198: exit when csr_copy_social%notfound;
2199: --
2200: pay_jp_isdf_dml_pkg.create_social(
2201: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2202: p_assignment_action_id => p_assignment_action_id,
2203: p_action_context_type => 'AAP',
2204: p_assignment_id => p_assignment_id,

Line 2201: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2197: fetch csr_copy_social into l_csr_copy_social;
2198: exit when csr_copy_social%notfound;
2199: --
2200: pay_jp_isdf_dml_pkg.create_social(
2201: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2202: p_assignment_action_id => p_assignment_action_id,
2203: p_action_context_type => 'AAP',
2204: p_assignment_id => p_assignment_id,
2205: p_effective_date => g_effective_date,

Line 2231: pay_jp_isdf_dml_pkg.create_mutual_aid(

2227: --
2228: fetch csr_copy_mutual_aid into l_csr_copy_mutual_aid;
2229: exit when csr_copy_mutual_aid%notfound;
2230: --
2231: pay_jp_isdf_dml_pkg.create_mutual_aid(
2232: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2233: p_assignment_action_id => p_assignment_action_id,
2234: p_action_context_type => 'AAP',
2235: p_assignment_id => p_assignment_id,

Line 2232: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2228: fetch csr_copy_mutual_aid into l_csr_copy_mutual_aid;
2229: exit when csr_copy_mutual_aid%notfound;
2230: --
2231: pay_jp_isdf_dml_pkg.create_mutual_aid(
2232: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2233: p_assignment_action_id => p_assignment_action_id,
2234: p_action_context_type => 'AAP',
2235: p_assignment_id => p_assignment_id,
2236: p_effective_date => g_effective_date,

Line 2259: pay_jp_isdf_dml_pkg.create_spouse(

2255: --
2256: fetch csr_copy_spouse into l_csr_copy_spouse;
2257: exit when csr_copy_spouse%notfound;
2258: --
2259: pay_jp_isdf_dml_pkg.create_spouse(
2260: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2261: p_assignment_action_id => p_assignment_action_id,
2262: p_action_context_type => 'AAP',
2263: p_assignment_id => p_assignment_id,

Line 2260: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2256: fetch csr_copy_spouse into l_csr_copy_spouse;
2257: exit when csr_copy_spouse%notfound;
2258: --
2259: pay_jp_isdf_dml_pkg.create_spouse(
2260: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2261: p_assignment_action_id => p_assignment_action_id,
2262: p_action_context_type => 'AAP',
2263: p_assignment_id => p_assignment_id,
2264: p_effective_date => g_effective_date,

Line 2293: pay_jp_isdf_dml_pkg.create_spouse_inc(

2289: --
2290: fetch csr_copy_spouse_inc into l_csr_copy_spouse_inc;
2291: exit when csr_copy_spouse_inc%notfound;
2292: --
2293: pay_jp_isdf_dml_pkg.create_spouse_inc(
2294: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2295: p_assignment_action_id => p_assignment_action_id,
2296: p_action_context_type => 'AAP',
2297: p_assignment_id => p_assignment_id,

Line 2294: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

2290: fetch csr_copy_spouse_inc into l_csr_copy_spouse_inc;
2291: exit when csr_copy_spouse_inc%notfound;
2292: --
2293: pay_jp_isdf_dml_pkg.create_spouse_inc(
2294: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,
2295: p_assignment_action_id => p_assignment_action_id,
2296: p_action_context_type => 'AAP',
2297: p_assignment_id => p_assignment_id,
2298: p_effective_date => g_effective_date,

Line 2373: pay_jp_isdf_dml_pkg.update_assact(

2369: hr_utility.trace('object_version_number : '||p_object_version_number);
2370: end if;
2371: --
2372: -- include lock assact (only transaction,ovn will be changed, others same as new condition)
2373: pay_jp_isdf_dml_pkg.update_assact(
2374: p_action_information_id => p_action_information_id,
2375: p_object_version_number => p_object_version_number,
2376: p_transaction_status => 'N',
2377: p_finalized_date => null,

Line 2452: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;

2448: hr_utility.set_location(l_proc,30);
2449: hr_utility.trace('start create_assact');
2450: end if;
2451: --
2452: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2453: --
2454: pay_jp_isdf_dml_pkg.create_assact(
2455: p_action_information_id => l_action_information_id,
2456: p_assignment_action_id => p_assignment_action_id,

Line 2454: pay_jp_isdf_dml_pkg.create_assact(

2450: end if;
2451: --
2452: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2453: --
2454: pay_jp_isdf_dml_pkg.create_assact(
2455: p_action_information_id => l_action_information_id,
2456: p_assignment_action_id => p_assignment_action_id,
2457: p_action_context_type => 'AAP',
2458: p_assignment_id => l_assignment_id,