1 PACKAGE JTF_EC_VUHK AUTHID CURRENT_USER as
2 /* $Header: jtfecvhs.pls 115.2 2002/11/28 05:53:44 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_VUHK
9 -- Type : Public.
10 -- Function : This is a Vertical Industry User Hooks API.
11 -- The Vertical Industry can add customization procedures here
12 -- for Pre and Post Processing.
13 -- Pre-reqs : None.
14 -- Parameters : Please look at the JTF_EC_PUB api for the parameters description
15 -- name direction type required?
16 -- ---- --------- ---- ---------
17 -- x_return_status OUT VARCHAR2 required
18 -- x_msg_count OUT NUMBER required
19 -- x_msg_data OUT VARCHAR2 required
20 --
21 -- Version : 1.0
22 -------------------------------------------------------------------------------------------
23 -- History
24 -------------------------------------------------------------------------------------------
25 -- 06-OCT-00 tivanov Created.
26 -- 27-NOV-02 siyappan Added NOCOPY hint for OUT/IN OUT parameters.
27 ---------------------------------------------------------------------------------
28 --
29 -- End of comments
30
31
32 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_EC_VUHK';
33
34 -------------------------------------------------------------------------------------------
35 -- Vertical Industry Procedure for pre processing Create Escalation
36 -------------------------------------------------------------------------------------------
37
38
39 PROCEDURE Create_Escalation_Pre(
40 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
41 p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
42 p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43 p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
44 p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45 p_notes IN OUT NOCOPY 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);
49
50 -------------------------------------------------------------------------------------------
51 -- Vertical Industry Procedure for post processing Create Escalation
52 -------------------------------------------------------------------------------------------
53
54
55 PROCEDURE Create_Escalation_Post(
56 p_esc_id IN jtf_tasks_b.task_id%TYPE,
57 p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
58 p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59 p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
60 p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61 p_notes IN 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);
65
66 -------------------------------------------------------------------------------------------
67 -- Vertical Industry Procedure for pre processing Update Escalation
68 -------------------------------------------------------------------------------------------
69
70
71 PROCEDURE Update_Escalation_Pre(
72 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
73 p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
74 p_object_version IN OUT NOCOPY NUMBER,
75 p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
76 p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77 p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
78 p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79 p_notes IN OUT NOCOPY 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);
83
84 -------------------------------------------------------------------------------------------
85 -- Vertical Industry Procedure for post processing Update Escalation
86 -------------------------------------------------------------------------------------------
87
88 PROCEDURE Update_Escalation_Post(
89 p_esc_id IN jtf_tasks_b.task_id%TYPE,
90 p_esc_number IN jtf_tasks_b.task_number%TYPE,
91 p_object_version IN NUMBER,
92 p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93 p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94 p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95 p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96 p_notes IN jtf_ec_pub.Notes_Tbl_Type,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2);
100
101
102 -------------------------------------------------------------------------------------------
103 -- Vertical Industry Procedure for pre processing Delete Escalation
104 -------------------------------------------------------------------------------------------
105
106
107 PROCEDURE Delete_Escalation_Pre(
108 p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
109 p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
110 p_object_version IN OUT NOCOPY NUMBER,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2);
114
115
116 -------------------------------------------------------------------------------------------
117 -- Vertical Industry Procedure for post processing Delete Escalation
118 -------------------------------------------------------------------------------------------
119
120 PROCEDURE Delete_Escalation_Post(
121 p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
122 p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
123 p_object_version IN NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2);
127
128
129 END JTF_EC_VUHK;