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