1 PACKAGE BODY JTF_EC_CUHK as
2 /* $Header: jtfecchb.pls 115.2 2002/11/28 05:55:40 siyappan ship $ */
3 --/**==================================================================*
4 --| Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
5 --| All rights reserved. |
6 --+====================================================================+
7 -- Start of comments
8 -- API name : JTF_EC_CUHK
9 -- Type : Public.
10 -- Function : This is a Customer User Hooks API.The Customers can add -- customization procedures here for Pre and Post Processing.
11 --
12 -- Version : 1.0
13 -------------------------------------------------------------------------------------------
14 -- History
15 -------------------------------------------------------------------------------------------
16 -- 06-OCT-00 tivanov Created.
17 -- 27-NOV-02 siyappan Added NOCOPY hint for OUT/IN OUT parameters.
18 ---------------------------------------------------------------------------------
19 --
20 -- End of comments
21
22 PROCEDURE Create_Escalation_Pre(
23 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
24 p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25 p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26 p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27 p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28 p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2) Is
32
33 BEGIN
34 null;
35 END;
36
37
38 PROCEDURE Create_Escalation_Post(
39 p_esc_id IN jtf_tasks_b.task_id%TYPE,
40 p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41 p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42 p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43 p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44 p_notes IN jtf_ec_pub.Notes_Tbl_Type,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2) Is
48
49 BEGIN
50 null;
51 END;
52
53 PROCEDURE Update_Escalation_Pre(
54 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
55 p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
56 p_object_version IN OUT NOCOPY NUMBER,
57 p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58 p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59 p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60 p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61 p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2) Is
65
66 BEGIN
67 null;
68 END;
69
70 PROCEDURE Update_Escalation_Post(
71 p_esc_id IN jtf_tasks_b.task_id%TYPE,
72 p_esc_number IN jtf_tasks_b.task_number%TYPE,
73 p_object_version IN NUMBER,
74 p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75 p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76 p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77 p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78 p_notes IN jtf_ec_pub.Notes_Tbl_Type,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2) Is
82
83 BEGIN
84 null;
85 END;
86
87 PROCEDURE Delete_Escalation_Pre(
88 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
89 p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
90 p_object_version IN OUT NOCOPY NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2) Is
94
95 BEGIN
96 null;
97 END;
98
99 PROCEDURE Delete_Escalation_Post(
100 p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
101 p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
102 p_object_version IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2) Is
106
107 BEGIN
108 null;
109 END;
110
111
112 END JTF_EC_CUHK;