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 FND_API

Line 31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,

27: -- End of Comments
28:
29: TYPE QUERY_PARAMETER_REC_TYPE IS RECORD
30: (
31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,
32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,

Line 32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,

28:
29: TYPE QUERY_PARAMETER_REC_TYPE IS RECORD
30: (
31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,
32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,

Line 33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,

29: TYPE QUERY_PARAMETER_REC_TYPE IS RECORD
30: (
31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,
32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM

Line 34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,

30: (
31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,
32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM
38: );

Line 35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,

31: QUERY_PARAM_ID NUMBER := Fnd_Api.G_MISS_NUM,
32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM
38: );
39:

Line 36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,

32: QUERY_ID NUMBER := Fnd_Api.G_MISS_NUM,
33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM
38: );
39:
40: -- Start of Comments

Line 37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM

33: PARAMETER_NAME VARCHAR2(60) := Fnd_Api.G_MISS_CHAR,
34: PARAMETER_TYPE VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
35: PARAMETER_VALUE VARCHAR2(300) := Fnd_Api.G_MISS_CHAR,
36: PARAMETER_CONDITION VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
37: PARAMETER_SEQUENCE NUMBER := Fnd_Api.G_MISS_NUM
38: );
39:
40: -- Start of Comments
41: -- QUERY_PARAMETER_TBL Table: QUERY_PARAMETER_TBL_TYPE

Line 189: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

185: -- order by direction (ACND_DCND_FLAG) details for a given query.
186: -- 6. If the query to store is a select statement, then p_query_raw_sql_rec
187: -- will hold all the necessary details of the select statement.
188: -- 7. The main out parameter for this API is x_return_status which returns
189: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
190: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
191: -- FND_API.G_RETURN_ERROR when the API hits an error
192:
193: -- *****************************************************************************

Line 190: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

186: -- 6. If the query to store is a select statement, then p_query_raw_sql_rec
187: -- will hold all the necessary details of the select statement.
188: -- 7. The main out parameter for this API is x_return_status which returns
189: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
190: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
191: -- FND_API.G_RETURN_ERROR when the API hits an error
192:
193: -- *****************************************************************************
194:

Line 191: -- FND_API.G_RETURN_ERROR when the API hits an error

187: -- will hold all the necessary details of the select statement.
188: -- 7. The main out parameter for this API is x_return_status which returns
189: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
190: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
191: -- FND_API.G_RETURN_ERROR when the API hits an error
192:
193: -- *****************************************************************************
194:
195: PROCEDURE Save_Perz_Query

Line 197: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

