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.OTA_FR_TRG_SUM dependencies on OTA_FR_TRG_SUM

Line 1: PACKAGE BODY OTA_FR_TRG_SUM AS

1: PACKAGE BODY OTA_FR_TRG_SUM AS
2: /* $Header: otfrtrgsm.pkb 120.0.12010000.2 2008/11/28 05:39:04 parusia noship $ */
3:
4: vCtr NUMBER;
5: g_utf8 boolean;

Line 138: --OTA_FR_TRG_SUM.vXMLTable.DELETE;

134: xml_t(p_xml,'');
135: l_date_from:=trunc(fnd_date.canonical_to_date(p_date_from));
136: l_date_to:=trunc(fnd_date.canonical_to_date(p_date_to));
137:
138: --OTA_FR_TRG_SUM.vXMLTable.DELETE;
139: --vCtr:=0;
140:
141: hr_utility.TRACE('l_date_to ' || to_char(l_date_to,'YYYY-MON-DD'));
142:

Line 329: OTA_FR_TRG_SUM.get_lookup_value('FR_CONTRACT_CATEGORY',pcf.ctr_information2) CONTRACT_CATEGORY,

325: ||' '||pa.telephone_number_1||' '|| pa.telephone_number_2||' '||pa.telephone_number_3 E_ADDRESS,
326: to_char(papf.original_date_of_hire,'YYYY-MM-DD') HIRE_DATE,
327: to_char(ppos.adjusted_svc_date,'YYYY-MM-DD') ADJUSTED_SVC_DATE,
328: to_char(ppos.actual_termination_date,'YYYY-MM-DD') TERM_DATE,
329: OTA_FR_TRG_SUM.get_lookup_value('FR_CONTRACT_CATEGORY',pcf.ctr_information2) CONTRACT_CATEGORY,
330: pcf.type CONTRACT_TYPE,
331: case
332: when pcf.ctr_information11 is null then
333: paaf.normal_hours

Line 339: OTA_FR_TRG_SUM.get_lookup_value('FREQUENCY',paaf.frequency)

335: fnd_number.canonical_to_number(pcf.ctr_information11)
336: end CONT_WRK_HRS,---CONTRACTUAL_WORKING_HOURS --It is the hours in the DDF segment with unit ,display unit also
337: case
338: when pcf.ctr_information11 is null then
339: OTA_FR_TRG_SUM.get_lookup_value('FREQUENCY',paaf.frequency)
340: else
341: OTA_FR_TRG_SUM.get_lookup_value('FR_FIXED_TIME_UNITS',pcf.ctr_information12)
342: end CONT_WRK_UNT, --Contractual working hours unit
343: pca.name COLLECTIVE_AGREEMENT,

Line 341: OTA_FR_TRG_SUM.get_lookup_value('FR_FIXED_TIME_UNITS',pcf.ctr_information12)

337: case
338: when pcf.ctr_information11 is null then
339: OTA_FR_TRG_SUM.get_lookup_value('FREQUENCY',paaf.frequency)
340: else
341: OTA_FR_TRG_SUM.get_lookup_value('FR_FIXED_TIME_UNITS',pcf.ctr_information12)
342: end CONT_WRK_UNT, --Contractual working hours unit
343: pca.name COLLECTIVE_AGREEMENT,
344: paaf.assignment_category ASSGN_CATEGORY,
345: to_char(L_P_DATE_FROM,'YYYY-MM-DD') PERIOD_FROM,

Line 414: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)

410: odb.failure_reason FAIL_REASON, --Failure Reason of Attendance
411: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',
412: case otpc.tp_cost_information3
413: when 'JOB_ADAPT' then
414: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
415: when 'JOB_EVOL' then
416: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
417: when 'COMP_DEV' then
418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)

Line 416: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)

412: case otpc.tp_cost_information3
413: when 'JOB_ADAPT' then
414: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
415: when 'JOB_EVOL' then
416: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
417: when 'COMP_DEV' then
418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
419: end) C_W_L_CAT,--Legal category
420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working

Line 418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)

414: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
415: when 'JOB_EVOL' then
416: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
417: when 'COMP_DEV' then
418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
419: end) C_W_L_CAT,--Legal category
420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working
421: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',nvl(otpc.amount,0),
422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours

Line 480: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_LEAVE_CATEGORY',paa.ABS_INFORMATION1) TRG_LEAV_CATG,-- Training Leave Category

476: to_char(paa.DATE_START,'YYYY-MM-DD') C_O_S_DAT, --Start Date
477: to_char(paa.DATE_END,'YYYY-MM-DD') C_O_E_DAT, --End date
478: fnd_number.canonical_to_number(nvl(paa.ABSENCE_DAYS,0)) DURATION_DAYS, --Duration days
479: fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0)) C_O_TOT_HR, --Duration hours
480: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_LEAVE_CATEGORY',paa.ABS_INFORMATION1) TRG_LEAV_CATG,-- Training Leave Category
481: paa.ABS_INFORMATION2 C_O_NAME, --Course
482: pv.VENDOR_NAME TRG_PROV,--Training Provider
483: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_TYPE',paa.ABS_INFORMATION4) TYPE_OF_TRG, --Type Of Training
484: paa.ABS_INFORMATION17 C_O_REF, --Training reference

Line 483: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_TYPE',paa.ABS_INFORMATION4) TYPE_OF_TRG, --Type Of Training

479: fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0)) C_O_TOT_HR, --Duration hours
480: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_LEAVE_CATEGORY',paa.ABS_INFORMATION1) TRG_LEAV_CATG,-- Training Leave Category
481: paa.ABS_INFORMATION2 C_O_NAME, --Course
482: pv.VENDOR_NAME TRG_PROV,--Training Provider
483: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_TYPE',paa.ABS_INFORMATION4) TYPE_OF_TRG, --Type Of Training
484: paa.ABS_INFORMATION17 C_O_REF, --Training reference
485: paa.ABS_INFORMATION18 WITH_TRG_PLAN, --Within Training Plan
486: case paa.ABS_INFORMATION19
487: when 'JOB_ADAPT' then

Line 488: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)

484: paa.ABS_INFORMATION17 C_O_REF, --Training reference
485: paa.ABS_INFORMATION18 WITH_TRG_PLAN, --Within Training Plan
486: case paa.ABS_INFORMATION19
487: when 'JOB_ADAPT' then
488: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
489: when 'JOB_EVOL' then
490: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
491: when 'COMP_DEV' then
492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)

Line 490: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)

486: case paa.ABS_INFORMATION19
487: when 'JOB_ADAPT' then
488: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
489: when 'JOB_EVOL' then
490: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
491: when 'COMP_DEV' then
492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
493: end C_O_L_CAT, ---Legal Category
494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours

Line 492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)

488: 'I-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
489: when 'JOB_EVOL' then
490: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
491: when 'COMP_DEV' then
492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
493: end C_O_L_CAT, ---Legal Category
494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours
495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type
496: hfov.name SUBSI_ORG --Subsidizing Organization

Line 495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type

491: when 'COMP_DEV' then
492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
493: end C_O_L_CAT, ---Legal Category
494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours
495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type
496: hfov.name SUBSI_ORG --Subsidizing Organization
497: from per_all_people_f papf,
498: per_absence_attendances paa,
499: per_absence_attendance_types paat,

Line 792: end OTA_FR_TRG_SUM;

788:
789: END make_employee;
790:
791:
792: end OTA_FR_TRG_SUM;
793:
794: