33: -- pklin
34:
35: Procedure Manual_match(
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,
34:
35: Procedure Manual_match(
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,
35: Procedure Manual_match(
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,
60: );
61:
62: procedure Form_Where_Clause(
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,
61:
62: procedure Form_Where_Clause(
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,
62: procedure Form_Where_Clause(
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,
85:
86:
87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
86:
87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
87: /*Procedure Auto_Match_Criteria (
88: p_api_version_number IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
104:
105:
106: Procedure Get_Assigned_Partners(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
105:
106: Procedure Get_Assigned_Partners(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
106: Procedure Get_Assigned_Partners(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
133: X_MSG_DATA OUT NOCOPY VARCHAR2);
134:
135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,
134:
135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,
142: p_num_of_attrs IN NUMBER,
135: Procedure Match_partner(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_sql IN VARCHAR2,
141: p_selection_criteria IN VARCHAR2,
142: p_num_of_attrs IN NUMBER,
143: p_bind_var_tbl IN bind_var_tbl,
152:
153:
154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
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,
153:
154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
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,
154: Procedure Get_Matched_Partner_Details(
155: p_api_version_number IN NUMBER,
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,