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_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_NUMBER_LIST

Line 387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

383: /* and the table jty_denorm_dea_rules_all for date effective mode */
384: PROCEDURE update_denorm_table (
385: p_source_id IN NUMBER,
386: p_mode IN VARCHAR2,
387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

384: PROCEDURE update_denorm_table (
385: p_source_id IN NUMBER,
386: p_mode IN VARCHAR2,
387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

385: p_source_id IN NUMBER,
386: p_mode IN VARCHAR2,
387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,

386: p_mode IN VARCHAR2,
387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
394: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,

Line 391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,

387: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
394: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
395: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,

388: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
394: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
395: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
396: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,

Line 393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

389: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
390: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
394: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
395: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
396: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,
397: p_end_date_tbl IN OUT NOCOPY jtf_terr_date_list,

Line 395: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,

391: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
392: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
393: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
394: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
395: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
396: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,
397: p_end_date_tbl IN OUT NOCOPY jtf_terr_date_list,
398: errbuf OUT NOCOPY VARCHAR2,
399: retcode OUT NOCOPY VARCHAR2)

Line 565: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

561: END update_denorm_table;
562:
563: /* This procedure updates the relative rank in the table jtf_terr_all */
564: PROCEDURE update_relative_rank (
565: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
566: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
567: errbuf OUT NOCOPY VARCHAR2,
568: retcode OUT NOCOPY VARCHAR2)
569: IS

Line 566: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

562:
563: /* This procedure updates the relative rank in the table jtf_terr_all */
564: PROCEDURE update_relative_rank (
565: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
566: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
567: errbuf OUT NOCOPY VARCHAR2,
568: retcode OUT NOCOPY VARCHAR2)
569: IS
570:

Line 638: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

634: END update_relative_rank;
635:
636: /* This procedure updates the absolute rank in the table jtf_terr_all */
637: PROCEDURE update_absolute_rank (
638: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
639: p_mode IN VARCHAR2,
640: p_table_name IN VARCHAR2,
641: errbuf OUT NOCOPY VARCHAR2,
642: retcode OUT NOCOPY VARCHAR2)

Line 1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();

1643: l_no_of_records INTEGER;
1644:
1645: l_dyn_str VARCHAR2(1000);
1646:
1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1644:
1645: l_dyn_str VARCHAR2(1000);
1646:
1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1645: l_dyn_str VARCHAR2(1000);
1646:
1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();

1646:
1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1654: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();

Line 1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();

1647: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1654: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();

1648: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1654: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1656: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();

Line 1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

1649: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1650: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1654: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1656: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1657: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();

Line 1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1651: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1652: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1653: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1654: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1656: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1657: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1658:
1659: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();

Line 1659: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();

1655: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1656: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1657: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1658:
1659: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1660: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1661:
1662: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1663:

Line 1660: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

1656: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1657: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1658:
1659: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1660: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1661:
1662: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1663:
1664: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS

Line 1662: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1658:
1659: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1660: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1661:
1662: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1663:
1664: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS
1665: SELECT qual_type_id
1666: FROM jtf_qual_type_usgs_all