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_NUMBER_TABLE

Line 62: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_process_rule_id IN NUMBER,
62: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2
66: );

Line 171: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

167: l_api_name VARCHAR2(30) := 'Opportunity_Selection';
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);

Line 174: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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:
178: BEGIN

Line 280: x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE,

276: p_entity IN VARCHAR2,
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,

Line 283: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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,
287: x_msg_count OUT NOCOPY NUMBER,

Line 366: x_partner_tbl := JTF_NUMBER_TABLE();

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

Line 369: x_distance_tbl := JTF_NUMBER_TABLE();

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.
373: -- ------------------------------------------------------------------------

Line 879: x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 882: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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,
886: x_msg_data OUT NOCOPY VARCHAR2

Line 981: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

977: l_customer_address pv_locator.party_address_rec_type;
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:

Line 987: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 990: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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
993: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
994: --

Line 991: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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
993: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
994: --
995: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 993: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

989:
990: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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:

Line 1002: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

998: l_stop_flag BOOLEAN := FALSE;
999:
1000: l_partner_distance_tbl DBMS_SQL.NUMBER_TABLE;
1001: l_preferred_partner_party_id NUMBER;
1002: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1003: l_rule_currency_code VARCHAR2(15);
1004: l_entity_routings_exists BOOLEAN := TRUE;
1005: l_preferred_idx NUMBER;
1006: l_process_rule_name VARCHAR2(100);

Line 1619: FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE)))) a

1615: FOR x IN (
1616: SELECT idx
1617: FROM (SELECT rownum idx, column_value party_id
1618: FROM (SELECT column_value
1619: FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE)))) a
1620: WHERE a.party_id = l_preferred_partner_party_id)
1621: LOOP
1622: l_preferred_idx := x.idx;
1623: END LOOP;

Line 1825: x_distance_tbl := JTF_NUMBER_TABLE();

1821: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1822: Debug('Initialize x_distance_tbl...');
1823: END IF;
1824:
1825: x_distance_tbl := JTF_NUMBER_TABLE();
1826: END IF;
1827:
1828: -- ------------------------------------------------------------------
1829: -- Extend x_distance by the number of preferred partner(s).

Line 2043: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

2039: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2040: p_commit IN VARCHAR2 := FND_API.g_false,
2041: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2042: p_process_rule_id IN NUMBER,
2043: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,
2046: x_msg_data OUT NOCOPY VARCHAR2)
2047: IS

Line 2106: SELECT * FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))

2102: hz_parties b
2103: WHERE a.party_id (+) = b.party_id AND
2104: a.attribute_id (+) = l_attribute_id AND
2105: b.party_id IN (
2106: SELECT * FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))
2107: )
2108: ORDER BY b.party_id;
2109: */
2110:

Line 2131: ' FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))))) c ' ||

2127: ' hz_parties b, ' ||
2128: ' (SELECT * ' ||
2129: ' FROM (SELECT rownum idx, column_value party_id ' ||
2130: ' FROM (SELECT column_value ' ||
2131: ' FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))))) c ' ||
2132: ' WHERE a.party_id (+) = b.party_id AND ' ||
2133: ' a.attribute_id (+) = l_attribute_id AND ' ||
2134: ' b.party_id = c.party_id ' ||
2135: ' ORDER BY c.idx ' ;

Line 2151: FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))))) c

2147: hz_parties b,
2148: (SELECT *
2149: FROM (SELECT rownum idx, column_value party_id
2150: FROM (SELECT column_value
2151: FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))))) c
2152: WHERE a.party_id (+) = b.party_id AND
2153: a.attribute_id (+) = l_attribute_id AND
2154: b.party_id = c.party_id
2155: ORDER BY c.idx;