DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on JTF_VARCHAR2_TABLE_4000

Line 118: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

114: l_return_status VARCHAR2(100);
115: l_msg_count NUMBER;
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);

Line 222: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

218: p_user_name IN VARCHAR2 := NULL,
219: p_resource_id IN NUMBER := NULL,
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,

Line 306: x_partner_details := JTF_VARCHAR2_TABLE_4000();

302:
303: -- ------------------------------------------------------------------------
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: -- ------------------------------------------------------------------------

Line 855: l_attr_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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:
859: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 868: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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:
871: l_stop_flag BOOLEAN := FALSE;
872:

Line 1589: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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,
1593: p_att_delmter IN VARCHAR2,

Line 1624: x_partner_details JTF_VARCHAR2_TABLE_4000;

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;
1628:

Line 1636: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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

Line 1654: x_partner_details := JTF_VARCHAR2_TABLE_4000();

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:
1658: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2058: l_address1_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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();
2062: l_order_table JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 2059: l_attr_desc_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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();
2062: l_order_table JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2063:

Line 2075: x_partner_details JTF_VARCHAR2_TABLE_4000;

2071: l_pt_count NUMBER;
2072:
2073: l_dist_exists BOOLEAN;
2074:
2075: x_partner_details JTF_VARCHAR2_TABLE_4000;
2076: x_recycled_flag_tbl JTF_VARCHAR2_TABLE_100;
2077: x_incumbent_flag_tbl JTF_VARCHAR2_TABLE_100;
2078:
2079: TYPE partner_det_rec is REF CURSOR;