eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PRORATION_WRAPPER dependencies on PAY_DATETRACKED_EVENTS

Line 400: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT

396: -- d) Enable the dynamic triggers and Functional Specifications.
397:
398: -- a) Step a
399:
400: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
401: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
402:
403: l_count := 0;
404:

Line 450: FROM pay_datetracked_events

446: l_count := 0;
447:
448: SELECT COUNT(*)
449: INTO l_count
450: FROM pay_datetracked_events
451: WHERE column_name = 'EFFECTIVE_START_DATE'
452: AND event_group_id = l_event_group_id
453: AND dated_table_id = l_dated_table_id ;
454:

Line 459: pay_datetracked_events_api.create_datetracked_event

455: hr_utility.trace('The count 20 is ' || TO_CHAR(l_count));
456:
457: IF (l_count = 0) THEN
458: hr_utility.trace('If condition ... Creating Date Tracked Events');
459: pay_datetracked_events_api.create_datetracked_event
460: (
461: p_validate => FALSE
462: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
463: ,p_event_group_id => l_event_group_id

Line 479: FROM pay_datetracked_events

475: l_count := 0;
476:
477: SELECT COUNT(*)
478: INTO l_count
479: FROM pay_datetracked_events
480: WHERE column_name = 'EFFECTIVE_END_DATE'
481: AND event_group_id = l_event_group_id
482: AND dated_table_id = l_dated_table_id ;
483:

Line 488: pay_datetracked_events_api.create_datetracked_event

484: hr_utility.trace('The count 25 is ' || TO_CHAR(l_count));
485:
486: IF (l_count = 0) THEN
487: hr_utility.trace('If condition ... Creating Date Tracked Events');
488: pay_datetracked_events_api.create_datetracked_event
489: (
490: p_validate => FALSE
491: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
492: ,p_event_group_id => l_event_group_id

Line 875: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT

871: -- d) Enable the dynamic triggers and Functional Specifications.
872:
873: -- a) Step a
874:
875: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
876: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
877:
878: l_count := 0;
879:

Line 921: FROM pay_datetracked_events

917: l_count := 0;
918:
919: SELECT COUNT(*)
920: INTO l_count
921: FROM pay_datetracked_events
922: WHERE column_name = 'VALUE'
923: AND event_group_id = l_event_group_id
924: AND dated_table_id = l_dated_table_id;
925:

Line 929: pay_datetracked_events_api.create_datetracked_event

