1 PACKAGE IEX_API_RECORDS_PVT AUTHID CURRENT_USER as
2 /* $Header: iexutirs.pls 120.1 2005/12/21 21:16:28 jypark noship $ */
3
4 TYPE QUERY_PARAMETER_REC_TYPE IS RECORD
5 (
6 QUERY_PARAM_ID NUMBER := 9.99E125,
7 QUERY_ID NUMBER := 9.99E125,
8 PARAMETER_NAME VARCHAR2(60) := chr(0),
9 PARAMETER_TYPE VARCHAR2(30) := chr(0),
10 PARAMETER_VALUE VARCHAR2(300) := chr(0),
11 PARAMETER_CONDITION VARCHAR2(10) := chr(0),
12 PARAMETER_SEQUENCE NUMBER := 9.99E125
13 );
14
15 TYPE QUERY_PARAMETER_TBL_TYPE IS TABLE OF QUERY_PARAMETER_REC_TYPE
16 INDEX BY BINARY_INTEGER;
17
18 TYPE task_rsrc_req_rec IS RECORD (
19 RESOURCE_TYPE_CODE jtf_task_rsc_reqs.RESOURCE_TYPE_CODE%type ,
20 REQUIRED_UNITS jtf_task_rsc_reqs.required_units%type ,
21 ENABLED_FLAG jtf_task_rsc_reqs.enabled_flag%type := 'N'
22 );
23
24 TYPE task_rsrc_req_tbl IS TABLE OF task_rsrc_req_rec
25 INDEX BY BINARY_INTEGER;
26
27 g_miss_task_rsrc_req_tbl task_rsrc_req_tbl;
28
29
30 FUNCTION INIT_CASE_CONTACT_REC_TYPE RETURN IEX_CASE_CONTACTS_PVT.case_contact_Rec_Type ;
31 FUNCTION INIT_BANKRUPTCY_REC_TYPE RETURN IEX_BANKRUPTCIES_PVT.BANKRUPTCY_REC_TYPE ;
32 FUNCTION INIT_WRITEOFFS_REC_TYPE RETURN IEX_WRITEOFFS_PVT.WRITEOFFS_REC_TYPE ;
33 FUNCTION INIT_RPS_REC_TYPE RETURN IEX_REPOSSESSION_PVT.RPS_REC_TYPE ;
34 FUNCTION INIT_LTG_REC_TYPE RETURN IEX_LITIGATION_PVT.LTG_REC_TYPE ;
35 FUNCTION INIT_CASE_DEFINITION_REC_TYPE RETURN IEX_CASE_DEFINITIONS_PVT.CASE_DEFINITION_REC_TYPE ;
36 FUNCTION INIT_CASE_OBJECT_REC_TYPE RETURN IEX_CASE_OBJECTS_PVT.CASE_OBJECT_REC_TYPE ;
37 FUNCTION INIT_CAS_REC_TYPE RETURN IEX_CASES_PVT.CAS_REC_TYPE ;
38 FUNCTION INIT_stry_work_rec
39 RETURN IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
40 FUNCTION INIT_stry_rec
41 RETURN IEX_strategy_PVT.strategy_Rec_Type;
42
43 FUNCTION INIT_DEL_REC_TYPE RETURN IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE ;
44
45 --Begin fix bug #4867510-jypark-12/21/2005-fix for Developer 10g Upgrade
46
47 PROCEDURE Save_Perz_Query
48 ( p_api_version_number IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := 'F',
50 p_commit IN VARCHAR2 := 'F',
51 p_application_id IN NUMBER,
52 p_profile_id IN NUMBER,
53 p_profile_name IN VARCHAR2,
54 p_profile_type IN VARCHAR2,
55 p_query_id IN NUMBER,
56 p_query_name IN VARCHAR2,
57 p_query_type IN VARCHAR2,
58 p_query_desc IN VARCHAR2,
59 p_query_data_source IN VARCHAR2,
60
61 p_query_param_tbl IN IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
62 p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
63 p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
64 x_query_id OUT NOCOPY NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68
69 );
70
71 PROCEDURE Get_Perz_Query
72 ( p_api_version_number IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
74
75 p_application_id IN NUMBER,
76 p_profile_id IN NUMBER,
77 p_profile_name IN VARCHAR2,
78
79 p_query_id IN NUMBER,
80 p_query_name IN VARCHAR2,
81 p_query_type IN VARCHAR2,
82
83 x_query_id OUT NOCOPY NUMBER,
84 x_query_name OUT NOCOPY VARCHAR2,
85 x_query_type OUT NOCOPY VARCHAR2,
86 x_query_desc OUT NOCOPY VARCHAR2,
87 x_query_data_source OUT NOCOPY VARCHAR2,
88
89 x_query_param_tbl OUT NOCOPY IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
90 x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
91 x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
92
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2
96 );
97 PROCEDURE create_task (
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
100 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
101 p_task_id IN NUMBER DEFAULT NULL,
102 p_task_name IN VARCHAR2,
103 p_task_type_name IN VARCHAR2 DEFAULT NULL,
104 p_task_type_id IN NUMBER DEFAULT NULL,
105 p_description IN VARCHAR2 DEFAULT NULL,
106 p_task_status_name IN VARCHAR2 DEFAULT NULL,
107 p_task_status_id IN NUMBER DEFAULT NULL,
108 p_task_priority_name IN VARCHAR2 DEFAULT NULL,
109 p_task_priority_id IN NUMBER DEFAULT NULL,
110 p_owner_type_name IN VARCHAR2 DEFAULT NULL,
111 p_owner_type_code IN VARCHAR2 DEFAULT NULL,
112 p_owner_id IN NUMBER DEFAULT NULL,
113 p_owner_territory_id IN NUMBER DEFAULT NULL,
114 p_assigned_by_name IN VARCHAR2 DEFAULT NULL,
115 p_assigned_by_id IN NUMBER DEFAULT NULL,
116 p_customer_number IN VARCHAR2 DEFAULT NULL, -- from hz_parties
117 p_customer_id IN NUMBER DEFAULT NULL,
118 p_cust_account_number IN VARCHAR2 DEFAULT NULL,
119 p_cust_account_id IN NUMBER DEFAULT NULL,
120 p_address_id IN NUMBER DEFAULT NULL, ---- hz_party_sites
121 p_address_number IN VARCHAR2 DEFAULT NULL,
122 p_planned_start_date IN DATE DEFAULT NULL,
123 p_planned_end_date IN DATE DEFAULT NULL,
124 p_scheduled_start_date IN DATE DEFAULT NULL,
125 p_scheduled_end_date IN DATE DEFAULT NULL,
126 p_actual_start_date IN DATE DEFAULT NULL,
127 p_actual_end_date IN DATE DEFAULT NULL,
128 p_timezone_id IN NUMBER DEFAULT NULL,
129 p_timezone_name IN VARCHAR2 DEFAULT NULL,
130 p_source_object_type_code IN VARCHAR2 DEFAULT NULL,
131 p_source_object_id IN NUMBER DEFAULT NULL,
132 p_source_object_name IN VARCHAR2 DEFAULT NULL,
133 p_duration IN NUMBER DEFAULT NULL,
134 p_duration_uom IN VARCHAR2 DEFAULT NULL,
135 p_planned_effort IN NUMBER DEFAULT NULL,
136 p_planned_effort_uom IN VARCHAR2 DEFAULT NULL,
137 p_actual_effort IN NUMBER DEFAULT NULL,
138 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
139 p_percentage_complete IN NUMBER DEFAULT NULL,
140 p_reason_code IN VARCHAR2 DEFAULT NULL,
141 p_private_flag IN VARCHAR2 DEFAULT NULL,
142 p_publish_flag IN VARCHAR2 DEFAULT NULL,
143 p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL,
144 p_multi_booked_flag IN VARCHAR2 DEFAULT NULL,
145 p_milestone_flag IN VARCHAR2 DEFAULT NULL,
146 p_holiday_flag IN VARCHAR2 DEFAULT NULL,
147 p_billable_flag IN VARCHAR2 DEFAULT NULL,
148 p_bound_mode_code IN VARCHAR2 DEFAULT NULL,
149 p_soft_bound_flag IN VARCHAR2 DEFAULT NULL,
150 p_workflow_process_id IN NUMBER DEFAULT NULL,
151 p_notification_flag IN VARCHAR2 DEFAULT NULL,
152 p_notification_period IN NUMBER DEFAULT NULL,
153 p_notification_period_uom IN VARCHAR2 DEFAULT NULL,
154 p_parent_task_number IN VARCHAR2 DEFAULT NULL,
155 p_parent_task_id IN NUMBER DEFAULT NULL,
156 p_alarm_start IN NUMBER DEFAULT NULL,
157 p_alarm_start_uom IN VARCHAR2 DEFAULT NULL,
158 p_alarm_on IN VARCHAR2 DEFAULT NULL,
159 p_alarm_count IN NUMBER DEFAULT NULL,
160 p_alarm_interval IN NUMBER DEFAULT NULL,
161 p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL,
162 p_palm_flag IN VARCHAR2 DEFAULT NULL,
163 p_wince_flag IN VARCHAR2 DEFAULT NULL,
164 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
165 p_device1_flag IN VARCHAR2 DEFAULT NULL,
166 p_device2_flag IN VARCHAR2 DEFAULT NULL,
167 p_device3_flag IN VARCHAR2 DEFAULT NULL,
168 p_costs IN NUMBER DEFAULT NULL,
169 p_currency_code IN VARCHAR2 DEFAULT NULL,
170 p_escalation_level IN VARCHAR2 DEFAULT NULL,
171 p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl DEFAULT jtf_tasks_pub.g_miss_task_assign_tbl,
172 p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl DEFAULT jtf_tasks_pub.g_miss_task_depends_tbl,
173 p_task_rsrc_req_tbl IN IEX_API_RECORDS_PVT.task_rsrc_req_tbl DEFAULT IEX_API_RECORDS_PVT.g_miss_task_rsrc_req_tbl,
174 p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl DEFAULT jtf_tasks_pub.g_miss_task_refer_tbl,
175 p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl DEFAULT jtf_tasks_pub.g_miss_task_dates_tbl,
176 p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl DEFAULT jtf_tasks_pub.g_miss_task_notes_tbl,
177 p_task_recur_rec IN jtf_tasks_pub.task_recur_rec DEFAULT jtf_tasks_pub.g_miss_task_recur_rec,
178 p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl DEFAULT jtf_tasks_pub.g_miss_task_contacts_tbl,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 x_task_id OUT NOCOPY NUMBER,
183 p_attribute1 IN VARCHAR2 DEFAULT null ,
184 p_attribute2 IN VARCHAR2 DEFAULT null ,
185 p_attribute3 IN VARCHAR2 DEFAULT null ,
186 p_attribute4 IN VARCHAR2 DEFAULT null ,
187 p_attribute5 IN VARCHAR2 DEFAULT null ,
188 p_attribute6 IN VARCHAR2 DEFAULT null ,
189 p_attribute7 IN VARCHAR2 DEFAULT null ,
190 p_attribute8 IN VARCHAR2 DEFAULT null ,
191 p_attribute9 IN VARCHAR2 DEFAULT null ,
192 p_attribute10 IN VARCHAR2 DEFAULT null ,
193 p_attribute11 IN VARCHAR2 DEFAULT null ,
194 p_attribute12 IN VARCHAR2 DEFAULT null ,
195 p_attribute13 IN VARCHAR2 DEFAULT null ,
196 p_attribute14 IN VARCHAR2 DEFAULT null ,
197 p_attribute15 IN VARCHAR2 DEFAULT null ,
198 p_attribute_category IN VARCHAR2 DEFAULT null,
199 p_date_selected IN VARCHAR2 DEFAULT null,
200 p_category_id IN NUMBER DEFAULT null,
201 p_show_on_calendar IN VARCHAR2 DEFAULT null,
202 p_owner_status_id IN NUMBER DEFAULT null,
203 p_template_id IN NUMBER DEFAULT null,
204 p_template_group_id IN NUMBER DEFAULT null
205 );
206 --End fix bug #4867510-jypark-12/21/2005-fix for Developer 10g Upgrade
207
208
209
210 END IEX_API_RECORDS_PVT;