APPS.JTF_EC_CUHK SQL Statements

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

Line: 53

PROCEDURE Update_Escalation_Pre(
		p_esc_id		IN OUT NOCOPY 	jtf_tasks_b.task_id%TYPE,
		p_esc_number		IN OUT NOCOPY	jtf_tasks_b.task_number%TYPE,
		p_object_version	IN OUT NOCOPY 	NUMBER,
		p_esc_record		IN OUT NOCOPY	jtf_ec_pub.Esc_Rec_Type,
		p_reference_documents	IN OUT NOCOPY	jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
		p_esc_contacts		IN OUT NOCOPY	jtf_ec_pub.Esc_Contacts_Tbl_Type,
		p_cont_points		IN OUT NOCOPY	jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
		p_notes			IN OUT NOCOPY	jtf_ec_pub.Notes_Tbl_Type,
		x_return_status       	OUT NOCOPY     VARCHAR2,
		x_msg_count           	OUT NOCOPY     NUMBER,
		x_msg_data            	OUT NOCOPY     VARCHAR2) Is

BEGIN
	null;

Line: 70

PROCEDURE Update_Escalation_Post(
		p_esc_id		IN  	jtf_tasks_b.task_id%TYPE,
		p_esc_number		IN 	jtf_tasks_b.task_number%TYPE,
		p_object_version	IN  	NUMBER,
		p_esc_record		IN 	jtf_ec_pub.Esc_Rec_Type,
		p_reference_documents	IN 	jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
		p_esc_contacts		IN 	jtf_ec_pub.Esc_Contacts_Tbl_Type,
		p_cont_points		IN 	jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
		p_notes			IN 	jtf_ec_pub.Notes_Tbl_Type,
		x_return_status       	OUT NOCOPY     VARCHAR2,
		x_msg_count           	OUT NOCOPY     NUMBER,
		x_msg_data            	OUT NOCOPY     VARCHAR2) Is

BEGIN
	null;

Line: 87

PROCEDURE Delete_Escalation_Pre(
		p_esc_id		IN OUT NOCOPY 	jtf_tasks_b.task_id%TYPE,
		p_esc_number		IN OUT NOCOPY	jtf_tasks_b.task_number%TYPE,
		p_object_version	IN OUT NOCOPY 	NUMBER,
		x_return_status       	OUT NOCOPY     VARCHAR2,
		x_msg_count           	OUT NOCOPY     NUMBER,
		x_msg_data            	OUT NOCOPY     VARCHAR2) Is

BEGIN
	null;

Line: 99

PROCEDURE Delete_Escalation_Post(
		p_esc_id		IN  	jtf_tasks_b.task_id%TYPE :=NULL,
		p_esc_number		IN 	jtf_tasks_b.task_number%TYPE :=NULL,
		p_object_version	IN  	NUMBER,
		x_return_status       	OUT NOCOPY     VARCHAR2,
		x_msg_count           	OUT NOCOPY     NUMBER,
		x_msg_data            	OUT NOCOPY     VARCHAR2) Is

BEGIN
	null;