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_TAV_API_BUSINESS_RULES dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 1156: -- ota_training_plan_members exist.

1152: -- PUBLIC
1153: -- Description:
1154: -- Delete Validation.
1155: -- This activity version may not be deleted if child rows in
1156: -- ota_training_plan_members exist.
1157: --
1158: Procedure check_if_tpm_exists
1159: (
1160: p_activity_version_id in number

Line 1170: from OTA_TRAINING_PLAN_MEMBERS

1166: -- in training plan members
1167: --
1168: Cursor c_get_tpm_rows is
1169: Select 'Y'
1170: from OTA_TRAINING_PLAN_MEMBERS
1171: where activity_version_id = p_activity_version_id;
1172: --
1173: l_dyn_curs integer;
1174: l_dyn_rows integer;