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 426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

422: p_query_type IN VARCHAR2,
423: p_query_desc IN VARCHAR2,
424: p_query_data_source IN VARCHAR2,
425:
426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

Line 427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

423: p_query_desc IN VARCHAR2,
424: p_query_data_source IN VARCHAR2,
425:
426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
431:

Line 428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

424: p_query_data_source IN VARCHAR2,
425:
426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
431:
432: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

425:
426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
431:
432: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
433: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

426: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
427: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
428: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
429: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
430: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
431:
432: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
433: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
434: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 438: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

434: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
435: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
436: ) IS
437:
438: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
439: := p_query_param_tbl;
440:
441: l_any_errors BOOLEAN := FALSE;
442: l_any_row_errors BOOLEAN := FALSE;

Line 660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

656: p_query_type IN VARCHAR2,
657: p_query_desc IN VARCHAR2,
658: p_query_data_source IN VARCHAR2,
659:
660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

Line 661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

657: p_query_desc IN VARCHAR2,
658: p_query_data_source IN VARCHAR2,
659:
660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
665:

Line 662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

658: p_query_data_source IN VARCHAR2,
659:
660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
665:
666: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

659:
660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
665:
666: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
667: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

660: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
661: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
662: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
663: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
664: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
665:
666: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
667: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
668: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 672: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

668: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
669: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
670: )IS
671:
672: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
673: := p_query_param_tbl;
674:
675: l_api_version NUMBER := 1.0;
676: l_init_msg_list VARCHAR2(240);

Line 989: x_query_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_OUT_TBL_TYPE,

985: p_query_id IN NUMBER,
986: p_query_name IN VARCHAR2,
987: p_query_type IN VARCHAR2,
988:
989: x_query_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_OUT_TBL_TYPE,
990:
991: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
992: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
993: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

1312: x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1313: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1314: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1315:
1316: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
1317: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
1318: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
1319:
1320: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

1313: x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1314: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1315:
1316: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
1317: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
1318: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
1319:
1320: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1321: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

1314: x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1315:
1316: x_query_param_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE,
1317: x_query_order_by_tbl OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
1318: x_query_raw_sql_rec OUT NOCOPY /* file.sql.39 change */ Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
1319:
1320: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1321: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1322: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1329: l_query_out_tbl Jtf_Perz_Query_Pub.QUERY_OUT_TBL_TYPE;

1325: l_api_name VARCHAR2(60) := 'Get_Perz_Query';
1326: l_api_version_number NUMBER := p_api_version_number;
1327:
1328: -- ******* Get_Perz_Query Local Variables ********
1329: l_query_out_tbl Jtf_Perz_Query_Pub.QUERY_OUT_TBL_TYPE;
1330:
1331: l_count NUMBER := NULL;
1332:
1333: --Temporary variables

Line 1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE

1582: p_query_name IN VARCHAR2,
1583: p_query_type IN VARCHAR2,
1584: p_query_desc IN VARCHAR2,
1585: p_query_data_source IN VARCHAR2,
1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

Line 1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,

1583: p_query_type IN VARCHAR2,
1584: p_query_desc IN VARCHAR2,
1585: p_query_data_source IN VARCHAR2,
1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
1591: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE

1584: p_query_desc IN VARCHAR2,
1585: p_query_data_source IN VARCHAR2,
1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
1591: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1592: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,

1585: p_query_data_source IN VARCHAR2,
1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
1591: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1592: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1593: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,

1586: p_query_param_tbl IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
1587: := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
1588: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
1589: := Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
1590: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE ,
1591: x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1592: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1593: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1594: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2