233: PROCEDURE validate_activity
234: (
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_activity IN CST_ACTIVITIES.activity%TYPE,
238: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
239: );
240:
241: -- Procedure to validate Skill Type
234: (
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_activity IN CST_ACTIVITIES.activity%TYPE,
238: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
239: );
240:
241: -- Procedure to validate Skill Type
242: PROCEDURE validate_skill_type