DBA Data[Home] [Help]

APPS.PAY_ELEMENT_ENTRY_API dependencies on PAY_ELE_SHD

Line 507: l_entry_value1 := pay_ele_shd.convert_lookups(p_input_value_id1, p_entry_value1, p_effective_date);

503: p_entry_value1 IS NOT NULL THEN
504: if g_debug then
505: hr_utility.set_location(l_proc, 200);
506: end if;
507: l_entry_value1 := pay_ele_shd.convert_lookups(p_input_value_id1, p_entry_value1, p_effective_date);
508: END IF;
509: IF p_input_value_id2 IS NOT NULL AND
510: p_entry_value2 IS NOT NULL THEN
511: if g_debug then

Line 514: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);

510: p_entry_value2 IS NOT NULL THEN
511: if g_debug then
512: hr_utility.set_location(l_proc, 210);
513: end if;
514: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);
515: END IF;
516: IF p_input_value_id3 IS NOT NULL AND
517: p_entry_value3 IS NOT NULL THEN
518: if g_debug then

Line 521: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);

517: p_entry_value3 IS NOT NULL THEN
518: if g_debug then
519: hr_utility.set_location(l_proc, 220);
520: end if;
521: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);
522: END IF;
523: IF p_input_value_id4 IS NOT NULL AND
524: p_entry_value4 IS NOT NULL THEN
525: if g_debug then

Line 528: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);

524: p_entry_value4 IS NOT NULL THEN
525: if g_debug then
526: hr_utility.set_location(l_proc, 230);
527: end if;
528: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);
529: END IF;
530: IF p_input_value_id5 IS NOT NULL AND
531: p_entry_value5 IS NOT NULL THEN
532: if g_debug then

Line 535: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);

531: p_entry_value5 IS NOT NULL THEN
532: if g_debug then
533: hr_utility.set_location(l_proc, 240);
534: end if;
535: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);
536: END IF;
537: IF p_input_value_id6 IS NOT NULL AND
538: p_entry_value6 IS NOT NULL THEN
539: if g_debug then

Line 542: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);

538: p_entry_value6 IS NOT NULL THEN
539: if g_debug then
540: hr_utility.set_location(l_proc, 250);
541: end if;
542: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);
543: END IF;
544: IF p_input_value_id7 IS NOT NULL AND
545: p_entry_value7 IS NOT NULL THEN
546: if g_debug then

Line 549: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);

545: p_entry_value7 IS NOT NULL THEN
546: if g_debug then
547: hr_utility.set_location(l_proc, 260);
548: end if;
549: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);
550: END IF;
551: IF p_input_value_id8 IS NOT NULL AND
552: p_entry_value8 IS NOT NULL THEN
553: if g_debug then

Line 556: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);

552: p_entry_value8 IS NOT NULL THEN
553: if g_debug then
554: hr_utility.set_location(l_proc, 270);
555: end if;
556: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);
557: END IF;
558: IF p_input_value_id9 IS NOT NULL AND
559: p_entry_value9 IS NOT NULL THEN
560: if g_debug then

Line 563: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);

559: p_entry_value9 IS NOT NULL THEN
560: if g_debug then
561: hr_utility.set_location(l_proc, 280);
562: end if;
563: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);
564: END IF;
565: IF p_input_value_id10 IS NOT NULL AND
566: p_entry_value10 IS NOT NULL THEN
567: if g_debug then

Line 570: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);

566: p_entry_value10 IS NOT NULL THEN
567: if g_debug then
568: hr_utility.set_location(l_proc, 290);
569: end if;
570: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);
571: END IF;
572: IF p_input_value_id11 IS NOT NULL AND
573: p_entry_value11 IS NOT NULL THEN
574: if g_debug then

Line 577: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);

573: p_entry_value11 IS NOT NULL THEN
574: if g_debug then
575: hr_utility.set_location(l_proc, 300);
576: end if;
577: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);
578: END IF;
579: IF p_input_value_id12 IS NOT NULL AND
580: p_entry_value12 IS NOT NULL THEN
581: if g_debug then

Line 584: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);

580: p_entry_value12 IS NOT NULL THEN
581: if g_debug then
582: hr_utility.set_location(l_proc, 310);
583: end if;
584: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);
585: END IF;
586: IF p_input_value_id13 IS NOT NULL AND
587: p_entry_value13 IS NOT NULL THEN
588: if g_debug then

Line 591: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);

587: p_entry_value13 IS NOT NULL THEN
588: if g_debug then
589: hr_utility.set_location(l_proc, 320);
590: end if;
591: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);
592: END IF;
593: IF p_input_value_id14 IS NOT NULL AND
594: p_entry_value14 IS NOT NULL THEN
595: if g_debug then

