1 package PV_MATCH_PARTNER AUTHID CURRENT_USER as
2 /* $Header: pvxpmats.pls 115.19 2002/01/27 21:04:19 pkm ship $*/
3
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,
13 p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
14 p_cm_id IN number,
15 p_lead_id IN number,
16 p_auto_match_flag IN varchar2,
17 x_iterations OUT varchar2,
18 x_matched_id_tbl OUT JTF_VARCHAR2_TABLE_100,
19 x_return_status OUT VARCHAR2,
20 x_msg_count OUT 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,
30 x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
31 x_original_attr OUT JTF_VARCHAR2_TABLE_100,
32 x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
33 x_iterations OUT varchar2,
34 x_matched_id OUT JTF_VARCHAR2_TABLE_100,
35 x_return_status OUT VARCHAR2,
36 x_msg_count OUT NUMBER,
37 x_msg_data OUT VARCHAR2);
38
39 end PV_MATCH_PARTNER;