APPS.HR_MEE_VIEWS_GEN dependencies on HR_MEE_VIEWS_GEN

Line 1: package body hr_mee_views_gen AS

1: package body hr_mee_views_gen AS
2: /* $Header: hrmegviw.pkb 120.16.12010000.3 2009/07/17 08:30:45 gpurohit ship $ */
3:
4: TYPE cur_typ IS REF CURSOR;
5:

Line 130: 'sum(hr_mee_views_gen.convertDuration(evt.duration_units, ''H'',evt.duration)) '||

126: ,p_eff_date IN DATE) IS
127: query_str VARCHAR2(4000);
128: BEGIN
129: query_str := 'SELECT '||
130: 'sum(hr_mee_views_gen.convertDuration(evt.duration_units, ''H'',evt.duration)) '||
131: 'FROM ota_booking_status_types bst, '||
132: ' ota_events evt, ota_delegate_bookings db '||
133: 'WHERE db.booking_status_type_id = bst.booking_status_type_id '||
134: 'AND db.event_id = evt.event_id '||

Line 157: query_str := 'SELECT SUM(hr_mee_views_gen.amtInLoginPrsnCurrency(evt.currency_code, fl.money_amount, evt.course_start_date)) '||

153: ,p_person_id IN NUMBER
154: ,p_eff_date IN DATE) IS
155: query_str VARCHAR2(4000);
156: BEGIN
157: query_str := 'SELECT SUM(hr_mee_views_gen.amtInLoginPrsnCurrency(evt.currency_code, fl.money_amount, evt.course_start_date)) '||
158: 'FROM ota_delegate_bookings db, '||
159: ' ota_events evt, ota_finance_lines fl '||
160: 'WHERE db.booking_id = fl.booking_id(+) '||
161: 'AND nvl(fl.cancelled_flag(+),''N'') = ''N'' '||

Line 1442: ltt_segment hr_mee_views_gen.segmentsTable;

1438: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1439: ln_flex_num NUMBER;
1440: lv_flex_code VARCHAR2(3) := 'JOB';
1441: lv_result VARCHAR2(240) DEFAULT NULL;
1442: ltt_segment hr_mee_views_gen.segmentsTable;
1443: ln_business_group_id per_people_f.business_group_id%TYPE;
1444:
1445: BEGIN
1446:

Line 1503: hr_mee_views_gen.get_segment_value(

1499: RETURN ltt_segment(0).value;--job_name
1500: END IF;
1501: CLOSE lc_get_job_flex_id;
1502:
1503: hr_mee_views_gen.get_segment_value(
1504: p_flex_code => lv_flex_code
1505: ,p_flex_num => ln_flex_num
1506: ,p_segment_name1 => lv_segment_name1
1507: ,p_segment_name2 => lv_segment_name2

Line 1592: ltt_segment hr_mee_views_gen.segmentsTable;

1588: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1589: ln_flex_num NUMBER;
1590: lv_flex_code VARCHAR2(3) := 'GRD';
1591: lv_result VARCHAR2(240) DEFAULT NULL;
1592: ltt_segment hr_mee_views_gen.segmentsTable;
1593: ln_business_group_id per_people_f.business_group_id%TYPE;
1594:
1595: BEGIN
1596:

Line 1653: hr_mee_views_gen.get_segment_value(

1649: RETURN ltt_segment(0).value;--grade_name
1650: END IF;
1651: CLOSE lc_get_grade_flex_id;
1652:
1653: hr_mee_views_gen.get_segment_value(
1654: p_flex_code => lv_flex_code
1655: ,p_flex_num => ln_flex_num
1656: ,p_segment_name1 => lv_segment_name1
1657: ,p_segment_name2 => lv_segment_name2

Line 1748: ltt_segment hr_mee_views_gen.segmentsTable;

1744: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1745: ln_flex_num NUMBER;
1746: lv_flex_code VARCHAR2(3) := 'POS';
1747: lv_result VARCHAR2(240) DEFAULT NULL;
1748: ltt_segment hr_mee_views_gen.segmentsTable;
1749: ln_business_group_id per_people_f.business_group_id%TYPE;
1750:
1751: BEGIN
1752:

Line 1809: hr_mee_views_gen.get_segment_value(

1805: RETURN ltt_segment(0).value;--position_name
1806: END IF;
1807: CLOSE lc_get_position_flex_id;
1808:
1809: hr_mee_views_gen.get_segment_value(
1810: p_flex_code => lv_flex_code
1811: ,p_flex_num => ln_flex_num
1812: ,p_segment_name1 => lv_segment_name1
1813: ,p_segment_name2 => lv_segment_name2

Line 1843: ,p_segment hr_mee_views_gen.segmentsTable

1839: PROCEDURE get_segment_value( p_flex_code IN VARCHAR2
1840: ,p_flex_num IN VARCHAR2
1841: ,p_segment_name1 IN VARCHAR2 DEFAULT NULL
1842: ,p_segment_name2 IN VARCHAR2 DEFAULT NULL
1843: ,p_segment hr_mee_views_gen.segmentsTable
1844: ,p_result OUT nocopy VARCHAR2)
1845: IS
1846:
1847: CURSOR lc_get_segment(p_application_id IN NUMBER,

Line 2195: END hr_mee_views_gen ;

2191: CLOSE l_cursor;
2192: return null;
2193: END getTrngEndDate;
2194: -- Bug 4513393 Ends
2195: END hr_mee_views_gen ;