[Home] [Help]
PACKAGE: APPS.PV_MATCH_V2_PUB
Source
1 package PV_MATCH_V2_PUB AUTHID CURRENT_USER as
2 /* $Header: pvxmtchs.pls 120.1 2005/12/02 16:56:35 amaram noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='PV_MATCH_V2_PUB';
5
6
7
8 g_string_data_type CONSTANT VARCHAR2(30) := 'STRING';
9 g_number_data_type CONSTANT VARCHAR2(30) := 'NUMBER';
10 g_date_data_type CONSTANT VARCHAR2(30) := 'DATE';
11 g_currency_data_type CONSTANT VARCHAR2(30) := 'CURRENCY';
12
13 g_drop_attr_match CONSTANT VARCHAR2(30) := 'ANY';
14 g_nodrop_attr_match CONSTANT VARCHAR2(30) := 'ALL';
15
16 g_and_attr_select CONSTANT VARCHAR2(30) := 'AND';
17 g_or_attr_select CONSTANT VARCHAR2(30) := 'OR';
18
19 g_equals_opr CONSTANT VARCHAR2(30) := 'EQUALS';
20 g_not_equals_opr CONSTANT VARCHAR2(30) := 'NOT_EQUALS';
21 g_null_opr CONSTANT VARCHAR2(30) := 'IS_NULL';
22 g_not_null_opr CONSTANT VARCHAR2(30) := 'IS_NOT_NULL';
23 g_greater_opr CONSTANT VARCHAR2(30) := 'GREATER_THAN';
24 g_less_opr CONSTANT VARCHAR2(30) := 'LESS_THAN';
25 g_grt_or_equ_opr CONSTANT VARCHAR2(30) := 'GREATER_THAN_OR_EQUALS';
26 g_less_or_equ_opr CONSTANT VARCHAR2(30) := 'LESS_THAN_OR_EQUALS';
27 g_between_opr CONSTANT VARCHAR2(30) := 'BETWEEN';
28 g_from_match_lov_flag BOOLEAN := FALSE;
29
30 TYPE bind_var_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
31
32
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,
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,
45 p_att_delmter IN VARCHAR2,
46 p_selection_criteria 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,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_top_n_rows_by_profile IN VARCHAR2 := 'T'
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,
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,
72 p_att_delmter 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');
82
83
84
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,
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,
103 x_msg_data OUT NOCOPY VARCHAR2); */
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,
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,
118 x_msg_data OUT NOCOPY VARCHAR2) ;
119
120 Procedure Create_Assignment(
121 P_API_VERSION_NUMBER IN NUMBER,
122 P_INIT_MSG_LIST IN VARCHAR2,
123 P_COMMIT IN VARCHAR2,
124 P_VALIDATION_LEVEL IN NUMBER,
125 P_ENTITY IN VARCHAR2,
126 P_LEAD_ID IN NUMBER,
127 P_CREATING_USERNAME IN VARCHAR2,
128 P_ASSIGNMENT_TYPE IN VARCHAR2,
129 P_BYPASS_CM_OK_FLAG IN VARCHAR2,
130 P_PROCESS_RULE_ID IN NUMBER,
131 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
132 X_MSG_COUNT OUT NOCOPY NUMBER,
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,
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,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
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,
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,
166 x_msg_data OUT NOCOPY VARCHAR2);
167
168
169
170
171
172
173 end PV_MATCH_V2_PUB;