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 2008/04/21 13:36:57 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 1399: ltt_segment hr_mee_views_gen.segmentsTable;

1395: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1396: ln_flex_num NUMBER;
1397: lv_flex_code VARCHAR2(3) := 'JOB';
1398: lv_result VARCHAR2(240) DEFAULT NULL;
1399: ltt_segment hr_mee_views_gen.segmentsTable;
1400: ln_business_group_id per_people_f.business_group_id%TYPE;
1401:
1402: BEGIN
1403:

Line 1460: hr_mee_views_gen.get_segment_value(

1456: RETURN ltt_segment(0).value;--job_name
1457: END IF;
1458: CLOSE lc_get_job_flex_id;
1459:
1460: hr_mee_views_gen.get_segment_value(
1461: p_flex_code => lv_flex_code
1462: ,p_flex_num => ln_flex_num
1463: ,p_segment_name1 => lv_segment_name1
1464: ,p_segment_name2 => lv_segment_name2

Line 1549: ltt_segment hr_mee_views_gen.segmentsTable;

1545: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1546: ln_flex_num NUMBER;
1547: lv_flex_code VARCHAR2(3) := 'GRD';
1548: lv_result VARCHAR2(240) DEFAULT NULL;
1549: ltt_segment hr_mee_views_gen.segmentsTable;
1550: ln_business_group_id per_people_f.business_group_id%TYPE;
1551:
1552: BEGIN
1553:

Line 1610: hr_mee_views_gen.get_segment_value(

1606: RETURN ltt_segment(0).value;--grade_name
1607: END IF;
1608: CLOSE lc_get_grade_flex_id;
1609:
1610: hr_mee_views_gen.get_segment_value(
1611: p_flex_code => lv_flex_code
1612: ,p_flex_num => ln_flex_num
1613: ,p_segment_name1 => lv_segment_name1
1614: ,p_segment_name2 => lv_segment_name2

Line 1705: ltt_segment hr_mee_views_gen.segmentsTable;

1701: lv_segment_name2 VARCHAR2(30) DEFAULT NULL;
1702: ln_flex_num NUMBER;
1703: lv_flex_code VARCHAR2(3) := 'POS';
1704: lv_result VARCHAR2(240) DEFAULT NULL;
1705: ltt_segment hr_mee_views_gen.segmentsTable;
1706: ln_business_group_id per_people_f.business_group_id%TYPE;
1707:
1708: BEGIN
1709:

Line 1766: hr_mee_views_gen.get_segment_value(

1762: RETURN ltt_segment(0).value;--position_name
1763: END IF;
1764: CLOSE lc_get_position_flex_id;
1765:
1766: hr_mee_views_gen.get_segment_value(
1767: p_flex_code => lv_flex_code
1768: ,p_flex_num => ln_flex_num
1769: ,p_segment_name1 => lv_segment_name1
1770: ,p_segment_name2 => lv_segment_name2

Line 1800: ,p_segment hr_mee_views_gen.segmentsTable

1796: PROCEDURE get_segment_value( p_flex_code IN VARCHAR2
1797: ,p_flex_num IN VARCHAR2
1798: ,p_segment_name1 IN VARCHAR2 DEFAULT NULL
1799: ,p_segment_name2 IN VARCHAR2 DEFAULT NULL
1800: ,p_segment hr_mee_views_gen.segmentsTable
1801: ,p_result OUT nocopy VARCHAR2)
1802: IS
1803:
1804: CURSOR lc_get_segment(p_application_id IN NUMBER,

Line 2152: END hr_mee_views_gen ;

2148: CLOSE l_cursor;
2149: return null;
2150: END getTrngEndDate;
2151: -- Bug 4513393 Ends
2152: END hr_mee_views_gen ;