Line 598: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);

594: p_entry_value14 IS NOT NULL THEN
595: if g_debug then
596: hr_utility.set_location(l_proc, 330);
597: end if;
598: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);
599: END IF;
600: IF p_input_value_id15 IS NOT NULL AND
601: p_entry_value15 IS NOT NULL THEN
602: if g_debug then

Line 605: l_entry_value15 := pay_ele_shd.convert_lookups(p_input_value_id15, p_entry_value15, p_effective_date);

601: p_entry_value15 IS NOT NULL THEN
602: if g_debug then
603: hr_utility.set_location(l_proc, 340);
604: end if;
605: l_entry_value15 := pay_ele_shd.convert_lookups(p_input_value_id15, p_entry_value15, p_effective_date);
606: END IF;
607: --
608: hr_entry_api.insert_element_entry
609: (

Line 990: pay_ele_shd.lck(p_effective_date => l_effective_date

986: -- Process Logic
987: -- 1. Lock the required row
988: -- 2. Call delete element entry
989: --
990: pay_ele_shd.lck(p_effective_date => l_effective_date
991: ,p_element_entry_id => p_element_entry_id
992: ,p_object_version_number => l_object_version_number
993: ,p_datetrack_mode => p_datetrack_delete_mode
994: ,p_validation_start_date => l_validation_start_date

Line 1651: l_entry_value1 := pay_ele_shd.convert_lookups(p_input_value_id1, p_entry_value1, p_effective_date);

1647: END IF;
1648:
1649: IF p_input_value_id1 IS NOT NULL AND
1650: p_entry_value1 IS NOT NULL THEN
1651: l_entry_value1 := pay_ele_shd.convert_lookups(p_input_value_id1, p_entry_value1, p_effective_date);
1652: END IF;
1653: IF p_input_value_id2 IS NOT NULL AND
1654: p_entry_value2 IS NOT NULL THEN
1655: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);

Line 1655: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);

1651: l_entry_value1 := pay_ele_shd.convert_lookups(p_input_value_id1, p_entry_value1, p_effective_date);
1652: END IF;
1653: IF p_input_value_id2 IS NOT NULL AND
1654: p_entry_value2 IS NOT NULL THEN
1655: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);
1656: END IF;
1657: IF p_input_value_id3 IS NOT NULL AND
1658: p_entry_value3 IS NOT NULL THEN
1659: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);

Line 1659: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);

1655: l_entry_value2 := pay_ele_shd.convert_lookups(p_input_value_id2, p_entry_value2, p_effective_date);
1656: END IF;
1657: IF p_input_value_id3 IS NOT NULL AND
1658: p_entry_value3 IS NOT NULL THEN
1659: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);
1660: END IF;
1661: IF p_input_value_id4 IS NOT NULL AND
1662: p_entry_value4 IS NOT NULL THEN
1663: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);

Line 1663: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);

1659: l_entry_value3 := pay_ele_shd.convert_lookups(p_input_value_id3, p_entry_value3, p_effective_date);
1660: END IF;
1661: IF p_input_value_id4 IS NOT NULL AND
1662: p_entry_value4 IS NOT NULL THEN
1663: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);
1664: END IF;
1665: IF p_input_value_id5 IS NOT NULL AND
1666: p_entry_value5 IS NOT NULL THEN
1667: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);

Line 1667: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);

1663: l_entry_value4 := pay_ele_shd.convert_lookups(p_input_value_id4, p_entry_value4, p_effective_date);
1664: END IF;
1665: IF p_input_value_id5 IS NOT NULL AND
1666: p_entry_value5 IS NOT NULL THEN
1667: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);
1668: END IF;
1669: IF p_input_value_id6 IS NOT NULL AND
1670: p_entry_value6 IS NOT NULL THEN
1671: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);

Line 1671: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);

1667: l_entry_value5 := pay_ele_shd.convert_lookups(p_input_value_id5, p_entry_value5, p_effective_date);
1668: END IF;
1669: IF p_input_value_id6 IS NOT NULL AND
1670: p_entry_value6 IS NOT NULL THEN
1671: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);
1672: END IF;
1673: IF p_input_value_id7 IS NOT NULL AND
1674: p_entry_value7 IS NOT NULL THEN
1675: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);

Line 1675: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);

1671: l_entry_value6 := pay_ele_shd.convert_lookups(p_input_value_id6, p_entry_value6, p_effective_date);
1672: END IF;
1673: IF p_input_value_id7 IS NOT NULL AND
1674: p_entry_value7 IS NOT NULL THEN
1675: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);
1676: END IF;
1677: IF p_input_value_id8 IS NOT NULL AND
1678: p_entry_value8 IS NOT NULL THEN
1679: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);

Line 1679: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);

1675: l_entry_value7 := pay_ele_shd.convert_lookups(p_input_value_id7, p_entry_value7, p_effective_date);
1676: END IF;
1677: IF p_input_value_id8 IS NOT NULL AND
1678: p_entry_value8 IS NOT NULL THEN
1679: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);
1680: END IF;
1681: IF p_input_value_id9 IS NOT NULL AND
1682: p_entry_value9 IS NOT NULL THEN
1683: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);

Line 1683: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);

1679: l_entry_value8 := pay_ele_shd.convert_lookups(p_input_value_id8, p_entry_value8, p_effective_date);
1680: END IF;
1681: IF p_input_value_id9 IS NOT NULL AND
1682: p_entry_value9 IS NOT NULL THEN
1683: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);
1684: END IF;
1685: IF p_input_value_id10 IS NOT NULL AND
1686: p_entry_value10 IS NOT NULL THEN
1687: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);

Line 1687: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);

1683: l_entry_value9 := pay_ele_shd.convert_lookups(p_input_value_id9, p_entry_value9, p_effective_date);
1684: END IF;
1685: IF p_input_value_id10 IS NOT NULL AND
1686: p_entry_value10 IS NOT NULL THEN
1687: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);
1688: END IF;
1689: IF p_input_value_id11 IS NOT NULL AND
1690: p_entry_value11 IS NOT NULL THEN
1691: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);

Line 1691: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);

1687: l_entry_value10 := pay_ele_shd.convert_lookups(p_input_value_id10, p_entry_value10, p_effective_date);
1688: END IF;
1689: IF p_input_value_id11 IS NOT NULL AND
1690: p_entry_value11 IS NOT NULL THEN
1691: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);
1692: END IF;
1693: IF p_input_value_id12 IS NOT NULL AND
1694: p_entry_value12 IS NOT NULL THEN
1695: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);

Line 1695: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);

1691: l_entry_value11 := pay_ele_shd.convert_lookups(p_input_value_id11, p_entry_value11, p_effective_date);
1692: END IF;
1693: IF p_input_value_id12 IS NOT NULL AND
1694: p_entry_value12 IS NOT NULL THEN
1695: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);
1696: END IF;
1697: IF p_input_value_id13 IS NOT NULL AND
1698: p_entry_value13 IS NOT NULL THEN
1699: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);

Line 1699: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);

1695: l_entry_value12 := pay_ele_shd.convert_lookups(p_input_value_id12, p_entry_value12, p_effective_date);
1696: END IF;
1697: IF p_input_value_id13 IS NOT NULL AND
1698: p_entry_value13 IS NOT NULL THEN
1699: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);
1700: END IF;
1701: IF p_input_value_id14 IS NOT NULL AND
1702: p_entry_value14 IS NOT NULL THEN
1703: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);

Line 1703: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);

1699: l_entry_value13 := pay_ele_shd.convert_lookups(p_input_value_id13, p_entry_value13, p_effective_date);
1700: END IF;
1701: IF p_input_value_id14 IS NOT NULL AND
1702: p_entry_value14 IS NOT NULL THEN
1703: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);
1704: END IF;
1705: IF p_input_value_id15 IS NOT NULL AND
1706: p_entry_value15 IS NOT NULL THEN
1707: l_entry_value15 := pay_ele_shd.convert_lookups(p_input_value_id15, p_entry_value15, p_effective_date);

Line 1707: l_entry_value15 := pay_ele_shd.convert_lookups(p_input_value_id15, p_entry_value15, p_effective_date);

1703: l_entry_value14 := pay_ele_shd.convert_lookups(p_input_value_id14, p_entry_value14, p_effective_date);
1704: END IF;
1705: IF p_input_value_id15 IS NOT NULL AND
1706: p_entry_value15 IS NOT NULL THEN
1707: l_entry_value15 := pay_ele_shd.convert_lookups(p_input_value_id15, p_entry_value15, p_effective_date);
1708: END IF;
1709: --
1710:
1711: update_validate(p_element_entry_id => p_element_entry_id

Line 1750: pay_ele_shd.lck(p_effective_date => l_effective_date

1746: );
1747:
1748:
1749: --
1750: pay_ele_shd.lck(p_effective_date => l_effective_date
1751: ,p_element_entry_id => l_element_entry_id
1752: ,p_object_version_number => l_object_version_number
1753: ,p_datetrack_mode => p_datetrack_update_mode
1754: ,p_validation_start_date => l_validation_start_date