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