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_TRAINING_RECORD dependencies on HR_GENERAL

Line 857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

853: a.tav_information18,
854: a.tav_information19,
855: a.tav_information20,
856: a.Version_Code Activity_Version_Code,
857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
858: a.professional_credits,
859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
860: a.Controlling_Person_Id Controlling_Person_Id,
861: ST.NAME status,

Line 859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

855: a.tav_information20,
856: a.Version_Code Activity_Version_Code,
857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
858: a.professional_credits,
859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
860: a.Controlling_Person_Id Controlling_Person_Id,
861: ST.NAME status,
862: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
863: ,D.BOOKING_ID

Line 1032: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1028: a.tav_information18,
1029: a.tav_information19,
1030: a.tav_information20,
1031: a.Version_Code Activity_Version_Code,
1032: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1033: a.professional_credits,
1034: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1035: a.Controlling_Person_Id Controlling_Person_Id,
1036: ST.NAME status,

Line 1034: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1030: a.tav_information20,
1031: a.Version_Code Activity_Version_Code,
1032: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1033: a.professional_credits,
1034: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1035: a.Controlling_Person_Id Controlling_Person_Id,
1036: ST.NAME status,
1037: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
1038: ,D.BOOKING_ID

Line 1178: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1174: a.tav_information18,
1175: a.tav_information19,
1176: a.tav_information20,
1177: a.Version_Code Activity_Version_Code,
1178: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1179: a.professional_credits,
1180: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1181: a.Controlling_Person_Id Controlling_Person_Id
1182: FROM ota_activity_versions_vl a

Line 1180: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1176: a.tav_information20,
1177: a.Version_Code Activity_Version_Code,
1178: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1179: a.professional_credits,
1180: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1181: a.Controlling_Person_Id Controlling_Person_Id
1182: FROM ota_activity_versions_vl a
1183: WHERE a.activity_version_id = p_course_id;
1184: l_activity_rec activity_rectype;

Line 1270: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1266: a.tav_information18,
1267: a.tav_information19,
1268: a.tav_information20,
1269: a.Version_Code Activity_Version_Code,
1270: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1271: a.professional_credits,
1272: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1273: a.Controlling_Person_Id Controlling_Person_Id,
1274: ST.NAME status,

Line 1272: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1268: a.tav_information20,
1269: a.Version_Code Activity_Version_Code,
1270: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1271: a.professional_credits,
1272: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1273: a.Controlling_Person_Id Controlling_Person_Id,
1274: ST.NAME status,
1275: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
1276: ,D.BOOKING_ID