1 PACKAGE csfw_tasks_pub AUTHID CURRENT_USER AS
2 /*$Header: csfwtasks.pls 120.3 2010/10/12 09:59:41 shadas ship $*/
3
4 PROCEDURE GET_FOLLOW_UP_TASK_DETAILS
5 ( p_task_id IN NUMBER
6 , x_error_id OUT NOCOPY NUMBER
7 , x_error OUT NOCOPY VARCHAR2
8 , x_task_name OUT NOCOPY varchar2
9 , x_status_id OUT NOCOPY number
10 , x_priority_id OUT NOCOPY number
11 , x_customer_name OUT NOCOPY varchar2
12 , x_request_number OUT NOCOPY varchar2
13 , x_planned_effort_uom OUT NOCOPY varchar2
14 ) ;
15
16 PROCEDURE CREATE_FOLLOW_UP_TASK
17 ( p_task_id IN NUMBER
18 , p_task_name IN VARCHAR2
19 , p_task_type_id IN NUMBER
20 , p_status_id IN NUMBER
21 , p_priority_id IN NUMBER
22 , p_Planned_Start_date IN DATE
23 , p_Planned_End_date IN DATE
24 , p_planned_effort IN NUMBER
25 , p_planned_effort_uom IN VARCHAR2
26 , p_notes IN VARCHAR2
27 , x_error_id OUT NOCOPY NUMBER
28 , x_error OUT NOCOPY VARCHAR2
29 , x_follow_up_task_id OUT NOCOPY NUMBER
30 , p_note_type IN VARCHAR2
31 , p_note_status IN VARCHAR2
32 , p_attribute_1 IN VARCHAR2
33 , p_attribute_2 IN VARCHAR2
34 , p_attribute_3 IN VARCHAR2
35 , p_attribute_4 IN VARCHAR2
36 , p_attribute_5 IN VARCHAR2
37 , p_attribute_6 IN VARCHAR2
38 , p_attribute_7 IN VARCHAR2
39 , p_attribute_8 IN VARCHAR2
40 , p_attribute_9 IN VARCHAR2
41 , p_attribute_10 IN VARCHAR2
42 , p_attribute_11 IN VARCHAR2
43 , p_attribute_12 IN VARCHAR2
44 , p_attribute_13 IN VARCHAR2
45 , p_attribute_14 IN VARCHAR2
46 , p_attribute_15 IN VARCHAR2
47 , p_context IN VARCHAR2
48 ) ;
49
50
51 PROCEDURE CREATE_NEW_TASK
52 ( p_task_name IN VARCHAR2
53 , p_task_type_id IN NUMBER
54 , p_status_id IN NUMBER
55 , p_priority_id IN NUMBER
56 , p_assign_to_me IN VARCHAR2
57 , p_Planned_Start_date IN DATE
58 , p_planned_effort IN NUMBER
59 , p_planned_effort_uom IN VARCHAR2
60 , p_notes IN VARCHAR2
61 , p_source_object_id IN NUMBER
62 , x_error_id OUT NOCOPY NUMBER
63 , x_error OUT NOCOPY VARCHAR2
64 , x_new_task_id OUT NOCOPY NUMBER
65 , p_note_type IN VARCHAR2
66 , p_note_status IN VARCHAR2
67 , p_Planned_End_date IN DATE
68 , p_attribute_1 IN VARCHAR2
69 , p_attribute_2 IN VARCHAR2
70 , p_attribute_3 IN VARCHAR2
71 , p_attribute_4 IN VARCHAR2
72 , p_attribute_5 IN VARCHAR2
73 , p_attribute_6 IN VARCHAR2
74 , p_attribute_7 IN VARCHAR2
75 , p_attribute_8 IN VARCHAR2
76 , p_attribute_9 IN VARCHAR2
77 , p_attribute_10 IN VARCHAR2
78 , p_attribute_11 IN VARCHAR2
79 , p_attribute_12 IN VARCHAR2
80 , p_attribute_13 IN VARCHAR2
81 , p_attribute_14 IN VARCHAR2
82 , p_attribute_15 IN VARCHAR2
83 , p_context IN VARCHAR2
84 ) ;
85
86
87 PROCEDURE CREATE_NEW_SR
88 ( p_old_incident_id IN NUMBER
89 , p_incident_type_id IN NUMBER
90 , p_status_id IN NUMBER
91 , p_severity_id IN NUMBER
92 , p_summary IN VARCHAR2
93 , p_instance_id IN NUMBER
94 , p_inv_item_id IN NUMBER
95 , p_serial_number IN VARCHAR2
96 , p_notes IN VARCHAR2
97 , x_new_incident_id OUT NOCOPY NUMBER
98 , x_incident_number OUT NOCOPY VARCHAR2
99 , x_error_id OUT NOCOPY NUMBER
100 , x_error OUT NOCOPY VARCHAR2
101 , x_msg_count OUT NOCOPY NUMBER
102 , x_return_status OUT NOCOPY VARCHAR2
103 , p_contact_id IN NUMBER
104 , p_external_reference IN VARCHAR2
105 , p_prob_code IN VARCHAR2 -- Addition for inserting problem code
106 , p_cust_po_number IN varchar2 -- Bug 5059169
107 , p_attribute_1 IN VARCHAR2
108 , p_attribute_2 IN VARCHAR2
109 , p_attribute_3 IN VARCHAR2
110 , p_attribute_4 IN VARCHAR2
111 , p_attribute_5 IN VARCHAR2
112 , p_attribute_6 IN VARCHAR2
113 , p_attribute_7 IN VARCHAR2
114 , p_attribute_8 IN VARCHAR2
115 , p_attribute_9 IN VARCHAR2
116 , p_attribute_10 IN VARCHAR2
117 , p_attribute_11 IN VARCHAR2
118 , p_attribute_12 IN VARCHAR2
119 , p_attribute_13 IN VARCHAR2
120 , p_attribute_14 IN VARCHAR2
121 , p_attribute_15 IN VARCHAR2
122 , p_context IN VARCHAR2
123 );
124
125 FUNCTION GET_END_DATE (p_start_date date, p_uom_code varchar2, p_effort number)
126 RETURN date;
127 FUNCTION validate_install_site
128 (
129 p_install_site_id IN NUMBER ,
130 p_customer_id IN NUMBER
131 ) RETURN NUMBER;
132
133 /*
134 Wrapper on update_task for updating task fled field
135 */
136 PROCEDURE UPDATE_TASK_FLEX
137 (
138 p_task_id IN NUMBER
139 , p_attribute_1 IN VARCHAR2
140 , p_attribute_2 IN VARCHAR2
141 , p_attribute_3 IN VARCHAR2
142 , p_attribute_4 IN VARCHAR2
143 , p_attribute_5 IN VARCHAR2
144 , p_attribute_6 IN VARCHAR2
145 , p_attribute_7 IN VARCHAR2
146 , p_attribute_8 IN VARCHAR2
147 , p_attribute_9 IN VARCHAR2
148 , p_attribute_10 IN VARCHAR2
149 , p_attribute_11 IN VARCHAR2
150 , p_attribute_12 IN VARCHAR2
151 , p_attribute_13 IN VARCHAR2
152 , p_attribute_14 IN VARCHAR2
153 , p_attribute_15 IN VARCHAR2
154 , p_context IN VARCHAR2
155 , x_return_status OUT NOCOPY VARCHAR2
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_error OUT NOCOPY VARCHAR2
158 );
159
160 /*
161 Bug # 4922104
162 */
163
164 PROCEDURE UPDATE_SCH_DATE_TASK
165 ( p_task_id IN NUMBER
166 , p_scheduled_start_date IN DATE
167 , p_scheduled_end_date IN DATE
168 , p_planned_effort IN NUMBER
169 , p_planned_effort_uom IN VARCHAR
170 , p_allow_overlap IN VARCHAR
171 , x_return_status OUT NOCOPY VARCHAR2
172 , x_msg_count OUT NOCOPY NUMBER
173 , x_error OUT NOCOPY VARCHAR2
174 );
175
176 END csfw_tasks_pub;
177
178