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_MATCH_V3_PUB dependencies on JTF_NUMBER_TABLE

Line 52: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

48: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
49: p_commit IN VARCHAR2 := FND_API.g_false,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: p_process_rule_id IN NUMBER,
52: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2
56: );

Line 120: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

116: l_msg_data VARCHAR2(500);
117: l_partner_cnt NUMBER;
118: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
119: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
120: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
121: l_distance_uom VARCHAR2(30);
122: l_distance_uom_returned VARCHAR2(30);
123:
124:

Line 224: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,

220: p_routing_flag IN VARCHAR2 := 'N',
221: x_partner_cnt OUT NOCOPY NUMBER,
222: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
223: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
224: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
225: x_distance_uom_returned OUT NOCOPY VARCHAR2,
226: x_selected_rule_id OUT NOCOPY NUMBER,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,

Line 308: x_distance_tbl := JTF_NUMBER_TABLE();

304: -- Initialize OUT parameters.
305: -- ------------------------------------------------------------------------
306: x_partner_details := JTF_VARCHAR2_TABLE_4000();
307: x_flagcount := JTF_VARCHAR2_TABLE_100();
308: x_distance_tbl := JTF_NUMBER_TABLE();
309:
310: -- ------------------------------------------------------------------------
311: -- Retrieve profile value for stack trace profile option.
312: -- ------------------------------------------------------------------------

Line 821: x_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

817: SELECT process_rule_name
818: FROM pv_process_rules_vl
819: WHERE process_rule_id = p_process_rule_id;
820:
821: x_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
822: x_distance_uom_returned VARCHAR2(30);
823: x_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
824:
825: l_entity_routing lc_entity_routings%ROWTYPE;

Line 823: x_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

819: WHERE process_rule_id = p_process_rule_id;
820:
821: x_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
822: x_distance_uom_returned VARCHAR2(30);
823: x_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
824:
825: l_entity_routing lc_entity_routings%ROWTYPE;
826:
827: l_api_version NUMBER := 1.0;

Line 854: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

850: l_customer_address pv_locator.party_address_rec_type;
851: l_distance_uom VARCHAR2(30);
852: --l_distance_uom_returned VARCHAR2(30);
853:
854: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
855: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
856: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
857: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
858:

Line 860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

856: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
857: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
858:
859: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
861: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862:
863: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
864: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

859: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
861: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862:
863: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
864: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: -- vansub
866: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
867: --

Line 864: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
861: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862:
863: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
864: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: -- vansub
866: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
867: --
868: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 866: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

862:
863: -- l_partner_tbl_temp JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
864: l_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: -- vansub
866: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
867: --
868: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
869: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
870:

Line 875: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

871: l_stop_flag BOOLEAN := FALSE;
872:
873: l_partner_distance_tbl DBMS_SQL.NUMBER_TABLE;
874: l_preferred_partner_party_id NUMBER;
875: l_distance_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
876: l_rule_currency_code VARCHAR2(15);
877: l_entity_routings_exists BOOLEAN := TRUE;
878: l_preferred_idx NUMBER;
879: l_process_rule_name VARCHAR2(100);

Line 1518: x_distance_tbl := JTF_NUMBER_TABLE();

1514: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1515: Debug('Initialize x_distance_tbl...');
1516: END IF;
1517:
1518: x_distance_tbl := JTF_NUMBER_TABLE();
1519: END IF;
1520:
1521: END IF;
1522:

Line 1588: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

1584: p_api_version_number IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1588: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
1589: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1590: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1591: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1592: p_attr_selection_mode IN VARCHAR2,

Line 1613: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1609: SELECT asla.INCUMBENT_PARTNER_PARTY_ID
1610: FROM as_leads_all asla
1611: WHERE asla.lead_id = pc_lead_id;
1612:
1613: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1614: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1615:
1616: l_incumbent_pt_party_id NUMBER;
1617: l_matched_tbl_last_idx NUMBER := 0;

Line 1614: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1610: FROM as_leads_all asla
1611: WHERE asla.lead_id = pc_lead_id;
1612:
1613: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1614: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1615:
1616: l_incumbent_pt_party_id NUMBER;
1617: l_matched_tbl_last_idx NUMBER := 0;
1618: l_incumbent_idx NUMBER := 0;

Line 1623: x_matched_id JTF_NUMBER_TABLE;

1619:
1620: l_distance_uom VARCHAR2(100);
1621: l_customer_address pv_locator.party_address_rec_type;
1622:
1623: x_matched_id JTF_NUMBER_TABLE;
1624: x_partner_details JTF_VARCHAR2_TABLE_4000;
1625: x_distance_tbl JTF_NUMBER_TABLE;
1626: x_distance_uom_returned VARCHAR2(30);
1627: x_flagcount JTF_VARCHAR2_TABLE_100;

Line 1625: x_distance_tbl JTF_NUMBER_TABLE;

1621: l_customer_address pv_locator.party_address_rec_type;
1622:
1623: x_matched_id JTF_NUMBER_TABLE;
1624: x_partner_details JTF_VARCHAR2_TABLE_4000;
1625: x_distance_tbl JTF_NUMBER_TABLE;
1626: x_distance_uom_returned VARCHAR2(30);
1627: x_flagcount JTF_VARCHAR2_TABLE_100;
1628:
1629: l_no_of_prefered_pts NUMBER := 0;

Line 1630: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1626: x_distance_uom_returned VARCHAR2(30);
1627: x_flagcount JTF_VARCHAR2_TABLE_100;
1628:
1629: l_no_of_prefered_pts NUMBER := 0;
1630: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1631: l_prefered_partner_distance NUMBER;
1632: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1633: l_prefered_dist_uom VARCHAR2(200);
1634:

Line 1632: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1628:
1629: l_no_of_prefered_pts NUMBER := 0;
1630: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1631: l_prefered_partner_distance NUMBER;
1632: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1633: l_prefered_dist_uom VARCHAR2(200);
1634:
1635: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1636: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 1635: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1631: l_prefered_partner_distance NUMBER;
1632: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1633: l_prefered_dist_uom VARCHAR2(200);
1634:
1635: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1636: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
1637:
1638: l_locator_flag VARCHAR2(1) := 'Y';
1639: BEGIN

Line 1653: x_matched_id := JTF_NUMBER_TABLE();

1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650:
1651: END IF;
1652:
1653: x_matched_id := JTF_NUMBER_TABLE();
1654: x_partner_details := JTF_VARCHAR2_TABLE_4000();
1655: x_distance_tbl := JTF_NUMBER_TABLE();
1656: x_flagcount := JTF_VARCHAR2_TABLE_100();
1657:

Line 1655: x_distance_tbl := JTF_NUMBER_TABLE();

1651: END IF;
1652:
1653: x_matched_id := JTF_NUMBER_TABLE();
1654: x_partner_details := JTF_VARCHAR2_TABLE_4000();
1655: x_distance_tbl := JTF_NUMBER_TABLE();
1656: x_flagcount := JTF_VARCHAR2_TABLE_100();
1657:
1658: -- Initialize message list if p_init_msg_list is set to TRUE.
1659: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1728: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a

1724: FOR x IN (
1725: SELECT idx
1726: FROM (SELECT rownum idx, column_value party_id
1727: FROM (SELECT column_value
1728: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a
1729: WHERE a.party_id = l_incumbent_pt_party_id)
1730: LOOP
1731: l_incumbent_idx := x.idx;
1732:

Line 1847: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a

1843: FOR x IN (
1844: SELECT idx
1845: FROM (SELECT rownum idx, column_value party_id
1846: FROM (SELECT column_value
1847: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a
1848: WHERE a.party_id = l_incumbent_pt_party_id)
1849: LOOP
1850: l_incumbent_idx := x.idx;
1851: END LOOP;

Line 2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

2002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2003: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2004: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2005: p_lead_id IN NUMBER,
2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2007: p_distance_tbl IN JTF_NUMBER_TABLE,
2008: x_return_status OUT NOCOPY VARCHAR2,
2009: x_msg_count OUT NOCOPY NUMBER,
2010: x_msg_data OUT NOCOPY VARCHAR2)

Line 2007: p_distance_tbl IN JTF_NUMBER_TABLE,

2003: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2004: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2005: p_lead_id IN NUMBER,
2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2007: p_distance_tbl IN JTF_NUMBER_TABLE,
2008: x_return_status OUT NOCOPY VARCHAR2,
2009: x_msg_count OUT NOCOPY NUMBER,
2010: x_msg_data OUT NOCOPY VARCHAR2)
2011: IS

Line 2056: l_party_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2052: l_wf_status VARCHAR2(1000);
2053: l_active_flag VARCHAR2(1);
2054:
2055: l_party_name_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
2056: l_party_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2057: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2058: l_address1_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2059: l_attr_desc_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2060: l_oppty_last_offer_dt_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2057: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2053: l_active_flag VARCHAR2(1);
2054:
2055: l_party_name_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
2056: l_party_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2057: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2058: l_address1_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2059: l_attr_desc_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2060: l_oppty_last_offer_dt_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2061: l_active_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2062: l_order_table JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2058: l_address1_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2059: l_attr_desc_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
2060: l_oppty_last_offer_dt_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2061: l_active_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2062: l_order_table JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2063:
2064: l_membertype_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2065: l_industry_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2066: l_geography_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2127: SELECT * FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE))

