DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_SEARCH_ATTR_OBJ_TBL

Line 8: p_search_attr_obj IN HZ_SEARCH_ATTR_OBJ_TBL,

4: PROCEDURE find_party_bos (
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_within_os IN VARCHAR2,
7: p_rule_id IN NUMBER,
8: p_search_attr_obj IN HZ_SEARCH_ATTR_OBJ_TBL,
9: p_party_status IN VARCHAR2,
10: p_restrict_sql IN VARCHAR2,
11: p_match_type IN VARCHAR2,
12: x_search_results_obj OUT NOCOPY HZ_MATCHED_PARTY_OBJ_TBL,

Line 19: l_search_attr_obj HZ_SEARCH_ATTR_OBJ_TBL;

15: x_msg_data OUT NOCOPY VARCHAR2
16: )
17: IS
18: --l_search_results_obj_tbl HZ_MATCHED_PARTY_OBJ_TBL;
19: l_search_attr_obj HZ_SEARCH_ATTR_OBJ_TBL;
20: l_return_status VARCHAR2(1);
21: l_msg_count NUMBER;
22: l_msg_data VARCHAR2(2000);
23: l_search_ctx_id NUMBER;

Line 203: l_search_attr_obj := HZ_SEARCH_ATTR_OBJ_TBL();

199: -- Get the count of passed in search attributes
200: l_count := p_search_attr_obj.COUNT;
201:
202: -- Initialze a new search object table with 20 null values
203: l_search_attr_obj := HZ_SEARCH_ATTR_OBJ_TBL();
204: FOR I IN 1..20 LOOP
205: l_search_attr_obj.extend;
206: l_search_attr_obj(i) := HZ_SEARCH_PARTY_OBJ(NULL,NULL);
207: END LOOP;