925:
926: IF (l_count = 0) THEN
927: hr_utility.trace('If condition ... creating datetracked events');
928:
929: pay_datetracked_events_api.create_datetracked_event
930: (
931: p_validate => FALSE
932: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
933: ,p_event_group_id => l_event_group_id

Line 954: FROM pay_datetracked_events

950: l_count := 0;
951:
952: SELECT COUNT(*)
953: INTO l_count
954: FROM pay_datetracked_events
955: WHERE column_name = 'GRADE_ID'
956: AND event_group_id = l_event_group_id
957: AND dated_table_id = l_dated_table_id ;
958:

Line 962: pay_datetracked_events_api.create_datetracked_event

958:
959: IF (l_count = 0) THEN
960: hr_utility.trace('If condition ... creating datetracked events');
961:
962: pay_datetracked_events_api.create_datetracked_event
963: (
964: p_validate => FALSE
965: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
966: ,p_event_group_id => l_event_group_id

Line 1214: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT

1210:
1211: l_grade_flag := 'TRUE';
1212: -- a) Step a
1213:
1214: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
1215: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
1216:
1217: l_count := 0;
1218:

Line 1261: FROM pay_datetracked_events

1257: l_count := 0;
1258:
1259: SELECT COUNT(*)
1260: INTO l_count
1261: FROM pay_datetracked_events
1262: WHERE column_name = 'STEP_ID'
1263: AND event_group_id = l_event_group_id
1264: AND dated_table_id = l_dated_table_id ;
1265:

Line 1268: pay_datetracked_events_api.create_datetracked_event

1264: AND dated_table_id = l_dated_table_id ;
1265:
1266: IF (l_count = 0) THEN
1267: hr_utility.trace('If condition ...creating datetracked events');
1268: pay_datetracked_events_api.create_datetracked_event
1269: (
1270: p_validate => FALSE
1271: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
1272: ,p_event_group_id => l_event_group_id

Line 1291: FROM pay_datetracked_events

1287: END LOOP;
1288: l_count := 0;
1289: SELECT COUNT(*)
1290: INTO l_count
1291: FROM pay_datetracked_events
1292: WHERE column_name = 'VALUE'
1293: AND event_group_id = l_event_group_id
1294: AND dated_table_id = l_dated_table_id;
1295:

Line 1299: pay_datetracked_events_api.create_datetracked_event

1295:
1296: IF (l_count = 0) THEN
1297: hr_utility.trace('If condition ...creating datetracked events');
1298:
1299: pay_datetracked_events_api.create_datetracked_event
1300: (
1301: p_validate => FALSE
1302: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
1303: ,p_event_group_id => l_event_group_id

Line 1324: FROM pay_datetracked_events

1320: l_count := 0;
1321:
1322: SELECT COUNT(*)
1323: INTO l_count
1324: FROM pay_datetracked_events
1325: WHERE column_name = 'GRADE_ID'
1326: AND event_group_id = l_event_group_id
1327: AND dated_table_id = l_dated_table_id ;
1328:

Line 1332: pay_datetracked_events_api.create_datetracked_event

1328:
1329: IF (l_count = 0) THEN
1330: hr_utility.trace('If condition ...creating datetracked events');
1331:
1332: pay_datetracked_events_api.create_datetracked_event
1333: (
1334: p_validate => FALSE
1335: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
1336: ,p_event_group_id => l_event_group_id

Line 1642: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT

1638: l_pg_name := UPPER(SUBSTR(REPLACE(p_pgname, ' ',' '), 1, 40));
1639:
1640: -- a) Step a
1641:
1642: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
1643: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
1644:
1645: l_count := 0;
1646:

Line 1692: FROM pay_datetracked_events

1688: l_count := 0;
1689:
1690: SELECT COUNT(*)
1691: INTO l_count
1692: FROM pay_datetracked_events
1693: WHERE column_name = 'GRADE_ID'
1694: AND event_group_id = l_event_group_id
1695: AND dated_table_id = l_dated_table_id ;
1696:

Line 1700: pay_datetracked_events_api.create_datetracked_event

1696:
1697: IF (l_count = 0) THEN
1698: hr_utility.trace('If condition ... creating datetracked event');
1699:
1700: pay_datetracked_events_api.create_datetracked_event
1701: (
1702: p_validate => FALSE
1703: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1704: ,p_event_group_id => l_event_group_id

Line 1731: FROM pay_datetracked_events

1727: l_count := 0;
1728:
1729: SELECT COUNT(*)
1730: INTO l_count
1731: FROM pay_datetracked_events
1732: WHERE column_name = 'STEP_ID'
1733: AND event_group_id = l_event_group_id
1734: AND dated_table_id = l_dated_table_id ;
1735:

Line 1739: pay_datetracked_events_api.create_datetracked_event

1735:
1736: IF (l_count = 0) THEN
1737: hr_utility.trace('If condition ... creating datetracked event');
1738:
1739: pay_datetracked_events_api.create_datetracked_event
1740: (
1741: p_validate => FALSE
1742: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1743: ,p_event_group_id => l_event_group_id

Line 1771: FROM pay_datetracked_events

1767: l_count := 0;
1768:
1769: SELECT COUNT(*)
1770: INTO l_count
1771: FROM pay_datetracked_events
1772: WHERE column_name = 'VALUE'
1773: AND event_group_id = l_event_group_id
1774: AND dated_table_id = l_dated_table_id ;
1775:

Line 1779: pay_datetracked_events_api.create_datetracked_event

1775:
1776: IF (l_count = 0) THEN
1777: hr_utility.trace('If condition ... creating datetracked event');
1778:
1779: pay_datetracked_events_api.create_datetracked_event
1780: (
1781: p_validate => FALSE
1782: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1783: ,p_event_group_id => l_event_group_id

Line 1820: FROM pay_datetracked_events

1816: l_count := 0;
1817:
1818: SELECT COUNT(*)
1819: INTO l_count
1820: FROM pay_datetracked_events
1821: WHERE column_name = 'EFFECTIVE_START_DATE'
1822: AND event_group_id = l_event_group_id
1823: AND dated_table_id = l_dated_table_id ;
1824:

Line 1827: pay_datetracked_events_api.create_datetracked_event

1823: AND dated_table_id = l_dated_table_id ;
1824:
1825: IF (l_count = 0) THEN
1826: hr_utility.trace('If condition ... creating datetracked event');
1827: pay_datetracked_events_api.create_datetracked_event
1828: (
1829: p_validate => FALSE
1830: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1831: ,p_event_group_id => l_event_group_id

Line 1847: FROM pay_datetracked_events

1843: l_count := 0;
1844:
1845: SELECT COUNT(*)
1846: INTO l_count
1847: FROM pay_datetracked_events
1848: WHERE column_name = 'EFFECTIVE_END_DATE'
1849: AND event_group_id = l_event_group_id
1850: AND dated_table_id = l_dated_table_id;
1851:

Line 1854: pay_datetracked_events_api.create_datetracked_event

1850: AND dated_table_id = l_dated_table_id;
1851:
1852: IF (l_count = 0) THEN
1853: hr_utility.trace('If condition ... creating datetracked event');
1854: pay_datetracked_events_api.create_datetracked_event
1855: (
1856: p_validate => FALSE
1857: ,p_effective_date =>
1858: TO_DATE(p_pg_startdate,'dd/mm/yyyy')

Line 1885: FROM pay_datetracked_events

1881: l_count := 0;
1882:
1883: SELECT COUNT(*)
1884: INTO l_count
1885: FROM pay_datetracked_events
1886: WHERE column_name = 'LOCATION_ID'
1887: AND event_group_id = l_event_group_id
1888: AND dated_table_id = l_dated_table_id ;
1889:

Line 1893: pay_datetracked_events_api.create_datetracked_event

1889:
1890: IF (l_count = 0) THEN
1891: hr_utility.trace('If condition ... creating datetracked event');
1892:
1893: pay_datetracked_events_api.create_datetracked_event
1894: (
1895: p_validate => FALSE
1896: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1897: ,p_event_group_id => l_event_group_id