APPS.PV_MATCH_V2_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 42: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
41: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
42: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
43: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
44: p_attr_selection_mode IN VARCHAR2,
45: p_att_delmter IN VARCHAR2,
46: p_selection_criteria IN VARCHAR2,

Line 43: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
41: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
42: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
43: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
44: p_attr_selection_mode IN VARCHAR2,
45: p_att_delmter IN VARCHAR2,
46: p_selection_criteria IN VARCHAR2,
47: p_resource_id IN NUMBER,

Line 55: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

51: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
52: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
53: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
54: x_distance_uom_returned OUT NOCOPY VARCHAR2,
55: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_top_n_rows_by_profile IN VARCHAR2 := 'T'

Line 69: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
68: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
69: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
70: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
71: p_attr_selection_mode IN VARCHAR2,
72: p_att_delmter IN VARCHAR2,
73: p_selection_criteria IN VARCHAR2,

Line 70: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
68: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
69: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
70: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
71: p_attr_selection_mode IN VARCHAR2,
72: p_att_delmter IN VARCHAR2,
73: p_selection_criteria IN VARCHAR2,
74: p_resource_id IN NUMBER,

Line 95: x_matched_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,

91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_lead_id IN Number,
93: p_resource_id IN Number,
94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,
95: x_matched_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
96: x_original_attr OUT NOCOPY JTF_VARCHAR2_TABLE_100,
97: x_original_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
98: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
99: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

Line 96: x_original_attr OUT NOCOPY JTF_VARCHAR2_TABLE_100,

92: p_lead_id IN Number,
93: p_resource_id IN Number,
94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,
95: x_matched_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
96: x_original_attr OUT NOCOPY JTF_VARCHAR2_TABLE_100,
97: x_original_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
98: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
99: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
100: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 97: x_original_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,

93: p_resource_id IN Number,
94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,
95: x_matched_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
96: x_original_attr OUT NOCOPY JTF_VARCHAR2_TABLE_100,
97: x_original_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
98: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
99: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
100: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
101: x_return_status OUT NOCOPY VARCHAR2,

Line 100: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

96: x_original_attr OUT NOCOPY JTF_VARCHAR2_TABLE_100,
97: x_original_attr_val OUT NOCOPY JTF_VARCHAR2_TABLE_100,
98: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
99: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
100: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2); */
104:

Line 115: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

111: p_lead_id IN NUMBER,
112: p_resource_id IN NUMBER,
113: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,
114: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
115: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2) ;
119:

Line 160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,

156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: p_lead_id IN NUMBER,
160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,
161: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
162: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
163: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
164: x_return_status OUT NOCOPY VARCHAR2,

Line 163: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

159: p_lead_id IN NUMBER,
160: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000 := null,
161: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
162: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
163: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2);
167: