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_AME_ATTRIBUTES dependencies on OTA_LEARNING_PATHS_TL

Line 123: c_lp_name ota_learning_paths_tl.name%type;

119: function get_Learning_path_name
120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
121: return varchar2 is
122:
123: c_lp_name ota_learning_paths_tl.name%type;
124: c_event_id ota_events.event_id%type;
125: c_item_type varchar2(50);
126: c_item_key varchar2(100);
127:

Line 128: l_lp_name ota_learning_paths_tl.name%type;

124: c_event_id ota_events.event_id%type;
125: c_item_type varchar2(50);
126: c_item_key varchar2(100);
127:
128: l_lp_name ota_learning_paths_tl.name%type;
129:
130: /*cursor c_get_lp_name is
131: select olpt.name
132: from ota_events oev,ota_training_plans otp, ota_training_plan_members otpm,

Line 133: ota_learning_paths_tl olpt

129:
130: /*cursor c_get_lp_name is
131: select olpt.name
132: from ota_events oev,ota_training_plans otp, ota_training_plan_members otpm,
133: ota_learning_paths_tl olpt
134: where oev.activity_version_id = otpm.activity_version_id
135: and otpm.member_status_type_id='OTA_COMPLETED'
136: and otpm.training_plan_id=otp.training_plan_id
137: and otp.plan_status_type_id='OTA_COMPLETED'