eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_QUERY_PUB dependencies on JTF_PERZ_QUERY_PUB

Line 1: PACKAGE BODY Jtf_Perz_Query_Pub AS

1: PACKAGE BODY Jtf_Perz_Query_Pub AS
2: /* $Header: jtfzppqb.pls 120.2 2005/11/02 04:38:14 skothe ship $ */
3:
4: -- NAME
5: -- Jtf_PERZ_QUERY_PUB

Line 5: -- Jtf_PERZ_QUERY_PUB

1: PACKAGE BODY Jtf_Perz_Query_Pub AS
2: /* $Header: jtfzppqb.pls 120.2 2005/11/02 04:38:14 skothe ship $ */
3:
4: -- NAME
5: -- Jtf_PERZ_QUERY_PUB
6:
7: -- PURPOSE
8: -- Public API for saving, retrieving and updating personalized queries.
9: --

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):='Jtf_Perz_Query_Pub';

15: -- 04/18/2000 SMATTEGU Created
16: -- 06/26/2000 CCHANDRA modified
17:
18: -- *****************************************************************************
19: G_PKG_NAME CONSTANT VARCHAR2(30):='Jtf_Perz_Query_Pub';
20: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfzppqb.pls';
21: -- *****************************************************************************
22:
23:

Line 42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

38: p_query_type IN VARCHAR2,
39: p_query_desc IN VARCHAR2,
40: p_query_data_source IN VARCHAR2,
41:
42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

Line 43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

39: p_query_desc IN VARCHAR2,
40: p_query_data_source IN VARCHAR2,
41:
42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

Line 44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

40: p_query_data_source IN VARCHAR2,
41:
42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
48:

Line 45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

41:
42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
48:
49: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

42: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
48:
49: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
50: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

43: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
44: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
45: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
46: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
47: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
48:
49: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
50: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
51: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;

59:
60: -- ******* Standard Begins ********
61:
62: -- Standard Start of API savepoint
63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;
64:
65: -- Standard call to check for call compatibility.
66: -- IF NOT FND_API.Compatible_API_Call (
67: -- l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

Line 129: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;

125: EXCEPTION
126:
127: WHEN Fnd_Api.G_EXC_ERROR THEN
128:
129: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
130: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
131:
132: Fnd_Msg_Pub.Count_And_Get
133: ( p_count => x_msg_count,

Line 144: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;

140: END IF;
141:
142: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
143:
144: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
145: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
146:
147: Fnd_Msg_Pub.Count_And_Get
148: ( p_count => x_msg_count,

Line 159: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;

155: END IF;
156:
157: WHEN OTHERS THEN
158:
159: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
161:
162: Fnd_Msg_Pub.Count_And_Get
163: ( p_count => x_msg_count,

Line 188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

184: p_query_type IN VARCHAR2,
185: p_query_desc IN VARCHAR2,
186: p_query_data_source IN VARCHAR2,
187:
188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

Line 189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

185: p_query_desc IN VARCHAR2,
186: p_query_data_source IN VARCHAR2,
187:
188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

Line 190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

186: p_query_data_source IN VARCHAR2,
187:
188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
194:

Line 191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

187:
188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
194:
195: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

188: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
194:
195: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
196: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

189: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
190: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
191: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
192: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
193: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
194:
195: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
196: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
197: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;

207:
208: -- ******* Standard Begins ********
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;
212:
213: -- Standard call to check for call compatibility.
214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
215: -- THEN

Line 274: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;

270: EXCEPTION
271:
272: WHEN Fnd_Api.G_EXC_ERROR THEN
273:
274: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
275: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
276:
277: Fnd_Msg_Pub.Count_And_Get
278: ( p_count => x_msg_count,

Line 289: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;

285: END IF;
286:
287: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
288:
289: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
291:
292: Fnd_Msg_Pub.Count_And_Get
293: ( p_count => x_msg_count,

Line 304: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;

300: END IF;
301:
302: WHEN OTHERS THEN
303:
304: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
305: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
306:
307: Fnd_Msg_Pub.Count_And_Get
308: ( p_count => x_msg_count,

Line 338: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,

334: x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
335: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
336: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
337:
338: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
339: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
340: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
341:
342: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 339: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,

335: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
336: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
337:
338: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
339: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
340: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
341:
342: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
343: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 340: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

336: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
337:
338: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
339: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
340: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
341:
342: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
343: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
344: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 471: x_query_out_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_OUT_TBL_TYPE,

467: p_query_id IN NUMBER,
468: p_query_name IN VARCHAR2,
469: p_query_type IN VARCHAR2,
470:
471: x_query_out_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_OUT_TBL_TYPE,
472:
473: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
474: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
475: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

591: p_query_type IN VARCHAR2,
592: p_query_desc IN VARCHAR2,
593: p_query_data_source IN VARCHAR2,
594:
595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

Line 596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

592: p_query_desc IN VARCHAR2,
593: p_query_data_source IN VARCHAR2,
594:
595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

Line 597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

593: p_query_data_source IN VARCHAR2,
594:
595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
601:

Line 598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

594:
595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
601:
602: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

595: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
601:
602: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
603: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

596: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
597: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
598: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
599: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
600: := Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,
601:
602: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
603: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
604: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;

614:
615: -- ******* Standard Begins ********
616:
617: -- Standard Start of API savepoint
618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;
619:
620: -- Standard call to check for call compatibility.
621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
622: -- THEN

Line 681: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

677: EXCEPTION
678:
679: WHEN Fnd_Api.G_EXC_ERROR THEN
680:
681: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
682: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
683:
684: Fnd_Msg_Pub.Count_And_Get
685: ( p_count => x_msg_count,

Line 696: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

692: END IF;
693:
694: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
695:
696: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
697: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
698:
699: Fnd_Msg_Pub.Count_And_Get
700: ( p_count => x_msg_count,

Line 711: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

707: END IF;
708:
709: WHEN OTHERS THEN
710:
711: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
712: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
713:
714: Fnd_Msg_Pub.Count_And_Get
715: ( p_count => x_msg_count,

Line 752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;

748:
749: -- ******* Standard Begins ********
750:
751: -- Standard Start of API savepoint
752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;
753:
754: -- Standard call to check for call compatibility.
755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
756: -- THEN

Line 807: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

803: EXCEPTION
804:
805: WHEN Fnd_Api.G_EXC_ERROR THEN
806:
807: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
808: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
809:
810: Fnd_Msg_Pub.Count_And_Get
811: ( p_count => x_msg_count,

Line 822: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

818: END IF;
819:
820: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
821:
822: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
823: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
824:
825: Fnd_Msg_Pub.Count_And_Get
826: ( p_count => x_msg_count,

Line 837: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

833: END IF;
834:
835: WHEN OTHERS THEN
836:
837: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
838: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
839:
840: Fnd_Msg_Pub.Count_And_Get
841: ( p_count => x_msg_count,

Line 854: END Jtf_Perz_Query_Pub;

850:
851:
852: END Delete_Perz_Query;
853:
854: END Jtf_Perz_Query_Pub;