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.PV_OPP_MATCH_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 173: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

169: l_msg_count NUMBER;
170: l_msg_data VARCHAR2(500);
171: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
172: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
173: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
174: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
175: l_distance_uom VARCHAR2(30);
176: l_distance_uom_returned VARCHAR2(30);
177:

Line 282: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

278: p_resource_id IN NUMBER := NULL,
279: p_routing_flag IN VARCHAR2 := 'N',
280: x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE,
281: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
282: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
283: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
284: x_distance_uom_returned OUT NOCOPY VARCHAR2,
285: x_selected_rule_id OUT NOCOPY NUMBER,
286: x_return_status OUT NOCOPY VARCHAR2,

Line 368: x_flagcount := JTF_VARCHAR2_TABLE_100();

364: -- Initialize OUT parameters.
365: -- ------------------------------------------------------------------------
366: x_partner_tbl := JTF_NUMBER_TABLE();
367: x_partner_details := JTF_VARCHAR2_TABLE_4000();
368: x_flagcount := JTF_VARCHAR2_TABLE_100();
369: x_distance_tbl := JTF_NUMBER_TABLE();
370:
371: -- ------------------------------------------------------------------------
372: -- Retrieve profile value for stack trace profile option.

Line 881: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

877: p_routing_flag IN VARCHAR2,
878: p_incumbent_partner_only IN VARCHAR2 := 'N',
879: x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE,
880: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
881: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
882: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
883: x_distance_uom_returned OUT NOCOPY VARCHAR2,
884: x_return_status OUT NOCOPY VARCHAR2,
885: x_msg_count OUT NOCOPY NUMBER,

Line 983: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

979: --l_distance_uom_returned VARCHAR2(30);
980:
981: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
982: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
983: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
984: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
985:
986: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
987: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 984: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

980:
981: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
982: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
983: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
984: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
985:
986: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
987: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
988: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

Line 986: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

982: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
983: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
984: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
985:
986: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
987: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
988: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
989:
990: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 988: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

984: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
985:
986: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
987: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
988: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
989:
990: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
991: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
992: -- vansub

Line 996: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

992: -- vansub
993: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
994: --
995: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
996: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
997:
998: l_stop_flag BOOLEAN := FALSE;
999:
1000: l_partner_distance_tbl DBMS_SQL.NUMBER_TABLE;