DBA Data[Home] [Help]

APPS.PV_OPP_MATCH_PUB dependencies on JTF_VARCHAR2_TABLE_4000

Line 172: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

168: l_return_status VARCHAR2(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);

Line 281: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

277: p_user_name IN VARCHAR2 := NULL,
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,

Line 367: x_partner_details := JTF_VARCHAR2_TABLE_4000();

363: -- ------------------------------------------------------------------------
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: -- ------------------------------------------------------------------------

Line 880: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

876: p_resource_id IN NUMBER := NULL,
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,

Line 982: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

978: l_distance_uom VARCHAR2(30);
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();

Line 995: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

991: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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: