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_VARCHAR2_TABLE_100

Line 119: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_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);
123:

Line 223: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
227: x_return_status OUT NOCOPY VARCHAR2,

Line 307: x_flagcount := JTF_VARCHAR2_TABLE_100();

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: -- ------------------------------------------------------------------------
311: -- Retrieve profile value for stack trace profile option.

Line 856: l_attr_operator_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 857: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
860: l_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
861: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

Line 859: l_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
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();

Line 861: l_extra_partner_details JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

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();
865: -- vansub

Line 869: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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:
873: l_partner_distance_tbl DBMS_SQL.NUMBER_TABLE;

Line 1590: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
1594: p_selection_criteria IN VARCHAR2,

Line 1591: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
1594: p_selection_criteria IN VARCHAR2,
1595: p_resource_id IN NUMBER,

Line 1627: x_flagcount JTF_VARCHAR2_TABLE_100;

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;
1630: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1631: l_prefered_partner_distance NUMBER;

Line 1656: x_flagcount := JTF_VARCHAR2_TABLE_100();

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
1660: fnd_msg_pub.initialize;

Line 2055: l_party_name_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

2051: l_count NUMBER;
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();

Line 2060: l_oppty_last_offer_dt_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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:
2064: l_membertype_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2061: l_active_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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:
2064: l_membertype_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2065: l_industry_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2064: l_membertype_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2067: l_capacityrating_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2068:

Line 2065: l_industry_table 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();
2067: l_capacityrating_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2068:
2069: l_incumbent_party_name VARCHAR2(3600);

Line 2066: l_geography_table 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();
2067: l_capacityrating_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2068:
2069: l_incumbent_party_name VARCHAR2(3600);
2070: l_pt_id NUMBER;

Line 2067: l_capacityrating_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2067: l_capacityrating_table JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2068:
2069: l_incumbent_party_name VARCHAR2(3600);
2070: l_pt_id NUMBER;
2071: l_pt_count NUMBER;

Line 2076: x_recycled_flag_tbl JTF_VARCHAR2_TABLE_100;

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;
2080: lc_partner_detail_cur partner_det_rec;

Line 2077: x_incumbent_flag_tbl JTF_VARCHAR2_TABLE_100;

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;
2080: lc_partner_detail_cur partner_det_rec;
2081:

Line 2234: x_incumbent_flag_tbl := JTF_VARCHAR2_TABLE_100();

2230: THEN
2231: fnd_msg_pub.initialize;
2232: END IF;
2233:
2234: x_incumbent_flag_tbl := JTF_VARCHAR2_TABLE_100();
2235: x_recycled_flag_tbl := JTF_VARCHAR2_TABLE_100();
2236: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2237:
2238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2235: x_recycled_flag_tbl := JTF_VARCHAR2_TABLE_100();

2231: fnd_msg_pub.initialize;
2232: END IF;
2233:
2234: x_incumbent_flag_tbl := JTF_VARCHAR2_TABLE_100();
2235: x_recycled_flag_tbl := JTF_VARCHAR2_TABLE_100();
2236: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2237:
2238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2239: debug('Partner Id count before getting details '||p_matched_id.count);