36: p_api_version_number IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
47: p_resource_id IN NUMBER,
48: p_lead_id IN NUMBER,
49: p_auto_match_flag IN VARCHAR2,
50: p_get_distance_flag IN VARCHAR2 := 'F',
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,
49: p_auto_match_flag IN VARCHAR2,
50: p_get_distance_flag IN VARCHAR2 := 'F',
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,
63: p_api_version_number IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
73: p_selection_criteria IN VARCHAR2,
74: p_resource_id IN NUMBER,
75: p_lead_id IN NUMBER,
76: p_auto_match_flag IN VARCHAR2,
77: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_top_n_rows_by_profile IN VARCHAR2 := 'T');
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,
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,
102: x_msg_count OUT NOCOPY NUMBER,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
141: p_selection_criteria IN VARCHAR2,
142: p_num_of_attrs IN NUMBER,
143: p_bind_var_tbl IN bind_var_tbl,
144: p_top_n_rows_by_profile IN VARCHAR2 := 'T',
145: x_matched_prt OUT NOCOPY JTF_NUMBER_TABLE,
146: x_prt_matched OUT NOCOPY BOOLEAN,
147: x_matched_attr_cnt OUT NOCOPY NUMBER,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
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,
165: x_msg_count OUT NOCOPY NUMBER,