193: -- *****************************************************************************
194:
195: PROCEDURE Save_Perz_Query
196: ( p_api_version_number IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
198: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
199:
200: p_application_id IN NUMBER,
201: p_profile_id IN NUMBER,

Line 198: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

194:
195: PROCEDURE Save_Perz_Query
196: ( p_api_version_number IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
198: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
199:
200: p_application_id IN NUMBER,
201: p_profile_id IN NUMBER,
202: p_profile_name IN VARCHAR2,

Line 304: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

300: -- 7. The API returns x_query_id the ID of the query that has been stored in the
301: -- framework.
302: --
303: -- 8. The other out parameter for this API is x_return_status which returns
304: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
305: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
306: -- FND_API.G_RETURN_ERROR when the API hits an error
307: --
308: -- *****************************************************************************

Line 305: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

301: -- framework.
302: --
303: -- 8. The other out parameter for this API is x_return_status which returns
304: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
305: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
306: -- FND_API.G_RETURN_ERROR when the API hits an error
307: --
308: -- *****************************************************************************
309:

Line 306: -- FND_API.G_RETURN_ERROR when the API hits an error

302: --
303: -- 8. The other out parameter for this API is x_return_status which returns
304: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
305: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
306: -- FND_API.G_RETURN_ERROR when the API hits an error
307: --
308: -- *****************************************************************************
309:
310: PROCEDURE Create_Perz_Query

Line 312: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

308: -- *****************************************************************************
309:
310: PROCEDURE Create_Perz_Query
311: ( p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
313: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
314:
315: p_application_id IN NUMBER,
316: p_profile_id IN NUMBER,

Line 313: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

309:
310: PROCEDURE Create_Perz_Query
311: ( p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
313: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
314:
315: p_application_id IN NUMBER,
316: p_profile_id IN NUMBER,
317: p_profile_name IN VARCHAR2,

Line 398: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

394: --
395: -- 5. query_id, description and query_data_source are also returned.
396: --
397: -- 6. The other out parameters for this API is x_return_status which returns
398: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
399: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
400: -- FND_API.G_RETURN_ERROR when the API hits an error
401: --
402: -- *****************************************************************************

Line 399: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

395: -- 5. query_id, description and query_data_source are also returned.
396: --
397: -- 6. The other out parameters for this API is x_return_status which returns
398: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
399: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
400: -- FND_API.G_RETURN_ERROR when the API hits an error
401: --
402: -- *****************************************************************************
403: PROCEDURE Get_Perz_Query

Line 400: -- FND_API.G_RETURN_ERROR when the API hits an error

396: --
397: -- 6. The other out parameters for this API is x_return_status which returns
398: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
399: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
400: -- FND_API.G_RETURN_ERROR when the API hits an error
401: --
402: -- *****************************************************************************
403: PROCEDURE Get_Perz_Query
404: ( p_api_version_number IN NUMBER,

Line 405: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

401: --
402: -- *****************************************************************************
403: PROCEDURE Get_Perz_Query
404: ( p_api_version_number IN NUMBER,
405: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
406:
407: p_application_id IN NUMBER,
408: p_profile_id IN NUMBER,
409: p_profile_name IN VARCHAR2,

Line 467: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

463: --
464: -- 2. The x_query_out_tbl holds the output set from the query headers.
465: --
466: -- 3. The other out parameters for this API is x_return_status which returns
467: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
468: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
469: -- FND_API.G_RETURN_ERROR when the API hits an error
470: --
471: -- *****************************************************************************

Line 468: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

464: -- 2. The x_query_out_tbl holds the output set from the query headers.
465: --
466: -- 3. The other out parameters for this API is x_return_status which returns
467: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
468: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
469: -- FND_API.G_RETURN_ERROR when the API hits an error
470: --
471: -- *****************************************************************************
472: PROCEDURE Get_Perz_Query_Summary

Line 469: -- FND_API.G_RETURN_ERROR when the API hits an error

465: --
466: -- 3. The other out parameters for this API is x_return_status which returns
467: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
468: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
469: -- FND_API.G_RETURN_ERROR when the API hits an error
470: --
471: -- *****************************************************************************
472: PROCEDURE Get_Perz_Query_Summary
473: ( p_api_version_number IN NUMBER,

Line 474: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

470: --
471: -- *****************************************************************************
472: PROCEDURE Get_Perz_Query_Summary
473: ( p_api_version_number IN NUMBER,
474: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
475:
476: p_application_id IN NUMBER,
477: p_profile_id IN NUMBER,
478: p_profile_name IN VARCHAR2,

Line 560: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

556: -- 6. If the query to store is a select statement, then p_query_raw_sql_rec
557: -- will hold all the necessary details of the select statement.
558: --
559: -- 7. The main out parameter for this API is x_return_status which returns
560: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
561: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
562: -- FND_API.G_RETURN_ERROR when the API hits an error
563: --
564: -- *****************************************************************************

Line 561: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

557: -- will hold all the necessary details of the select statement.
558: --
559: -- 7. The main out parameter for this API is x_return_status which returns
560: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
561: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
562: -- FND_API.G_RETURN_ERROR when the API hits an error
563: --
564: -- *****************************************************************************
565: PROCEDURE Update_Perz_Query

Line 562: -- FND_API.G_RETURN_ERROR when the API hits an error

558: --
559: -- 7. The main out parameter for this API is x_return_status which returns
560: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
561: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
562: -- FND_API.G_RETURN_ERROR when the API hits an error
563: --
564: -- *****************************************************************************
565: PROCEDURE Update_Perz_Query
566: ( p_api_version_number IN NUMBER,

Line 567: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

563: --
564: -- *****************************************************************************
565: PROCEDURE Update_Perz_Query
566: ( p_api_version_number IN NUMBER,
567: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
568: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
569:
570: p_application_id IN NUMBER,
571: p_profile_id IN NUMBER,

Line 568: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

564: -- *****************************************************************************
565: PROCEDURE Update_Perz_Query
566: ( p_api_version_number IN NUMBER,
567: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
568: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
569:
570: p_application_id IN NUMBER,
571: p_profile_id IN NUMBER,
572:

Line 626: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

622: -- the application id (p_application_id) and the query id p_query_id are
623: -- required fields.
624: --
625: -- 2. The out parameter for this API is x_return_status which returns
626: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
627: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
628: -- FND_API.G_RETURN_ERROR when the API hits an error
629: --
630: -- *****************************************************************************

Line 627: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

623: -- required fields.
624: --
625: -- 2. The out parameter for this API is x_return_status which returns
626: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
627: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
628: -- FND_API.G_RETURN_ERROR when the API hits an error
629: --
630: -- *****************************************************************************
631: PROCEDURE Delete_Perz_Query

Line 628: -- FND_API.G_RETURN_ERROR when the API hits an error

624: --
625: -- 2. The out parameter for this API is x_return_status which returns
626: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
627: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
628: -- FND_API.G_RETURN_ERROR when the API hits an error
629: --
630: -- *****************************************************************************
631: PROCEDURE Delete_Perz_Query
632: ( p_api_version_number IN NUMBER,

Line 633: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

629: --
630: -- *****************************************************************************
631: PROCEDURE Delete_Perz_Query
632: ( p_api_version_number IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
634: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
635:
636: p_application_id IN NUMBER,
637: p_profile_id IN NUMBER,

Line 634: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

630: -- *****************************************************************************
631: PROCEDURE Delete_Perz_Query
632: ( p_api_version_number IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
634: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
635:
636: p_application_id IN NUMBER,
637: p_profile_id IN NUMBER,
638: p_query_id IN NUMBER,