DBA Data[Home] [Help]

APPS.PAY_CC_PROCESS_UTILS dependencies on PAY_DYN_TRIGGERS

Line 709: pay_dyn_triggers.create_trigger_event(

705: --
706: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
707: --
708: /* Set up the trigger */
709: pay_dyn_triggers.create_trigger_event(
710: p_table_name||'_ARU',
711: p_table_name,
712: 'Continuous Calcuation trigger on update of '||p_table_name,
713: 'N',

Line 720: pay_dyn_triggers.create_trg_declaration(

716: NULL
717: );
718: --
719: /* Setup the business Group */
720: pay_dyn_triggers.create_trg_declaration(
721: p_table_name||'_ARU',
722: 'business_group_id',
723: 'N',
724: NULL,

Line 728: pay_dyn_triggers.create_trg_initialisation(

724: NULL,
725: NULL
726: );
727: --
728: pay_dyn_triggers.create_trg_initialisation(
729: p_table_name||'_ARU',
730: '1',
731: 'pay_core_utils.get_business_group',
732: 'F',

Line 736: pay_dyn_triggers.create_trg_parameter(

732: 'F',
733: NULL
734: );
735: --
736: pay_dyn_triggers.create_trg_parameter(
737: p_table_name||'_ARU',
738: 1,
739: NULL,
740: NULL,

Line 751: pay_dyn_triggers.create_trg_parameter(

747: 'N',
748: NULL
749: );
750: --
751: pay_dyn_triggers.create_trg_parameter(
752: p_table_name||'_ARU',
753: 1,
754: NULL,
755: NULL,

Line 767: pay_dyn_triggers.create_trg_declaration(

763: NULL
764: );
765: --
766: /* Setup the legislation code */
767: pay_dyn_triggers.create_trg_declaration(
768: p_table_name||'_ARU',
769: 'legislation_code',
770: 'C',
771: 10,

Line 775: pay_dyn_triggers.create_trg_initialisation(

771: 10,
772: NULL
773: );
774: --
775: pay_dyn_triggers.create_trg_initialisation(
776: p_table_name||'_ARU',
777: '2',
778: 'pay_core_utils.get_legislation_code',
779: 'F',

Line 783: pay_dyn_triggers.create_trg_parameter(

779: 'F',
780: NULL
781: );
782: --
783: pay_dyn_triggers.create_trg_parameter(
784: p_table_name||'_ARU',
785: 2,
786: NULL,
787: NULL,

Line 798: pay_dyn_triggers.create_trg_parameter(

794: 'N',
795: NULL
796: );
797: --
798: pay_dyn_triggers.create_trg_parameter(
799: p_table_name||'_ARU',
800: 2,
801: NULL,
802: NULL,

Line 813: pay_dyn_triggers.create_trg_components(

809: 'N',
810: NULL
811: );
812: --
813: pay_dyn_triggers.create_trg_components(
814: p_table_name||'_ARU',
815: NULL,
816: NULL,
817: NULL,

Line 823: pay_dyn_triggers.create_trg_parameter(

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

Line 838: pay_dyn_triggers.create_trg_parameter(

834: 'N',
835: NULL
836: );
837: --
838: pay_dyn_triggers.create_trg_parameter(
839: p_table_name||'_ARU',
840: NULL,
841: NULL,
842: NULL,

Line 853: pay_dyn_triggers.create_trg_parameter(

849: 'N',
850: NULL
851: );
852: --
853: pay_dyn_triggers.create_trg_parameter(
854: p_table_name||'_ARU',
855: NULL,
856: NULL,
857: NULL,

Line 869: pay_dyn_triggers.create_trg_parameter(

865: NULL
866: );
867: --
868: for colrec in get_columns(p_table_name) loop
869: pay_dyn_triggers.create_trg_parameter(
870: p_table_name||'_ARU',
871: NULL,
872: NULL,
873: NULL,

Line 884: pay_dyn_triggers.create_trg_parameter(

880: 'N',
881: NULL
882: );
883: --
884: pay_dyn_triggers.create_trg_parameter(
885: p_table_name||'_ARU',
886: NULL,
887: NULL,
888: NULL,

Line 1479: proc := ' pay_dyn_triggers.create_trigger_event(

1475: hr_utility.trace_on(null, p_table_name);
1476: --
1477: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1478: --
1479: proc := ' pay_dyn_triggers.create_trigger_event(
1480: '''||p_table_name||'_ARU'',
1481: '''||p_table_name||''',
1482: ''Description'',
1483: ''N'',

Line 1493: proc := ' pay_dyn_triggers.create_trg_declaration(

1489: ';
1490: --
1491: hr_utility.trace(proc);
1492: --
1493: proc := ' pay_dyn_triggers.create_trg_declaration(
1494: '''||p_table_name||'_ARU'',
1495: ''business_group_id'',
1496: ''N'',
1497: NULL,

Line 1504: proc := ' pay_dyn_triggers.create_trg_initialisation(

1500: --
1501: ';
1502: hr_utility.trace(proc);
1503: --
1504: proc := ' pay_dyn_triggers.create_trg_initialisation(
1505: '''||p_table_name||'_ARU'',
1506: ''1'',
1507: ''pay_core_utils.get_business_group'',
1508: ''F'',

Line 1516: proc := ' pay_dyn_triggers.create_trg_parameter(

1512: --
1513: ';
1514: hr_utility.trace(proc);
1515: --
1516: proc := ' pay_dyn_triggers.create_trg_parameter(
1517: '''||p_table_name||'_ARU'',
1518: 1,
1519: NULL,
1520: NULL,

Line 1534: proc := ' pay_dyn_triggers.create_trg_parameter(

1530: --
1531: ';
1532: hr_utility.trace(proc);
1533: --
1534: proc := ' pay_dyn_triggers.create_trg_parameter(
1535: '''||p_table_name||'_ARU'',
1536: 1,
1537: NULL,
1538: NULL,

Line 1552: proc := ' pay_dyn_triggers.create_trg_declaration(

1548: --
1549: ';
1550: hr_utility.trace(proc);
1551: --
1552: proc := ' pay_dyn_triggers.create_trg_declaration(
1553: '''||p_table_name||'_ARU'',
1554: ''legislation_code'',
1555: ''C'',
1556: 10,

Line 1563: proc := ' pay_dyn_triggers.create_trg_initialisation(

1559: --
1560: ';
1561: hr_utility.trace(proc);
1562: --
1563: proc := ' pay_dyn_triggers.create_trg_initialisation(
1564: '''||p_table_name||'_ARU'',
1565: ''2'',
1566: ''pay_core_utils.get_legislation_code'',
1567: ''F'',

Line 1575: proc := ' pay_dyn_triggers.create_trg_parameter(

1571: --
1572: ';
1573: hr_utility.trace(proc);
1574: --
1575: proc := ' pay_dyn_triggers.create_trg_parameter(
1576: '''||p_table_name||'_ARU'',
1577: 2,
1578: NULL,
1579: NULL,

Line 1593: proc := ' pay_dyn_triggers.create_trg_parameter(

1589: --
1590: ';
1591: hr_utility.trace(proc);
1592: --
1593: proc := ' pay_dyn_triggers.create_trg_parameter(
1594: '''||p_table_name||'_ARU'',
1595: 2,
1596: NULL,
1597: NULL,

Line 1611: proc := ' pay_dyn_triggers.create_trg_components(

1607: --
1608: ';
1609: hr_utility.trace(proc);
1610: --
1611: proc := ' pay_dyn_triggers.create_trg_components(
1612: '''||p_table_name||'_ARU'',
1613: NULL,
1614: NULL,
1615: NULL,

Line 1625: proc := ' pay_dyn_triggers.create_trg_parameter(

1621: --
1622: ';
1623: hr_utility.trace(proc);
1624: --
1625: proc := ' pay_dyn_triggers.create_trg_parameter(
1626: '''||p_table_name||'_ARU'',
1627: NULL,
1628: NULL,
1629: NULL,

Line 1643: proc := ' pay_dyn_triggers.create_trg_parameter(

1639: --
1640: ';
1641: hr_utility.trace(proc);
1642: --
1643: proc := ' pay_dyn_triggers.create_trg_parameter(
1644: '''||p_table_name||'_ARU'',
1645: NULL,
1646: NULL,
1647: NULL,

Line 1661: proc := ' pay_dyn_triggers.create_trg_parameter(

1657: --
1658: ';
1659: hr_utility.trace(proc);
1660: --
1661: proc := ' pay_dyn_triggers.create_trg_parameter(
1662: '''||p_table_name||'_ARU'',
1663: NULL,
1664: NULL,
1665: NULL,

Line 1680: proc := ' pay_dyn_triggers.create_trg_parameter(

1676: ';
1677: hr_utility.trace(proc);
1678: --
1679: for colrec in get_columns(p_table_name) loop
1680: proc := ' pay_dyn_triggers.create_trg_parameter(
1681: '''||p_table_name||'_ARU'',
1682: NULL,
1683: NULL,
1684: NULL,

Line 1698: proc := ' pay_dyn_triggers.create_trg_parameter(

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

Line 1845: pay_dyn_triggers.create_trg_parameter (

1841:
1842:
1843: -- Create rows in trigger_parameters
1844: --
1845: pay_dyn_triggers.create_trg_parameter (
1846: p_short_name => p_table_name,
1847: p_process_order => null,
1848: p_legislative_code => null,
1849: p_business_group => null,