2123: AND hzr.subject_id = HZOP_pt.party_id and nvl(hzop_pt.effective_end_date,sysdate) >= sysdate
2124: AND hzr.object_id = HZOP_vend.party_id and nvl(hzop_vend.effective_end_date,sysdate) >= sysdate
2125: AND (HZOP_vend.internal_flag = 'N' or hzop_pt.internal_flag = 'Y')
2126: AND pvpp.partner_id in (
2127: SELECT * FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE))
2128: )
2129: AND hzr.object_id = vend.party_id
2130: AND hzr.relationship_code in ('PARTNER_OF','VAD_OF');
2131: */

Line 2160: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

2156: from hz_parties hzp , pv_partner_profiles pvpp ,
2157: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2158: hz_organization_profiles HZOP,
2159: (SELECT rownum idx, column_value
2160: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2161: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))
2162: and pvpp.partner_id = x_partner.column_value
2163: and hzr.party_id = pvpp.partner_id
2164: and hzr.subject_id = hzp.party_id

Line 2161: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))

2157: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2158: hz_organization_profiles HZOP,
2159: (SELECT rownum idx, column_value
2160: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2161: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))
2162: and pvpp.partner_id = x_partner.column_value
2163: and hzr.party_id = pvpp.partner_id
2164: and hzr.subject_id = hzp.party_id
2165: and hzr.object_id = HZOP.party_id

Line 2186: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

2182: from hz_parties hzp,
2183: pv_partner_profiles pvpp,
2184: pv_attribute_codes_vl pvac,
2185: (SELECT rownum idx, column_value
2186: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2187: where pvpp.partner_id = x_partner.column_value
2188: and pvpp.partner_party_id = hzp.party_id
2189: and pvpp.PARTNER_LEVEL = pvac.attr_code_id(+)
2190: order by x_partner.idx;

Line 2465: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

2461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2462: p_commit IN VARCHAR2 := FND_API.g_false,
2463: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2464: p_process_rule_id IN NUMBER,
2465: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2466: x_return_status OUT NOCOPY VARCHAR2,
2467: x_msg_count OUT NOCOPY NUMBER,
2468: x_msg_data OUT NOCOPY VARCHAR2)
2469: IS

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

2522: hz_parties b
2523: WHERE a.party_id (+) = b.party_id AND
2524: a.attribute_id (+) = l_attribute_id AND
2525: b.party_id IN (
2526: SELECT * FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))
2527: )
2528: ORDER BY b.party_id;
2529: */
2530:

Line 2550: ' jtf_number_table))))) c ' ||

2546: ' c.idx ' ||
2547: ' from ' ||
2548: ' (select * from (select rownum idx, ' ||
2549: ' column_value party_id from (select column_value from table (cast(:2 as ' ||
2550: ' jtf_number_table))))) c ' ||
2551: ' order by c.idx ' ;
2552:
2553: /*
2554: ' SELECT ' ||

Line 2563: ' FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE))))) c ' ||

2559: ' hz_parties b, ' ||
2560: ' (SELECT * ' ||
2561: ' FROM (SELECT rownum idx, column_value party_id ' ||
2562: ' FROM (SELECT column_value ' ||
2563: ' FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE))))) c ' ||
2564: ' WHERE a.party_id (+) = b.party_id AND ' ||
2565: ' a.attribute_id (+) = :2 AND ' ||
2566: ' b.party_id = c.party_id ' ||
2567: ' ORDER BY c.idx ' ;

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

2580: hz_parties b,
2581: (SELECT *
2582: FROM (SELECT rownum idx, column_value party_id
2583: FROM (SELECT column_value
2584: FROM TABLE (CAST(x_partner_tbl AS JTF_NUMBER_TABLE))))) c
2585: WHERE a.party_id (+) = b.party_id AND
2586: a.attribute_id (+) = l_attribute_id AND
2587: b.party_id = c.party_id
2588: ORDER BY c.idx;