DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_37 dependencies on HZ_PARTY_STAGE

Line 34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;

30: TYPE vlisttype IS TABLE of VARCHAR2(255) INDEX BY BINARY_INTEGER ;
31: call_order vlisttype;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;

Line 35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;

31: call_order vlisttype;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;

Line 36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;

32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
40: g_other_party_level_attribs BOOLEAN;

Line 37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;

33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
40: g_other_party_level_attribs BOOLEAN;
41:

Line 444: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type

440: p_party_id IN NUMBER
441: ,p_record_id IN NUMBER
442: ,p_search_ctx_id IN NUMBER
443: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
444: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
445: ,p_idx IN NUMBER) IS
446: l_current_score NUMBER:=0;
447: l_score NUMBER;
448: l_attrib_value VARCHAR2(2000);

Line 460: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type

456: p_party_id IN NUMBER
457: ,p_record_id IN NUMBER
458: ,p_search_ctx_id IN NUMBER
459: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
460: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
461: ,p_table_TX3 VARCHAR2
462: ,p_table_TX4 VARCHAR2
463: ,p_table_TX9 VARCHAR2
464: ,p_table_TX10 VARCHAR2

Line 693: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type

689: p_party_id IN NUMBER
690: ,p_record_id IN NUMBER
691: ,p_search_ctx_id IN NUMBER
692: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
693: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
694: ,p_idx IN NUMBER) IS
695: l_current_score NUMBER:=0;
696: l_score NUMBER;
697: l_attrib_value VARCHAR2(2000);

Line 709: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type

705: p_party_id IN NUMBER
706: ,p_record_id IN NUMBER
707: ,p_search_ctx_id IN NUMBER
708: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
709: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
710: ,p_idx IN NUMBER) IS
711: l_current_score NUMBER:=0;
712: l_score NUMBER;
713: l_attrib_value VARCHAR2(2000);

Line 1233: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1229: p_restrict_sql VARCHAR2,
1230: p_match_str VARCHAR2,
1231: p_search_merged VARCHAR2,
1232: p_party_contains_str VARCHAR2,
1233: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1234: l_sqlstr VARCHAR2(4000);
1235: l_search_merged VARCHAR2(1);
1236: BEGIN
1237: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1373: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1369: p_contains_str VARCHAR2,
1370: p_search_ctx_id NUMBER,
1371: p_match_str VARCHAR2,
1372: p_search_merged VARCHAR2,
1373: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1374: l_sqlstr VARCHAR2(4000);
1375: l_hint VARCHAR2(100);
1376: l_check NUMBER;
1377: l_search_merged VARCHAR2(1);

Line 1493: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1489: p_search_ctx_id NUMBER,
1490: p_search_merged VARCHAR2,
1491: p_search_rel_sites VARCHAR2,
1492: p_person_api VARCHAR2,
1493: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1494: l_sqlstr VARCHAR2(4000);
1495: l_hint VARCHAR2(100);
1496: l_check NUMBER;
1497: l_check_dt NUMBER;

Line 1736: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1732: p_restrict_sql VARCHAR2,
1733: p_contains_str VARCHAR2,
1734: p_search_ctx_id NUMBER,
1735: p_search_merged VARCHAR2,
1736: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1737: l_sqlstr VARCHAR2(4000);
1738: l_hint VARCHAR2(100);
1739: l_check NUMBER;
1740: l_check_dt NUMBER;

Line 1885: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,

1881: p_search_ctx_id NUMBER,
1882: p_search_merged VARCHAR2,
1883: p_search_rel_cpts VARCHAR2,
1884: p_person_api VARCHAR2,
1885: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
1886: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
1887: l_sqlstr VARCHAR2(4000);
1888: l_hint VARCHAR2(100);
1889: l_check NUMBER;

Line 2283: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

2279: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2280:
2281: l_score NUMBER;
2282: l_idx NUMBER;
2283: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2284: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2285: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2286: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2287: l_party_id NUMBER;

Line 2284: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

2280:
2281: l_score NUMBER;
2282: l_idx NUMBER;
2283: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2284: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2285: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2286: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2287: l_party_id NUMBER;
2288: l_ps_party_id NUMBER;

Line 2285: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

2281: l_score NUMBER;
2282: l_idx NUMBER;
2283: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2284: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2285: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2286: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2287: l_party_id NUMBER;
2288: l_ps_party_id NUMBER;
2289: l_ct_party_id NUMBER;

Line 2286: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

2282: l_idx NUMBER;
2283: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2284: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2285: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2286: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2287: l_party_id NUMBER;
2288: l_ps_party_id NUMBER;
2289: l_ct_party_id NUMBER;
2290: l_cpt_party_id NUMBER;

Line 3205: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

3201: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3202:
3203: l_score NUMBER;
3204: l_idx NUMBER;
3205: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3206: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3207: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3208: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3209: l_party_id NUMBER;

Line 3206: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

3202:
3203: l_score NUMBER;
3204: l_idx NUMBER;
3205: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3206: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3207: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3208: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3209: l_party_id NUMBER;
3210: l_ps_party_id NUMBER;

Line 3207: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

3203: l_score NUMBER;
3204: l_idx NUMBER;
3205: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3206: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3207: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3208: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3209: l_party_id NUMBER;
3210: l_ps_party_id NUMBER;
3211: l_ct_party_id NUMBER;

Line 3208: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

3204: l_idx NUMBER;
3205: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3206: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3207: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3208: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3209: l_party_id NUMBER;
3210: l_ps_party_id NUMBER;
3211: l_ct_party_id NUMBER;
3212: l_cpt_party_id NUMBER;

Line 3408: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

3404: END;
3405: PROCEDURE open_person_contact_cursor(
3406: p_contains_str VARCHAR2,
3407: p_search_ctx_id NUMBER,
3408: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3409: BEGIN
3410: OPEN x_cursor FOR
3411: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3412: FROM HZ_STAGED_CONTACTS stage

Line 4698: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4694: H_SCORES HZ_PARTY_SEARCH.score_list;
4695:
4696: l_score NUMBER;
4697: l_idx NUMBER;
4698: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4699: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4700: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4701: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4702: l_party_id NUMBER;

Line 4699: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4695:
4696: l_score NUMBER;
4697: l_idx NUMBER;
4698: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4699: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4700: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4701: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4702: l_party_id NUMBER;
4703: l_ps_party_id NUMBER;

Line 4700: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4696: l_score NUMBER;
4697: l_idx NUMBER;
4698: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4699: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4700: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4701: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4702: l_party_id NUMBER;
4703: l_ps_party_id NUMBER;
4704: l_ct_party_id NUMBER;

Line 4701: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4697: l_idx NUMBER;
4698: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4699: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4700: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4701: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4702: l_party_id NUMBER;
4703: l_ps_party_id NUMBER;
4704: l_ct_party_id NUMBER;
4705: l_cpt_party_id NUMBER;

Line 4930: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4926: H_SCORES HZ_PARTY_SEARCH.score_list;
4927:
4928: l_score NUMBER;
4929: l_idx NUMBER;
4930: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4931: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4932: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4933: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4934: l_party_id NUMBER;

Line 4931: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4927:
4928: l_score NUMBER;
4929: l_idx NUMBER;
4930: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4931: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4932: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4933: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4934: l_party_id NUMBER;
4935: l_ps_party_id NUMBER;

Line 4932: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4928: l_score NUMBER;
4929: l_idx NUMBER;
4930: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4931: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4932: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4933: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4934: l_party_id NUMBER;
4935: l_ps_party_id NUMBER;
4936: l_ct_party_id NUMBER;

Line 4933: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4929: l_idx NUMBER;
4930: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4931: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4932: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4933: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4934: l_party_id NUMBER;
4935: l_ps_party_id NUMBER;
4936: l_ct_party_id NUMBER;
4937: l_cpt_party_id NUMBER;

Line 5148: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

5144:
5145:
5146: l_score NUMBER;
5147: l_idx NUMBER;
5148: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5149: l_cpt_party_id NUMBER;
5150: l_cpt_ps_id NUMBER;
5151: l_cpt_contact_id NUMBER;
5152: l_contact_pt_id NUMBER;

Line 5320: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

5316:
5317: l_score NUMBER;
5318: l_match_idx NUMBER;
5319: l_idx NUMBER;
5320: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5321: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5322: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5323: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5324: l_party_id NUMBER;

Line 5321: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

5317: l_score NUMBER;
5318: l_match_idx NUMBER;
5319: l_idx NUMBER;
5320: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5321: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5322: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5323: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5324: l_party_id NUMBER;
5325: l_ps_party_id NUMBER;

Line 5322: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

5318: l_match_idx NUMBER;
5319: l_idx NUMBER;
5320: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5321: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5322: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5323: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5324: l_party_id NUMBER;
5325: l_ps_party_id NUMBER;
5326: l_ct_party_id NUMBER;

Line 5323: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

5319: l_idx NUMBER;
5320: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5321: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5322: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5323: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5324: l_party_id NUMBER;
5325: l_ps_party_id NUMBER;
5326: l_ct_party_id NUMBER;
5327: l_cpt_party_id NUMBER;

Line 5823: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type

5819: PROCEDURE MAP_PARTY_REC(
5820: p_search_ctx IN BOOLEAN,
5821: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5822: x_entered_max_score OUT NUMBER,
5823: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5824: ) IS
5825: tmp VARCHAR2(4000);
5826: l_party_name VARCHAR2(4000);
5827: BEGIN

Line 5875: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list

5871: PROCEDURE MAP_PARTY_SITE_REC(
5872: p_search_ctx IN BOOLEAN,
5873: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5874: x_entered_max_score OUT NUMBER,
5875: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5876: ) IS
5877: l_current_max_score NUMBER;
5878: tmp VARCHAR2(4000);
5879: BEGIN

Line 6145: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list

6141: PROCEDURE MAP_CONTACT_REC(
6142: p_search_ctx IN BOOLEAN,
6143: p_search_list IN HZ_PARTY_SEARCH.contact_list,
6144: x_entered_max_score OUT NUMBER,
6145: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
6146: ) IS
6147: l_current_max_score NUMBER;
6148: tmp VARCHAR2(4000);
6149: BEGIN

Line 6187: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list

6183: PROCEDURE MAP_CONTACT_POINT_REC(
6184: p_search_ctx IN BOOLEAN,
6185: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
6186: x_entered_max_score OUT NUMBER,
6187: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
6188: ) IS
6189: l_current_max_score NUMBER;
6190: tmp VARCHAR2(4000);
6191: BEGIN