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 436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

432: /* and the table jty_denorm_dea_rules_all for date effective mode */
433: PROCEDURE update_denorm_table (
434: p_source_id IN NUMBER,
435: p_mode IN VARCHAR2,
436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

433: PROCEDURE update_denorm_table (
434: p_source_id IN NUMBER,
435: p_mode IN VARCHAR2,
436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

434: p_source_id IN NUMBER,
435: p_mode IN VARCHAR2,
436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,

435: p_mode IN VARCHAR2,
436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
443: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,

Line 440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,

436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
443: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
444: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,

437: p_related_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
443: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
444: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
445: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,

Line 442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

438: p_top_level_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
439: p_num_winners_tbl IN OUT NOCOPY jtf_terr_number_list,
440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
443: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
444: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
445: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,
446: p_end_date_tbl IN OUT NOCOPY jtf_terr_date_list,

Line 444: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,

440: p_level_from_root_tbl IN OUT NOCOPY jtf_terr_number_list,
441: p_level_from_parent_tbl IN OUT NOCOPY jtf_terr_number_list,
442: p_terr_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
443: p_immediate_parent_flag_tbl IN OUT NOCOPY jtf_terr_char_1list,
444: p_org_id_tbl IN OUT NOCOPY jtf_terr_number_list,
445: p_start_date_tbl IN OUT NOCOPY jtf_terr_date_list,
446: p_end_date_tbl IN OUT NOCOPY jtf_terr_date_list,
447: errbuf OUT NOCOPY VARCHAR2,
448: retcode OUT NOCOPY VARCHAR2)

Line 662: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

658: END update_denorm_table;
659:
660: /* This procedure updates the relative rank in the table jtf_terr_all */
661: PROCEDURE update_relative_rank (
662: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
663: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
664: errbuf OUT NOCOPY VARCHAR2,
665: retcode OUT NOCOPY VARCHAR2)
666: IS

Line 663: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,

659:
660: /* This procedure updates the relative rank in the table jtf_terr_all */
661: PROCEDURE update_relative_rank (
662: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
663: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
664: errbuf OUT NOCOPY VARCHAR2,
665: retcode OUT NOCOPY VARCHAR2)
666: IS
667:

Line 727: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

723: END update_relative_rank;
724:
725: /* This procedure updates the absolute rank in the table jtf_terr_all */
726: PROCEDURE update_absolute_rank (
727: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
728: p_mode IN VARCHAR2,
729: p_table_name IN VARCHAR2,
730: errbuf OUT NOCOPY VARCHAR2,
731: retcode OUT NOCOPY VARCHAR2)

Line 1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();

1775: l_no_of_records INTEGER;
1776:
1777: l_dyn_str VARCHAR2(1000);
1778:
1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1776:
1777: l_dyn_str VARCHAR2(1000);
1778:
1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1777: l_dyn_str VARCHAR2(1000);
1778:
1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();

1778:
1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1786: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();

Line 1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();

1779: l_terr_id_tbl1 jtf_terr_number_list := jtf_terr_number_list();
1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1786: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();

Line 1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();

1780: l_related_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1786: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1788: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();

Line 1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

1781: l_top_level_terr_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1782: l_num_winners_tbl jtf_terr_number_list := jtf_terr_number_list();
1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1786: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1788: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1789: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();

Line 1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1783: l_level_from_root_tbl jtf_terr_number_list := jtf_terr_number_list();
1784: l_level_from_parent_tbl jtf_terr_number_list := jtf_terr_number_list();
1785: l_terr_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1786: l_immediate_parent_flag_tbl jtf_terr_char_1list := jtf_terr_char_1list();
1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1788: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1789: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1790:
1791: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();

Line 1791: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();

1787: l_org_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1788: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1789: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1790:
1791: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1792: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1793:
1794: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1795:

Line 1792: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();

1788: l_start_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1789: l_end_date_tbl jtf_terr_date_list := jtf_terr_date_list();
1790:
1791: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1792: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1793:
1794: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1795:
1796: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS

Line 1794: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();

1790:
1791: l_terr_id_tbl2 jtf_terr_number_list := jtf_terr_number_list();
1792: l_relative_rank_tbl jtf_terr_number_list := jtf_terr_number_list();
1793:
1794: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1795:
1796: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS
1797: SELECT qual_type_id
1798: FROM jtf_qual_type_usgs_all