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_PVT dependencies on JTF_PERZ_QUERY_PUB

Line 61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

57: -- p_query_type IN VARCHAR2 Optional
58: -- p_query_desc IN VARCHAR2 Optional
59: -- p_query_data_source IN VARCHAR2 Optional
60: --
61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

Line 62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

58: -- p_query_desc IN VARCHAR2 Optional
59: -- p_query_data_source IN VARCHAR2 Optional
60: --
61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
66: --

Line 63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

59: -- p_query_data_source IN VARCHAR2 Optional
60: --
61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
66: --
67:

Line 64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

60: --
61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
66: --
67:
68: -- OUT :

Line 65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

61: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
62: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
63: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
64: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
65: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
66: --
67:
68: -- OUT :
69: -- x_query_id OUT NUMBER

Line 96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

92: p_query_type IN VARCHAR2,
93: p_query_desc IN VARCHAR2,
94: p_query_data_source IN VARCHAR2,
95:
96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

Line 97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

93: p_query_desc IN VARCHAR2,
94: p_query_data_source IN VARCHAR2,
95:
96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
101:

Line 98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

94: p_query_data_source IN VARCHAR2,
95:
96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
101:
102: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

95:
96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
101:
102: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
103: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

96: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
97: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
98: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
99: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
100: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
101:
102: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
103: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 139: -- x_query_param_tbl OUT Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,

135: -- x_query_name OUT VARCHAR2(100),
136: -- x_query_type OUT VARCHAR2,
137: -- x_query_desc OUT VARCHAR2,
138:
139: -- x_query_param_tbl OUT Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
140: -- x_query_order_by_tbl OUT Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
141: -- x_query_raw_sql_rec OUT Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
142:
143: -- x_return_status OUT VARCHAR2

Line 140: -- x_query_order_by_tbl OUT Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,

136: -- x_query_type OUT VARCHAR2,
137: -- x_query_desc OUT VARCHAR2,
138:
139: -- x_query_param_tbl OUT Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
140: -- x_query_order_by_tbl OUT Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
141: -- x_query_raw_sql_rec OUT Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
142:
143: -- x_return_status OUT VARCHAR2
144: -- x_msg_count OUT NUMBER

Line 141: -- x_query_raw_sql_rec OUT Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

137: -- x_query_desc OUT VARCHAR2,
138:
139: -- x_query_param_tbl OUT Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
140: -- x_query_order_by_tbl OUT Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
141: -- x_query_raw_sql_rec OUT Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
142:
143: -- x_return_status OUT VARCHAR2
144: -- x_msg_count OUT NUMBER
145: -- x_msg_data OUT VARCHAR2

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

170: x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
171: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
172: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173:
174: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
175: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
176: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
177:
178: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

171: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
172: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173:
174: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
175: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
176: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
177:
178: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

172: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173:
174: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
175: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
176: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
177:
178: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
180: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

195: p_query_id IN NUMBER,
196: p_query_name IN VARCHAR2,
197: p_query_type IN VARCHAR2,
198:
199: x_query_out_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_OUT_TBL_TYPE,
200:
201: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
202: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
203: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

227: -- p_query_type IN VARCHAR2 Optional
228: -- p_query_desc IN VARCHAR2 Optional
229: -- p_query_data_source IN VARCHAR2 Optional
230: --
231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

Line 232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

228: -- p_query_desc IN VARCHAR2 Optional
229: -- p_query_data_source IN VARCHAR2 Optional
230: --
231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
236: --

Line 233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

229: -- p_query_data_source IN VARCHAR2 Optional
230: --
231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
236: --
237: -- OUT :

Line 234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

230: --
231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
236: --
237: -- OUT :
238: -- x_query_id OUT NUMBER

Line 235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE

231: -- p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
232: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
233: -- p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
234: -- := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
235: -- p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
236: --
237: -- OUT :
238: -- x_query_id OUT NUMBER
239: -- x_return_status OUT VARCHAR2

Line 266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

262: p_query_type IN VARCHAR2,
263: p_query_desc IN VARCHAR2,
264: p_query_data_source IN VARCHAR2,
265:
266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

Line 267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

263: p_query_desc IN VARCHAR2,
264: p_query_data_source IN VARCHAR2,
265:
266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
271:

Line 268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

264: p_query_data_source IN VARCHAR2,
265:
266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
271:
272: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

265:
266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
271:
272: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
273: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

266: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
267: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
268: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
269: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
270: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
271:
272: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
273: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
274: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

340: p_query_type IN VARCHAR2,
341: p_query_desc IN VARCHAR2,
342: p_query_data_source IN VARCHAR2,
343:
344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

Line 345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

341: p_query_desc IN VARCHAR2,
342: p_query_data_source IN VARCHAR2,
343:
344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
349:

Line 346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

342: p_query_data_source IN VARCHAR2,
343:
344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
349:
350: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

343:
344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
349:
350: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
351: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

344: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
345: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
346: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
347: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
348: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
349:
350: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
351: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
352: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,