4: G_PKG_NAME CONSTANT VARCHAR2(30):='PV_MATCH_PARTNER';
5:
6: procedure Form_Where_Clause(
7: p_api_version_number IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
12: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
5:
6: procedure Form_Where_Clause(
7: p_api_version_number IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
12: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
13: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
6: procedure Form_Where_Clause(
7: p_api_version_number IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
12: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
13: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
14: p_cm_id IN number,
21: x_msg_data OUT VARCHAR2);
22:
23: Procedure Auto_Match_Criteria (
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_lead_id IN Number,
29: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
22:
23: Procedure Auto_Match_Criteria (
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_lead_id IN Number,
29: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
30: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
23: Procedure Auto_Match_Criteria (
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_lead_id IN Number,
29: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
30: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
31: x_original_attr OUT JTF_VARCHAR2_TABLE_100,