APPS.JTF_IH_PUB_VUHK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 87

	PROCEDURE update_interaction_pre (
		  p_interaction_rec	IN  JTF_IH_PUB.INTERACTION_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 97

	PROCEDURE update_interaction_post (
		  p_interaction_rec	IN  JTF_IH_PUB.INTERACTION_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 127

	PROCEDURE update_activity_pre (
		  p_activity_rec	IN  JTF_IH_PUB.ACTIVITY_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 137

	PROCEDURE update_activity_post (
		  p_activity_rec	IN  JTF_IH_PUB.ACTIVITY_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 209

	PROCEDURE update_mediaitem_pre (
		  p_media_rec		IN  JTF_IH_PUB.MEDIA_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 219

	PROCEDURE update_mediaitem_post (
		  p_media_rec	IN  JTF_IH_PUB.MEDIA_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 271

	PROCEDURE update_medialifecycle_pre (
		  p_media_lc_rec	IN  JTF_IH_PUB.MEDIA_LC_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 281

	PROCEDURE update_medialifecycle_post (
		  p_media_lc_rec	IN  JTF_IH_PUB.MEDIA_LC_REC_TYPE
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 343

	PROCEDURE update_actduration_pre (
		  p_activity_id		IN NUMBER
		, p_end_date_time	IN DATE
		, p_duration		IN NUMBER
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;

Line: 356

	PROCEDURE update_actduration_post (
		  p_activity_id		IN NUMBER
		, p_end_date_time	IN DATE
		, p_duration		IN NUMBER
		, x_data		OUT NOCOPY VARCHAR2
		, x_count		OUT NOCOPY NUMBER
		, x_return_code		OUT NOCOPY VARCHAR2
     ) IS
     BEGIN
       NULL;