DBA Data[Home] [Help]

APPS.PV_MATCH_V2_PUB dependencies on JTF_NUMBER_TABLE

Line 40: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 51: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 53: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 67: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 77: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 94: x_matched_attr OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 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,

Line 113: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 145: x_matched_prt OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 161: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

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,