[Home] [Help]
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,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2
16: )
14: x_msg_count OUT NOCOPY NUMBER,
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);
29:
30:
31: -- Cursor to select all the matching parties without 'within' clause
32: CURSOR c_matched_party_tbl (l_search_ctx_id IN NUMBER) IS
33: SELECT HZ_MATCHED_PARTY_OBJ (
34: hzp.party_id
35: ,mpgt.score
36: ,hzp.party_number
37: ,hzp.party_name
90: FROM HZ_ORIG_SYS_REFERENCES OSR
91: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
92: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
93: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
94: ) AS HZ_MATCHED_PARTY_OBJ_TBL
95: FROM hz_matched_parties_gt mpgt, hz_parties hzp
96: WHERE mpgt.party_id = hzp.party_id
97: AND mpgt.search_context_id = l_search_ctx_id;
98:
98:
99: -- Cursor to select all the matching parties with 'within' clause
100: CURSOR c_matched_party_orig_tbl
101: (l_search_ctx_id IN NUMBER, l_within_os IN VARCHAR2) IS
102: SELECT HZ_MATCHED_PARTY_OBJ (
103: hzp.party_id
104: ,mpgt.score
105: ,hzp.party_number
106: ,hzp.party_name
160: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
161: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
162: AND OSR.ORIG_SYSTEM = l_within_os
163: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
164: ) AS HZ_MATCHED_PARTY_OBJ_TBL
165: FROM hz_matched_parties_gt mpgt, hz_parties hzp
166: WHERE mpgt.party_id = hzp.party_id
167: AND mpgt.search_context_id = l_search_ctx_id;
168: