DBA Data[Home] [Help]

APPS.PAY_CC_PROCESS_UTILS dependencies on PAY_DYN_TRIGGERS

Line 732: pay_dyn_triggers.create_trigger_event(

728: --
729: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
730: --
731: /* Set up the trigger */
732: pay_dyn_triggers.create_trigger_event(
733: p_table_name||'_ARU',
734: p_table_name,
735: 'Continuous Calcuation trigger on update of '||p_table_name,
736: 'N',

Line 743: pay_dyn_triggers.create_trg_declaration(

739: NULL
740: );
741: --
742: /* Setup the business Group */
743: pay_dyn_triggers.create_trg_declaration(
744: p_table_name||'_ARU',
745: 'business_group_id',
746: 'N',
747: NULL,

Line 751: pay_dyn_triggers.create_trg_initialisation(

747: NULL,
748: NULL
749: );
750: --
751: pay_dyn_triggers.create_trg_initialisation(
752: p_table_name||'_ARU',
753: '1',
754: 'pay_core_utils.get_business_group',
755: 'F',

Line 759: pay_dyn_triggers.create_trg_parameter(

755: 'F',
756: NULL
757: );
758: --
759: pay_dyn_triggers.create_trg_parameter(
760: p_table_name||'_ARU',
761: 1,
762: NULL,
763: NULL,

Line 774: pay_dyn_triggers.create_trg_parameter(

770: 'N',
771: NULL
772: );
773: --
774: pay_dyn_triggers.create_trg_parameter(
775: p_table_name||'_ARU',
776: 1,
777: NULL,
778: NULL,

Line 790: pay_dyn_triggers.create_trg_declaration(

786: NULL
787: );
788: --
789: /* Setup the legislation code */
790: pay_dyn_triggers.create_trg_declaration(
791: p_table_name||'_ARU',
792: 'legislation_code',
793: 'C',
794: 10,

Line 798: pay_dyn_triggers.create_trg_initialisation(

794: 10,
795: NULL
796: );
797: --
798: pay_dyn_triggers.create_trg_initialisation(
799: p_table_name||'_ARU',
800: '2',
801: 'pay_core_utils.get_legislation_code',
802: 'F',

Line 806: pay_dyn_triggers.create_trg_parameter(

802: 'F',
803: NULL
804: );
805: --
806: pay_dyn_triggers.create_trg_parameter(
807: p_table_name||'_ARU',
808: 2,
809: NULL,
810: NULL,

Line 821: pay_dyn_triggers.create_trg_parameter(

817: 'N',
818: NULL
819: );
820: --
821: pay_dyn_triggers.create_trg_parameter(
822: p_table_name||'_ARU',
823: 2,
824: NULL,
825: NULL,

Line 836: pay_dyn_triggers.create_trg_components(

832: 'N',
833: NULL
834: );
835: --
836: pay_dyn_triggers.create_trg_components(
837: p_table_name||'_ARU',
838: NULL,
839: NULL,
840: NULL,

Line 846: pay_dyn_triggers.create_trg_parameter(

842: 'N',
843: NULL
844: );
845: --
846: pay_dyn_triggers.create_trg_parameter(
847: p_table_name||'_ARU',
848: NULL,
849: NULL,
850: NULL,

Line 861: pay_dyn_triggers.create_trg_parameter(

857: 'N',
858: NULL
859: );
860: --
861: pay_dyn_triggers.create_trg_parameter(
862: p_table_name||'_ARU',
863: NULL,
864: NULL,
865: NULL,

Line 876: pay_dyn_triggers.create_trg_parameter(

872: 'N',
873: NULL
874: );
875: --
876: pay_dyn_triggers.create_trg_parameter(
877: p_table_name||'_ARU',
878: NULL,
879: NULL,
880: NULL,

Line 892: pay_dyn_triggers.create_trg_parameter(

888: NULL
889: );
890: --
891: for colrec in get_columns(p_table_name) loop
892: pay_dyn_triggers.create_trg_parameter(
893: p_table_name||'_ARU',
894: NULL,
895: NULL,
896: NULL,

Line 907: pay_dyn_triggers.create_trg_parameter(

903: 'N',
904: NULL
905: );
906: --
907: pay_dyn_triggers.create_trg_parameter(
908: p_table_name||'_ARU',
909: NULL,
910: NULL,
911: NULL,

Line 1553: proc := ' pay_dyn_triggers.create_trigger_event(

1549: hr_utility.trace_on(null, p_table_name);
1550: --
1551: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1552: --
1553: proc := ' pay_dyn_triggers.create_trigger_event(
1554: '''||p_table_name||'_ARU'',
1555: '''||p_table_name||''',
1556: ''Description'',
1557: ''N'',

Line 1567: proc := ' pay_dyn_triggers.create_trg_declaration(

1563: ';
1564: --
1565: hr_utility.trace(proc);
1566: --
1567: proc := ' pay_dyn_triggers.create_trg_declaration(
1568: '''||p_table_name||'_ARU'',
1569: ''business_group_id'',
1570: ''N'',
1571: NULL,

Line 1578: proc := ' pay_dyn_triggers.create_trg_initialisation(

1574: --
1575: ';
1576: hr_utility.trace(proc);
1577: --
1578: proc := ' pay_dyn_triggers.create_trg_initialisation(
1579: '''||p_table_name||'_ARU'',
1580: ''1'',
1581: ''pay_core_utils.get_business_group'',
1582: ''F'',

Line 1590: proc := ' pay_dyn_triggers.create_trg_parameter(

1586: --
1587: ';
1588: hr_utility.trace(proc);
1589: --
1590: proc := ' pay_dyn_triggers.create_trg_parameter(
1591: '''||p_table_name||'_ARU'',
1592: 1,
1593: NULL,
1594: NULL,

Line 1608: proc := ' pay_dyn_triggers.create_trg_parameter(

1604: --
1605: ';
1606: hr_utility.trace(proc);
1607: --
1608: proc := ' pay_dyn_triggers.create_trg_parameter(
1609: '''||p_table_name||'_ARU'',
1610: 1,
1611: NULL,
1612: NULL,

Line 1626: proc := ' pay_dyn_triggers.create_trg_declaration(

1622: --
1623: ';
1624: hr_utility.trace(proc);
1625: --
1626: proc := ' pay_dyn_triggers.create_trg_declaration(
1627: '''||p_table_name||'_ARU'',
1628: ''legislation_code'',
1629: ''C'',
1630: 10,

Line 1637: proc := ' pay_dyn_triggers.create_trg_initialisation(

1633: --
1634: ';
1635: hr_utility.trace(proc);
1636: --
1637: proc := ' pay_dyn_triggers.create_trg_initialisation(
1638: '''||p_table_name||'_ARU'',
1639: ''2'',
1640: ''pay_core_utils.get_legislation_code'',
1641: ''F'',

Line 1649: proc := ' pay_dyn_triggers.create_trg_parameter(

1645: --
1646: ';
1647: hr_utility.trace(proc);
1648: --
1649: proc := ' pay_dyn_triggers.create_trg_parameter(
1650: '''||p_table_name||'_ARU'',
1651: 2,
1652: NULL,
1653: NULL,

Line 1667: proc := ' pay_dyn_triggers.create_trg_parameter(

1663: --
1664: ';
1665: hr_utility.trace(proc);
1666: --
1667: proc := ' pay_dyn_triggers.create_trg_parameter(
1668: '''||p_table_name||'_ARU'',
1669: 2,
1670: NULL,
1671: NULL,

Line 1685: proc := ' pay_dyn_triggers.create_trg_components(

1681: --
1682: ';
1683: hr_utility.trace(proc);
1684: --
1685: proc := ' pay_dyn_triggers.create_trg_components(
1686: '''||p_table_name||'_ARU'',
1687: NULL,
1688: NULL,
1689: NULL,

Line 1699: proc := ' pay_dyn_triggers.create_trg_parameter(

1695: --
1696: ';
1697: hr_utility.trace(proc);
1698: --
1699: proc := ' pay_dyn_triggers.create_trg_parameter(
1700: '''||p_table_name||'_ARU'',
1701: NULL,
1702: NULL,
1703: NULL,

Line 1717: proc := ' pay_dyn_triggers.create_trg_parameter(

1713: --
1714: ';
1715: hr_utility.trace(proc);
1716: --
1717: proc := ' pay_dyn_triggers.create_trg_parameter(
1718: '''||p_table_name||'_ARU'',
1719: NULL,
1720: NULL,
1721: NULL,

Line 1735: proc := ' pay_dyn_triggers.create_trg_parameter(

1731: --
1732: ';
1733: hr_utility.trace(proc);
1734: --
1735: proc := ' pay_dyn_triggers.create_trg_parameter(
1736: '''||p_table_name||'_ARU'',
1737: NULL,
1738: NULL,
1739: NULL,

Line 1754: proc := ' pay_dyn_triggers.create_trg_parameter(

1750: ';
1751: hr_utility.trace(proc);
1752: --
1753: for colrec in get_columns(p_table_name) loop
1754: proc := ' pay_dyn_triggers.create_trg_parameter(
1755: '''||p_table_name||'_ARU'',
1756: NULL,
1757: NULL,
1758: NULL,

Line 1772: proc := ' pay_dyn_triggers.create_trg_parameter(

1768: --
1769: ';
1770: hr_utility.trace(proc);
1771: --
1772: proc := ' pay_dyn_triggers.create_trg_parameter(
1773: '''||p_table_name||'_ARU'',
1774: NULL,
1775: NULL,
1776: NULL,

Line 1919: pay_dyn_triggers.create_trg_parameter (

1915:
1916:
1917: -- Create rows in trigger_parameters
1918: --
1919: pay_dyn_triggers.create_trg_parameter (
1920: p_short_name => p_table_name,
1921: p_process_order => null,
1922: p_legislative_code => null,
1923: p_business_group => null,