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_V2_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
55: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
56: p_attr_selection_mode IN VARCHAR2,
57: p_att_delmter IN VARCHAR2,
58: p_selection_criteria IN VARCHAR2,

Line 55: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
55: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
56: p_attr_selection_mode IN VARCHAR2,
57: p_att_delmter IN VARCHAR2,
58: p_selection_criteria IN VARCHAR2,
59: p_resource_id IN NUMBER,

Line 67: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

63: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
64: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
65: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
66: x_distance_uom_returned OUT NOCOPY VARCHAR2,
67: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_top_n_rows_by_profile IN VARCHAR2 := 'T'

Line 121: x_flagcount := JTF_VARCHAR2_TABLE_100();

117: END IF;
118: x_matched_id := JTF_NUMBER_TABLE();
119: x_partner_details := JTF_VARCHAR2_TABLE_4000();
120: x_distance_tbl := JTF_NUMBER_TABLE();
121: x_flagcount := JTF_VARCHAR2_TABLE_100();
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: fnd_msg_pub.initialize;

Line 445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

441: p_commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
446: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
447: p_attr_selection_mode IN VARCHAR2,
448: p_att_delmter IN VARCHAR2,
449: p_selection_criteria IN VARCHAR2,

Line 446: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
446: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
447: p_attr_selection_mode IN VARCHAR2,
448: p_att_delmter IN VARCHAR2,
449: p_selection_criteria IN VARCHAR2,
450: p_resource_id IN NUMBER,

Line 1512: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1508: x_msg_count OUT NOCOPY NUMBER,
1509: x_msg_data OUT NOCOPY VARCHAR2
1510: ) IS
1511:
1512: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1513: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1514: l_possible_match_count number := 0;
1515: l_possible_rank_high number := 0;
1516: l_match_count number := 0;

Line 1513: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1509: x_msg_data OUT NOCOPY VARCHAR2
1510: ) IS
1511:
1512: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1513: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1514: l_possible_match_count number := 0;
1515: l_possible_rank_high number := 0;
1516: l_match_count number := 0;
1517: l_top_n_rows number;

Line 2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,

2033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2034: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2035: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,
2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2039: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
2040: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2041: x_return_status OUT NOCOPY VARCHAR2,

Line 2040: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,
2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2039: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
2040: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2041: x_return_status OUT NOCOPY VARCHAR2,
2042: x_msg_count OUT NOCOPY NUMBER,
2043: x_msg_data OUT NOCOPY VARCHAR2) IS
2044:

Line 2252: x_flagcount := JTF_VARCHAR2_TABLE_100();

2248: THEN
2249: fnd_msg_pub.initialize;
2250: END IF;
2251:
2252: x_flagcount := JTF_VARCHAR2_TABLE_100();
2253: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2254:
2255: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2256:

Line 2661: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2657: p_lead_id IN NUMBER,
2658: p_resource_id IN NUMBER,
2659: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,
2660: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
2661: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2662: x_return_status OUT NOCOPY VARCHAR2,
2663: x_msg_count OUT NOCOPY NUMBER,
2664: x_msg_data OUT NOCOPY VARCHAR2) IS
2665:

Line 2672: l_tmp_tbl JTF_VARCHAR2_TABLE_1000;

2668: DUMMY_NUMBER CONSTANT NUMBER := 99999999999;
2669: Type assignment_rec is REF CURSOR;
2670:
2671: assignment_cur assignment_rec;
2672: l_tmp_tbl JTF_VARCHAR2_TABLE_1000;
2673: l_tmp varchar2(10);
2674: l_incumbent_pt_party_id number;
2675: l_assignment_started varchar2(1000);
2676: l_assigned_partners varchar2(2000);

Line 2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();

2773: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2774: fnd_msg_pub.initialize;
2775: END IF;
2776:
2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();
2778: x_flagcount := JTF_VARCHAR2_TABLE_100();
2779: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2780: x_assigned_partner_id := JTF_NUMBER_TABLE();
2781: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2778: x_flagcount := JTF_VARCHAR2_TABLE_100();

2774: fnd_msg_pub.initialize;
2775: END IF;
2776:
2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();
2778: x_flagcount := JTF_VARCHAR2_TABLE_100();
2779: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2780: x_assigned_partner_id := JTF_NUMBER_TABLE();
2781: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2782:

Line 3151: l_source_type_tbl JTF_VARCHAR2_TABLE_100;

3147: l_rank number;
3148: l_source_type VARCHAR2(30);
3149: l_partner_id_tbl JTF_NUMBER_TABLE;
3150: l_rank_tbl JTF_NUMBER_TABLE;
3151: l_source_type_tbl JTF_VARCHAR2_TABLE_100;
3152: l_party_id number;
3153: l_party_count number := 0;
3154:
3155: cursor lc_get_saved_pts (pc_lead_id number) is

Line 3186: l_source_type_tbl := jtf_varchar2_table_100();

3182: END IF;
3183:
3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();
3185: l_RANK_TBL := JTF_NUMBER_TABLE();
3186: l_source_type_tbl := jtf_varchar2_table_100();
3187: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3188:
3189: open lc_get_saved_pts(p_lead_id);
3190: loop