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 1162: -- ota_training_plan_members exist.

1158: -- PUBLIC
1159: -- Description:
1160: -- Delete Validation.
1161: -- This activity version may not be deleted if child rows in
1162: -- ota_training_plan_members exist.
1163: --
1164: Procedure check_if_tpm_exists
1165: (
1166: p_activity_version_id in number

Line 1176: from OTA_TRAINING_PLAN_MEMBERS

1172: -- in training plan members
1173: --
1174: Cursor c_get_tpm_rows is
1175: Select 'Y'
1176: from OTA_TRAINING_PLAN_MEMBERS
1177: where activity_version_id = p_activity_version_id;
1178: --
1179: l_dyn_curs integer;
1180: l_dyn_rows integer;