APPS.JTF_IH_PUB_CUHK SQL Statements

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

Line: 88

	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: 98

	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: 128

	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: 138

	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: 210

	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: 220

	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: 270

	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: 280

	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: 342

	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: 355

	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;