[Home] [Help]
PACKAGE: APPS.JTF_TASK_INST_TEMPLATES_PUB
Source
1 PACKAGE jtf_task_inst_templates_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfpttms.pls 120.4 2006/07/24 13:31:35 sbarat ship $ */
3 /*#
4 * A public interface to create Tasks by using Task Template.
5 * Tasks can be standalone tasks or tasks associated with a specific
6 * business entity such as Opportunity, Service Request, Customer, etc.
7 *
8 * @rep:scope internal
9 * @rep:product CAC
10 * @rep:lifecycle active
11 * @rep:displayname Task From Template
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
14 */
15
16 TYPE task_details_rec IS RECORD (
17 task_id NUMBER,
18 task_template_id NUMBER
19 );
20
21 TYPE task_details_tbl IS TABLE OF task_details_rec
22 INDEX BY BINARY_INTEGER;
23
24 TYPE task_contact_points_rec IS RECORD (
25 task_template_id NUMBER,
26 phone_id NUMBER,
27 primary_key VARCHAR2(1)
28 );
29
30 TYPE task_contact_points_tbl IS TABLE OF task_contact_points_rec
31 INDEX BY BINARY_INTEGER;
32
33 TYPE task_template_group_info IS RECORD (
34 task_template_group_id NUMBER,
35 owner_type_code VARCHAR2(30),
36 owner_id NUMBER,
37 source_object_id NUMBER,
38 source_object_name VARCHAR2(80),
39 assigned_by_id NUMBER,
40 cust_account_id NUMBER,
41 customer_id NUMBER,
42 address_id NUMBER,
43 actual_start_date DATE,
44 actual_end_date DATE,
45 planned_start_date DATE,
46 planned_end_date DATE,
47 scheduled_start_date DATE,
48 scheduled_end_date DATE,
49 palm_flag VARCHAR2(1),
50 wince_flag VARCHAR2(1),
51 laptop_flag VARCHAR2(1),
52 device1_flag VARCHAR2(1),
53 device2_flag VARCHAR2(1),
54 device3_flag VARCHAR2(1),
55 parent_task_id NUMBER,
56 percentage_complete NUMBER,
57 timezone_id NUMBER,
58 actual_effort NUMBER,
59 actual_effort_uom VARCHAR2(3),
60 reason_code VARCHAR2(30),
61 bound_mode_code VARCHAR2(30),
62 soft_bound_flag VARCHAR2(1),
63 workflow_process_id NUMBER,
64 owner_territory_id NUMBER,
65 costs NUMBER,
66 currency_code VARCHAR2(150),
67 attribute1 VARCHAR2(150),
68 attribute2 VARCHAR2(150),
69 attribute3 VARCHAR2(150),
70 attribute4 VARCHAR2(150),
71 attribute5 VARCHAR2(150),
72 attribute6 VARCHAR2(150),
73 attribute7 VARCHAR2(150),
74 attribute8 VARCHAR2(150),
75 attribute9 VARCHAR2(150),
76 attribute10 VARCHAR2(150),
77 attribute11 VARCHAR2(150),
78 attribute12 VARCHAR2(150),
79 attribute13 VARCHAR2(150),
80 attribute14 VARCHAR2(150),
81 attribute15 VARCHAR2(150),
82 attribute_category VARCHAR2(30),
83 date_selected VARCHAR2(1),
84 show_on_calendar VARCHAR2(1),
85 location_id NUMBER
86 );
87
88 TYPE task_template_info IS RECORD (
89 task_template_id NUMBER,
90 task_name VARCHAR2(80),
91 description VARCHAR2(4000),
92 task_type_id NUMBER,
93 task_status_id NUMBER,
94 task_priority_id NUMBER,
95 owner_type_code VARCHAR2(30),
96 owner_id NUMBER,
97 planned_start_date DATE,
98 planned_end_date DATE,
99 scheduled_start_date DATE,
100 scheduled_end_date DATE,
101 actual_start_date DATE,
102 actual_end_date DATE,
103 p_date_selected VARCHAR2(1),
104 timezone_id NUMBER,
105 duration NUMBER,
106 duration_uom VARCHAR2(3),
107 planned_effort NUMBER,
108 planned_effort_uom VARCHAR2(3),
109 private_flag VARCHAR2(1),
110 restrict_closure_flag VARCHAR2(1),
111 palm_flag VARCHAR2(1),
112 wince_flag VARCHAR2(1),
113 laptop_flag VARCHAR2(1),
114 device1_flag VARCHAR2(1),
115 device2_flag VARCHAR2(1),
116 device3_flag VARCHAR2(1),
117 show_on_calendar VARCHAR2(1),
118 enable_workflow VARCHAR2(1),
119 attribute1 VARCHAR2(150),
120 attribute2 VARCHAR2(150),
121 attribute3 VARCHAR2(150),
122 attribute4 VARCHAR2(150),
123 attribute5 VARCHAR2(150),
124 attribute6 VARCHAR2(150),
125 attribute7 VARCHAR2(150),
126 attribute8 VARCHAR2(150),
127 attribute9 VARCHAR2(150),
128 attribute10 VARCHAR2(150),
129 attribute11 VARCHAR2(150),
130 attribute12 VARCHAR2(150),
131 attribute13 VARCHAR2(150),
132 attribute14 VARCHAR2(150),
133 attribute15 VARCHAR2(150),
134 attribute_category VARCHAR2(30),
135 task_confirmation_status VARCHAR2(1)
136 );
137
138 TYPE task_template_info_tbl IS TABLE OF task_template_info
139 INDEX BY BINARY_INTEGER;
140
141 /*#
142 * Creates a Task by using the Task Template.
143 *
144 * @param p_api_version The standard API version number.
145 * @param p_init_msg_list The standard API flag allows API callers to request
146 * that the API does the initialization of the message list on their behalf.
147 * By default, the message list will not be initialized.
148 * @param p_commit The standard API flag is used by API callers to ask
149 * the API to commit on their behalf after performing its function.
150 * By default, the commit will not be performed.
151 * @param x_return_status Returns the result of all the operations performed
152 * by the API and must have one of the following values:
153 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
154 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
155 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>.
156 * @param x_msg_count Returns the number of messages in the API message list.
157 * @param x_msg_data Returns the message in an encoded format if
158 * <code>x_msg_count</code> returns number one.
159 * @param x_task_details_tbl Returns the Task Ids of the tasks created.
160 * @param p_task_template_group_info Table of task template group records.
161 * @param p_task_templates_tbl Table of task template records.
162 * @param p_task_contact_points_tbl Table of task contact-point records.
163 *
164 * @rep:scope internal
165 * @rep:lifecycle active
166 * @rep:displayname Create Task From Template
167 * @rep:compatibility N
168 */
169 PROCEDURE create_task_from_template (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
172 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
173 p_task_template_group_info IN task_template_group_info,
174 p_task_templates_tbl IN task_template_info_tbl,
175 p_task_contact_points_tbl IN task_contact_points_tbl,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 x_task_details_tbl OUT NOCOPY task_details_tbl
180 );
181 END;