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.JTY_TAE_GEN_PVT dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1497: from jty_trans_usg_pgm_details a

1493: a.program_name
1494: ,decode(cl_mode, 'DATE EFFECTIVE', a.batch_dea_trans_table_name, a.batch_trans_table_name)
1495: ,a.batch_nm_trans_table_name
1496: ,a.batch_match_table_name
1497: from jty_trans_usg_pgm_details a
1498: where a.source_id = cl_source_id
1499: and a.trans_type_id = cl_trans_id
1500: and a.batch_enable_flag = 'Y';
1501:

Line 1502: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;

1498: where a.source_id = cl_source_id
1499: and a.trans_type_id = cl_trans_id
1500: and a.batch_enable_flag = 'Y';
1501:
1502: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1503: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1504: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1505: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1506:

Line 1503: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;

1499: and a.trans_type_id = cl_trans_id
1500: and a.batch_enable_flag = 'Y';
1501:
1502: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1503: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1504: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1505: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1506:
1507: l_pgm_name_tbl l_pgm_name_tbl_type;

Line 1504: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;

1500: and a.batch_enable_flag = 'Y';
1501:
1502: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1503: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1504: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1505: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1506:
1507: l_pgm_name_tbl l_pgm_name_tbl_type;
1508: l_trans_tbl l_trans_tbl_type;

Line 1505: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;

1501:
1502: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1503: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1504: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1505: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1506:
1507: l_pgm_name_tbl l_pgm_name_tbl_type;
1508: l_trans_tbl l_trans_tbl_type;
1509: l_nm_trans_tbl l_nm_trans_tbl_type;