eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_99 dependencies on HZ_PARTY_SEARCH

Line 4: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

1: PACKAGE HZ_MATCH_RULE_99 AUTHID CURRENT_USER AS
2: PROCEDURE map_party_rec (
3: p_search_ctx IN BOOLEAN,
4: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5: x_entered_max_score OUT NUMBER,
6: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
7: );
8: PROCEDURE map_party_site_rec (

Line 10: p_search_list IN HZ_PARTY_SEARCH.party_site_list,

6: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
7: );
8: PROCEDURE map_party_site_rec (
9: p_search_ctx IN BOOLEAN,
10: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
11: x_entered_max_score OUT NUMBER,
12: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
13: );
14: PROCEDURE map_contact_rec (

Line 16: p_search_list IN HZ_PARTY_SEARCH.contact_list,

12: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
13: );
14: PROCEDURE map_contact_rec (
15: p_search_ctx IN BOOLEAN,
16: p_search_list IN HZ_PARTY_SEARCH.contact_list,
17: x_entered_max_score OUT NUMBER,
18: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
19: );
20: PROCEDURE map_contact_point_rec (

Line 22: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,

18: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
19: );
20: PROCEDURE map_contact_point_rec (
21: p_search_ctx IN BOOLEAN,
22: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
23: x_entered_max_score OUT NUMBER,
24: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
25: );
26: PROCEDURE get_party_rec (

Line 28: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type

24: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
25: );
26: PROCEDURE get_party_rec (
27: p_party_id IN NUMBER,
28: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
29: );
30: PROCEDURE get_party_site_rec (
31: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list

Line 31: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

27: p_party_id IN NUMBER,
28: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
29: );
30: PROCEDURE get_party_site_rec (
31: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
33: );
34: PROCEDURE get_contact_rec (
35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

Line 32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list

28: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
29: );
30: PROCEDURE get_party_site_rec (
31: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
33: );
34: PROCEDURE get_contact_rec (
35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list

Line 35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

31: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
33: );
34: PROCEDURE get_contact_rec (
35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
37: );
38: PROCEDURE get_contact_point_rec (
39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,

Line 36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list

32: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
33: );
34: PROCEDURE get_contact_rec (
35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
37: );
38: PROCEDURE get_contact_point_rec (
39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

Line 39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,

35: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
37: );
38: PROCEDURE get_contact_point_rec (
39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
41: );
42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

Line 40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

36: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
37: );
38: PROCEDURE get_contact_point_rec (
39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
41: );
42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

Line 43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

39: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
41: );
42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;

Line 44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

40: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
41: );
42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;
48: PROCEDURE check_party_site_cond(

Line 45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

41: );
42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;
48: PROCEDURE check_party_site_cond(
49: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

Line 46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)

42: FUNCTION check_prim_cond(
43: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;
48: PROCEDURE check_party_site_cond(
49: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
50: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

Line 49: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

45: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;
48: PROCEDURE check_party_site_cond(
49: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
50: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
51: x_secondary OUT BOOLEAN,
52: x_primary OUT BOOLEAN
53: );

Line 50: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

46: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47: RETURN BOOLEAN;
48: PROCEDURE check_party_site_cond(
49: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
50: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
51: x_secondary OUT BOOLEAN,
52: x_primary OUT BOOLEAN
53: );
54: PROCEDURE check_contact_cond(

Line 55: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

51: x_secondary OUT BOOLEAN,
52: x_primary OUT BOOLEAN
53: );
54: PROCEDURE check_contact_cond(
55: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
56: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
57: x_secondary OUT BOOLEAN,
58: x_primary OUT BOOLEAN
59: );

Line 56: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

52: x_primary OUT BOOLEAN
53: );
54: PROCEDURE check_contact_cond(
55: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
56: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
57: x_secondary OUT BOOLEAN,
58: x_primary OUT BOOLEAN
59: );
60: PROCEDURE check_contact_point_cond(

Line 61: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

57: x_secondary OUT BOOLEAN,
58: x_primary OUT BOOLEAN
59: );
60: PROCEDURE check_contact_point_cond(
61: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
62: x_secondary OUT BOOLEAN,
63: x_primary OUT BOOLEAN
64: );
65: PROCEDURE find_parties (

Line 67: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

63: x_primary OUT BOOLEAN
64: );
65: PROCEDURE find_parties (
66: p_rule_id IN NUMBER,
67: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
68: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
69: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
70: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
71: p_restrict_sql IN VARCHAR2,

Line 68: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

64: );
65: PROCEDURE find_parties (
66: p_rule_id IN NUMBER,
67: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
68: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
69: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
70: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
71: p_restrict_sql IN VARCHAR2,
72: p_match_type IN VARCHAR2,

Line 69: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

65: PROCEDURE find_parties (
66: p_rule_id IN NUMBER,
67: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
68: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
69: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
70: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
71: p_restrict_sql IN VARCHAR2,
72: p_match_type IN VARCHAR2,
73: p_search_merged IN VARCHAR2,

Line 70: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

66: p_rule_id IN NUMBER,
67: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
68: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
69: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
70: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
71: p_restrict_sql IN VARCHAR2,
72: p_match_type IN VARCHAR2,
73: p_search_merged IN VARCHAR2,
74: p_dup_party_id IN NUMBER,

Line 83: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

79: x_num_matches OUT NUMBER
80: );
81: PROCEDURE find_persons (
82: p_rule_id IN NUMBER,
83: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
84: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
85: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
86: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
87: p_restrict_sql IN VARCHAR2,

Line 84: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

80: );
81: PROCEDURE find_persons (
82: p_rule_id IN NUMBER,
83: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
84: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
85: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
86: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
87: p_restrict_sql IN VARCHAR2,
88: p_match_type IN VARCHAR2,

Line 85: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

81: PROCEDURE find_persons (
82: p_rule_id IN NUMBER,
83: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
84: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
85: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
86: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
87: p_restrict_sql IN VARCHAR2,
88: p_match_type IN VARCHAR2,
89: p_search_merged IN VARCHAR2,

Line 86: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

82: p_rule_id IN NUMBER,
83: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
84: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
85: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
86: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
87: p_restrict_sql IN VARCHAR2,
88: p_match_type IN VARCHAR2,
89: p_search_merged IN VARCHAR2,
90: p_ins_details IN VARCHAR2,

Line 96: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

92: x_num_matches OUT NUMBER
93: );
94: PROCEDURE find_party_details (
95: p_rule_id IN NUMBER,
96: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
97: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
98: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
99: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
100: p_restrict_sql IN VARCHAR2,

Line 97: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

93: );
94: PROCEDURE find_party_details (
95: p_rule_id IN NUMBER,
96: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
97: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
98: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
99: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
100: p_restrict_sql IN VARCHAR2,
101: p_match_type IN VARCHAR2,

Line 98: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

94: PROCEDURE find_party_details (
95: p_rule_id IN NUMBER,
96: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
97: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
98: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
99: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
100: p_restrict_sql IN VARCHAR2,
101: p_match_type IN VARCHAR2,
102: p_search_merged IN VARCHAR2,

Line 99: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

95: p_rule_id IN NUMBER,
96: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
97: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
98: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
99: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
100: p_restrict_sql IN VARCHAR2,
101: p_match_type IN VARCHAR2,
102: p_search_merged IN VARCHAR2,
103: x_search_ctx_id OUT NUMBER,

Line 147: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,

143: );
144: PROCEDURE get_matching_party_sites (
145: p_rule_id IN NUMBER,
146: p_party_id IN NUMBER,
147: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
148: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
149: p_restrict_sql IN VARCHAR2,
150: p_match_type IN VARCHAR2,
151: p_dup_party_site_id IN NUMBER,

Line 148: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

144: PROCEDURE get_matching_party_sites (
145: p_rule_id IN NUMBER,
146: p_party_id IN NUMBER,
147: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
148: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
149: p_restrict_sql IN VARCHAR2,
150: p_match_type IN VARCHAR2,
151: p_dup_party_site_id IN NUMBER,
152: x_search_ctx_id OUT NUMBER,

Line 158: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,

154: );
155: PROCEDURE get_matching_contacts (
156: p_rule_id IN NUMBER,
157: p_party_id IN NUMBER,
158: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
159: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
160: p_restrict_sql IN VARCHAR2,
161: p_match_type IN VARCHAR2,
162: p_dup_contact_id IN NUMBER,

Line 159: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

155: PROCEDURE get_matching_contacts (
156: p_rule_id IN NUMBER,
157: p_party_id IN NUMBER,
158: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
159: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
160: p_restrict_sql IN VARCHAR2,
161: p_match_type IN VARCHAR2,
162: p_dup_contact_id IN NUMBER,
163: x_search_ctx_id OUT NUMBER,

Line 170: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

166:
167: PROCEDURE get_matching_contact_points (
168: p_rule_id IN NUMBER,
169: p_party_id IN NUMBER,
170: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
171: p_restrict_sql IN VARCHAR2,
172: p_match_type IN VARCHAR2,
173: p_dup_contact_point_id IN NUMBER,
174: x_search_ctx_id OUT NUMBER,

Line 180: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

176: );
177: PROCEDURE get_score_details (
178: p_rule_id IN NUMBER,
179: p_party_id IN NUMBER,
180: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
181: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
182: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
183: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
184: x_search_ctx_id IN OUT NUMBER

Line 181: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

177: PROCEDURE get_score_details (
178: p_rule_id IN NUMBER,
179: p_party_id IN NUMBER,
180: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
181: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
182: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
183: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
184: x_search_ctx_id IN OUT NUMBER
185: );

Line 182: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

178: p_rule_id IN NUMBER,
179: p_party_id IN NUMBER,
180: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
181: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
182: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
183: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
184: x_search_ctx_id IN OUT NUMBER
185: );
186: PROCEDURE find_parties_dynamic (

Line 183: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

179: p_party_id IN NUMBER,
180: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
181: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
182: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
183: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
184: x_search_ctx_id IN OUT NUMBER
185: );
186: PROCEDURE find_parties_dynamic (
187: p_rule_id IN NUMBER,

Line 286: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

282: x_num_matches OUT NUMBER
283: );
284: PROCEDURE get_party_for_search (
285: p_party_id IN NUMBER,
286: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
287: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
288: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290: );

Line 287: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

283: );
284: PROCEDURE get_party_for_search (
285: p_party_id IN NUMBER,
286: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
287: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
288: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290: );
291: PROCEDURE get_search_criteria (

Line 288: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

284: PROCEDURE get_party_for_search (
285: p_party_id IN NUMBER,
286: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
287: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
288: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290: );
291: PROCEDURE get_search_criteria (
292: p_party_id IN NUMBER,

Line 289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

285: p_party_id IN NUMBER,
286: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
287: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
288: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290: );
291: PROCEDURE get_search_criteria (
292: p_party_id IN NUMBER,
293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

Line 293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

289: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290: );
291: PROCEDURE get_search_criteria (
292: p_party_id IN NUMBER,
293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

290: );
291: PROCEDURE get_search_criteria (
292: p_party_id IN NUMBER,
293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

Line 295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,

291: PROCEDURE get_search_criteria (
292: p_party_id IN NUMBER,
293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

Line 296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

292: p_party_id IN NUMBER,
293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
300: );

Line 297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

293: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
300: );
301: FUNCTION check_staged RETURN BOOLEAN;

Line 298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

294: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
300: );
301: FUNCTION check_staged RETURN BOOLEAN;
302:

Line 299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

295: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
300: );
301: FUNCTION check_staged RETURN BOOLEAN;
302:
303: -- Fix for Bug 4736139