[Home] [Help]
1: PACKAGE BODY IEX_API_RECORDS_PVT as
2: /* $Header: iexutirb.pls 120.2 2006/04/07 09:52:02 lkkumar noship $ */
3: -- *****************************************************
4: FUNCTION INIT_CASE_CONTACT_REC_TYPE
5: RETURN IEX_CASE_CONTACTS_PVT.CASE_CONTACT_REC_TYPE
113: p_query_type IN VARCHAR2,
114: p_query_desc IN VARCHAR2,
115: p_query_data_source IN VARCHAR2,
116:
117: p_query_param_tbl IN IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
118: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
119: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
120: x_query_id OUT NOCOPY NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
177: x_query_type OUT NOCOPY VARCHAR2,
178: x_query_desc OUT NOCOPY VARCHAR2,
179: x_query_data_source OUT NOCOPY VARCHAR2,
180:
181: x_query_param_tbl OUT NOCOPY IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
182: x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
183: x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
298: p_currency_code IN VARCHAR2 DEFAULT NULL,
299: p_escalation_level IN VARCHAR2 DEFAULT NULL,
300: p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl DEFAULT jtf_tasks_pub.g_miss_task_assign_tbl,
301: p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl DEFAULT jtf_tasks_pub.g_miss_task_depends_tbl,
302: 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,
303: p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl DEFAULT jtf_tasks_pub.g_miss_task_refer_tbl,
304: p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl DEFAULT jtf_tasks_pub.g_miss_task_dates_tbl,
305: p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl DEFAULT jtf_tasks_pub.g_miss_task_notes_tbl,
306: p_task_recur_rec IN jtf_tasks_pub.task_recur_rec DEFAULT jtf_tasks_pub.g_miss_task_recur_rec,
455:
456: END CREATE_TASK;
457: --End fix bug #4867510-jypark-12/21/2005-fix for Developer 10g Upgrade
458:
459: END IEX_API_RECORDS_PVT;