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.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CAL_EVENT_VARRAY

Line 1038: ,x_cal_event_varray IN OUT NOCOPY per_cal_event_varray

1034: ,p_event_type IN VARCHAR2 DEFAULT NULL
1035: ,p_start_date IN DATE DEFAULT NULL
1036: ,p_end_date IN DATE DEFAULT NULL
1037: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1038: ,x_cal_event_varray IN OUT NOCOPY per_cal_event_varray
1039: ) IS
1040:
1041: -- Cursor to fetch person assignment
1042: CURSOR c_per_asg ( cp_person_id NUMBER

Line 1186: x_cal_event_varray := per_cal_event_varray(); -- initialize empty

1182: l_proc := 'hr_cal_event_mapping_pkg.get_per_asg_cal_events';
1183: hr_utility.set_location('Entering: '|| l_proc, 10);
1184:
1185: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1186: x_cal_event_varray := per_cal_event_varray(); -- initialize empty
1187: l_event_type_flag := NVL(p_event_type_flag, 'B');
1188: l_geo_node := NULL;
1189:
1190: -- Range validate supplied start and end dates

Line 1526: ) RETURN per_cal_event_varray IS

1522: ,p_event_type IN VARCHAR2 DEFAULT NULL
1523: ,p_start_date IN DATE DEFAULT NULL
1524: ,p_end_date IN DATE DEFAULT NULL
1525: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1526: ) RETURN per_cal_event_varray IS
1527:
1528: l_proc VARCHAR2(60);
1529: l_cal_event_varray per_cal_event_varray;
1530:

Line 1529: l_cal_event_varray per_cal_event_varray;

1525: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1526: ) RETURN per_cal_event_varray IS
1527:
1528: l_proc VARCHAR2(60);
1529: l_cal_event_varray per_cal_event_varray;
1530:
1531: BEGIN
1532:
1533: l_proc := 'hr_cal_event_mapping_pkg.get_cal_events (PerVer)';

Line 1571: ) RETURN per_cal_event_varray IS

1567: ,p_event_type IN VARCHAR2 DEFAULT NULL
1568: ,p_start_date IN DATE DEFAULT NULL
1569: ,p_end_date IN DATE DEFAULT NULL
1570: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1571: ) RETURN per_cal_event_varray IS
1572:
1573: l_proc VARCHAR2(60);
1574: l_cal_event_varray per_cal_event_varray;
1575: l_person_id NUMBER;

Line 1574: l_cal_event_varray per_cal_event_varray;

1570: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1571: ) RETURN per_cal_event_varray IS
1572:
1573: l_proc VARCHAR2(60);
1574: l_cal_event_varray per_cal_event_varray;
1575: l_person_id NUMBER;
1576:
1577: -- Cursor to get the person id for an assignment id.
1578: CURSOR c_per_id (cp_assignment_id NUMBER) IS

Line 1631: ) RETURN per_cal_event_varray IS

1627: ,p_event_type IN VARCHAR2 DEFAULT NULL
1628: ,p_start_date IN DATE DEFAULT NULL
1629: ,p_end_date IN DATE DEFAULT NULL
1630: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1631: ) RETURN per_cal_event_varray IS
1632:
1633: l_proc VARCHAR2(60);
1634: l_cal_event_varray per_cal_event_varray;
1635: l_person_id NUMBER;

Line 1634: l_cal_event_varray per_cal_event_varray;

1630: ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
1631: ) RETURN per_cal_event_varray IS
1632:
1633: l_proc VARCHAR2(60);
1634: l_cal_event_varray per_cal_event_varray;
1635: l_person_id NUMBER;
1636:
1637: -- Cursor to get the party id for a person id.
1638: CURSOR c_per_id (cp_party_id NUMBER) IS

Line 1691: ) RETURN per_cal_event_varray IS

1687: --
1688: FUNCTION get_all_cal_events (p_event_type IN VARCHAR2 DEFAULT NULL
1689: ,p_start_date IN DATE DEFAULT NULL
1690: ,p_end_date IN DATE DEFAULT NULL
1691: ) RETURN per_cal_event_varray IS
1692:
1693: l_proc VARCHAR2(60);
1694: l_cal_event_varray per_cal_event_varray;
1695: l_cal_event_obj per_cal_event_obj;

Line 1694: l_cal_event_varray per_cal_event_varray;

1690: ,p_end_date IN DATE DEFAULT NULL
1691: ) RETURN per_cal_event_varray IS
1692:
1693: l_proc VARCHAR2(60);
1694: l_cal_event_varray per_cal_event_varray;
1695: l_cal_event_obj per_cal_event_obj;
1696: l_null_times BOOLEAN;
1697: l_not_null_times BOOLEAN;
1698: l_bg_id NUMBER;

Line 1734: l_cal_event_varray := per_cal_event_varray(); -- initialize empty

1730:
1731: l_proc := 'hr_cal_event_mapping_pkg.get_all_cal_events';
1732: hr_utility.set_location('Entering: '|| l_proc, 10);
1733: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1734: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1735: l_bg_id := FND_PROFILE.Value('PER_BUSINESS_GROUP_ID');
1736: l_start_date := TRUNC(p_start_date);
1737: l_end_date := TRUNC(p_end_date);
1738:

Line 1860: l_cal_event_varray per_cal_event_varray;

1856: ,p_end_date IN DATE DEFAULT NULL
1857: ) IS
1858:
1859: l_proc VARCHAR2(60);
1860: l_cal_event_varray per_cal_event_varray;
1861: l_cal_event_obj per_cal_event_obj;
1862:
1863: BEGIN
1864:

Line 1868: l_cal_event_varray := per_cal_event_varray(); -- initialize empty

1864:
1865: l_proc := 'hr_cal_event_mapping_pkg.build_cal_map_cache';
1866: hr_utility.set_location('Entering: '|| l_proc, 10);
1867: l_cal_event_obj := per_cal_event_obj(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1868: l_cal_event_varray := per_cal_event_varray(); -- initialize empty
1869:
1870: l_cal_event_varray := get_cal_events ( p_assignment_id => p_assignment_id
1871: , p_event_type => p_event_type
1872: , p_start_date => p_start_date