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_52 dependencies on HZ_PARTY_SEARCH

Line 32: call_max_score HZ_PARTY_SEARCH.IDList;

28: -- ==========================================================================================
29:
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;

Line 38: g_mappings HZ_PARTY_SEARCH.IDList;

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:
41: g_debug_count NUMBER := 0;
42: g_score_until_thresh BOOLEAN:=false;

Line 53: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type)

49: 1. At least one primary condition is passed
50: ************************************************/
51:
52: FUNCTION check_parties_bulk(
53: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type)
54: RETURN VARCHAR2 IS
55: BEGIN
56: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN
57: RETURN 'Y' ;

Line 81: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list

77: has party site criteria.
78: ************************************************/
79:
80: FUNCTION check_party_sites_bulk(
81: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list
82: )
83: RETURN VARCHAR2 IS
84: x_primary boolean := FALSE;
85: BEGIN

Line 111: p_contact_list IN HZ_PARTY_SEARCH.contact_list

107: has contact criteria.
108: ************************************************/
109:
110: FUNCTION check_contacts_bulk (
111: p_contact_list IN HZ_PARTY_SEARCH.contact_list
112: )
113: RETURN VARCHAR2 IS
114: x_primary boolean := FALSE;
115: BEGIN

Line 140: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list

136: has contact criteria.
137: ************************************************/
138:
139: FUNCTION check_cpts_bulk (
140: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list
141: )
142: RETURN VARCHAR2 IS
143: x_primary boolean := FALSE;
144: BEGIN

Line 539: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type

535: PROCEDURE INSERT_PARTY_SCORE (
536: p_party_id IN NUMBER
537: ,p_record_id IN NUMBER
538: ,p_search_ctx_id IN NUMBER
539: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
540: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
541: ,p_table_TX2 VARCHAR2
542: ,p_table_TX59 VARCHAR2
543: ,p_table_TX41 VARCHAR2

Line 640: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type

636: PROCEDURE INSERT_PARTY_SITES_SCORE (
637: p_party_id IN NUMBER
638: ,p_record_id IN NUMBER
639: ,p_search_ctx_id IN NUMBER
640: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
641: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
642: ,p_table_TX26 VARCHAR2
643: ,p_table_TX9 VARCHAR2
644: ,p_table_TX14 VARCHAR2

Line 760: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type

756: PROCEDURE INSERT_CONTACTS_SCORE (
757: p_party_id IN NUMBER
758: ,p_record_id IN NUMBER
759: ,p_search_ctx_id IN NUMBER
760: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
761: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
762: ,p_table_TX2 VARCHAR2
763: ,p_table_TX23 VARCHAR2
764: ,p_table_TX22 VARCHAR2

Line 835: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type

831: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
832: p_party_id IN NUMBER
833: ,p_record_id IN NUMBER
834: ,p_search_ctx_id IN NUMBER
835: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
836: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
837: ,p_table_TX5 VARCHAR2
838: ,p_table_TX7 VARCHAR2
839: ,p_table_TX10 VARCHAR2

Line 939: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type

935: for the PARTY Entity
936: ************************************************/
937:
938: PROCEDURE POP_PARTY_COND_REC(
939: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
940: ) IS
941: BEGIN
942: NULL ;
943: EXCEPTION

Line 959: p_search_list IN HZ_PARTY_SEARCH.party_site_list

955: for the PARTY_SITES Entity
956: ************************************************/
957:
958: PROCEDURE POP_PARTY_SITES_COND_REC(
959: p_search_list IN HZ_PARTY_SEARCH.party_site_list
960: ) IS
961: BEGIN
962: ---------POPULATE THE GLOBAL WORD CONDITION REC FOR PARTY_SITES-------------
963: ------ Populate global condition record only if search list is not empty -----------

Line 984: p_search_list IN HZ_PARTY_SEARCH.contact_list

980: for the CONTACTS Entity
981: ************************************************/
982:
983: PROCEDURE POP_CONTACTS_COND_REC(
984: p_search_list IN HZ_PARTY_SEARCH.contact_list
985: ) IS
986: BEGIN
987: NULL ;
988: EXCEPTION

Line 1004: p_search_list IN HZ_PARTY_SEARCH.contact_point_list

1000: for the CONTACT_POINTS Entity
1001: ************************************************/
1002:
1003: PROCEDURE POP_CONTACT_POINTS_COND_REC(
1004: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
1005: ) IS
1006: BEGIN
1007: NULL ;
1008: EXCEPTION

Line 1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END;
1016:
1017: PROCEDURE init_score_context (
1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

Line 1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,

1015: END;
1016:
1017: PROCEDURE init_score_context (
1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

Line 1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=

1016:
1017: PROCEDURE init_score_context (
1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

Line 1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,

1017: PROCEDURE init_score_context (
1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST

Line 1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1026: ) IS

Line 1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

1019: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1026: ) IS
1027: l_dummy NUMBER;

Line 1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

1020: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1026: ) IS
1027: l_dummy NUMBER;
1028: BEGIN

Line 1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST

1021: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1022: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1023: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1024: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1025: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1026: ) IS
1027: l_dummy NUMBER;
1028: BEGIN
1029: -- Transform search criteria

Line 1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

1034: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
1035:
1036: END;
1037: FUNCTION init_search(
1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

Line 1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,

1035:
1036: END;
1037: FUNCTION init_search(
1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

Line 1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=

1036: END;
1037: FUNCTION init_search(
1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

Line 1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,

1037: FUNCTION init_search(
1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,

Line 1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

1038: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1046: p_match_type IN VARCHAR2,

Line 1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

1039: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1046: p_match_type IN VARCHAR2,
1047: x_party_max_score OUT NUMBER,

Line 1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

1040: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1046: p_match_type IN VARCHAR2,
1047: x_party_max_score OUT NUMBER,
1048: x_ps_max_score OUT NUMBER,

Line 1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,

1041: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1042: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1043: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1044: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1045: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1046: p_match_type IN VARCHAR2,
1047: x_party_max_score OUT NUMBER,
1048: x_ps_max_score OUT NUMBER,
1049: x_contact_max_score OUT NUMBER,

Line 1057: maxscore HZ_PARTY_SEARCH.IDList;

1053: l_ps_entered_max_score NUMBER:=0;
1054: l_ct_entered_max_score NUMBER:=0;
1055: l_cpt_entered_max_score NUMBER:=0;
1056: vlist vlisttype;
1057: maxscore HZ_PARTY_SEARCH.IDList;
1058: l_name VARCHAR2(200);
1059: l_idx NUMBER;
1060: l_num NUMBER;
1061: total NUMBER;

Line 1622: RETURN HZ_PARTY_SEARCH.score_rec IS

1618: p_party_id NUMBER,
1619: p_party_site_id NUMBER,
1620: p_org_contact_id NUMBER,
1621: p_contact_point_id NUMBER)
1622: RETURN HZ_PARTY_SEARCH.score_rec IS
1623: l_score_rec HZ_PARTY_SEARCH.score_rec;
1624: BEGIN
1625: l_score_rec.TOTAL_SCORE := p_init_total_score;
1626: l_score_rec.PARTY_SCORE := p_init_party_score;

Line 1623: l_score_rec HZ_PARTY_SEARCH.score_rec;

1619: p_party_site_id NUMBER,
1620: p_org_contact_id NUMBER,
1621: p_contact_point_id NUMBER)
1622: RETURN HZ_PARTY_SEARCH.score_rec IS
1623: l_score_rec HZ_PARTY_SEARCH.score_rec;
1624: BEGIN
1625: l_score_rec.TOTAL_SCORE := p_init_total_score;
1626: l_score_rec.PARTY_SCORE := p_init_party_score;
1627: l_score_rec.PARTY_SITE_SCORE := p_init_party_site_score;

Line 1654: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

1650: -------------------- BULK MATCH RULE ::: find_parties ------------------------------
1651: -------------------------------------------------------------------------------------
1652: PROCEDURE find_parties (
1653: p_rule_id IN NUMBER,
1654: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1655: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1656: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1657: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1658: p_restrict_sql IN VARCHAR2,

Line 1655: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

1651: -------------------------------------------------------------------------------------
1652: PROCEDURE find_parties (
1653: p_rule_id IN NUMBER,
1654: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1655: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1656: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1657: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1658: p_restrict_sql IN VARCHAR2,
1659: p_match_type IN VARCHAR2,

Line 1656: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

1652: PROCEDURE find_parties (
1653: p_rule_id IN NUMBER,
1654: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1655: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1656: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1657: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1658: p_restrict_sql IN VARCHAR2,
1659: p_match_type IN VARCHAR2,
1660: p_search_merged IN VARCHAR2,

Line 1657: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

1653: p_rule_id IN NUMBER,
1654: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1655: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1656: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1657: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1658: p_restrict_sql IN VARCHAR2,
1659: p_match_type IN VARCHAR2,
1660: p_search_merged IN VARCHAR2,
1661: p_dup_party_id IN NUMBER,

Line 1702: H_SCORES HZ_PARTY_SEARCH.score_list;

1698: l_TX59 VARCHAR2(2000);
1699: l_TX45 VARCHAR2(2000);
1700: l_TX14 VARCHAR2(2000);
1701: l_TX7 VARCHAR2(2000);
1702: H_SCORES HZ_PARTY_SEARCH.score_list;
1703: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1704: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1705:
1706: l_score NUMBER;

Line 1703: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

1699: l_TX45 VARCHAR2(2000);
1700: l_TX14 VARCHAR2(2000);
1701: l_TX7 VARCHAR2(2000);
1702: H_SCORES HZ_PARTY_SEARCH.score_list;
1703: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1704: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1705:
1706: l_score NUMBER;
1707: l_idx NUMBER;

Line 1704: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;

1700: l_TX14 VARCHAR2(2000);
1701: l_TX7 VARCHAR2(2000);
1702: H_SCORES HZ_PARTY_SEARCH.score_list;
1703: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1704: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1705:
1706: l_score NUMBER;
1707: l_idx NUMBER;
1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 1745: h_ps_id HZ_PARTY_SEARCH.IDList;

1741: l_use_contact_cpt_info BOOLEAN := TRUE;
1742: l_use_contact_addr_flag VARCHAR2(1) := 'Y';
1743: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1744:
1745: h_ps_id HZ_PARTY_SEARCH.IDList;
1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;

Line 1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;

1742: l_use_contact_addr_flag VARCHAR2(1) := 'Y';
1743: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1744:
1745: h_ps_id HZ_PARTY_SEARCH.IDList;
1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;

Line 1747: h_ps_score HZ_PARTY_SEARCH.IDList;

1743: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1744:
1745: h_ps_id HZ_PARTY_SEARCH.IDList;
1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;

Line 1748: h_ct_id HZ_PARTY_SEARCH.IDList;

1744:
1745: h_ps_id HZ_PARTY_SEARCH.IDList;
1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

Line 1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;

1745: h_ps_id HZ_PARTY_SEARCH.IDList;
1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1753: h_cpt_score HZ_PARTY_SEARCH.IDList;

Line 1750: h_ct_score HZ_PARTY_SEARCH.IDList;

1746: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1753: h_cpt_score HZ_PARTY_SEARCH.IDList;
1754: detcnt NUMBER := 1;

Line 1751: h_cpt_id HZ_PARTY_SEARCH.IDList;

1747: h_ps_score HZ_PARTY_SEARCH.IDList;
1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1753: h_cpt_score HZ_PARTY_SEARCH.IDList;
1754: detcnt NUMBER := 1;
1755:

Line 1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

1748: h_ct_id HZ_PARTY_SEARCH.IDList;
1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1753: h_cpt_score HZ_PARTY_SEARCH.IDList;
1754: detcnt NUMBER := 1;
1755:
1756:

Line 1753: h_cpt_score HZ_PARTY_SEARCH.IDList;

1749: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1750: h_ct_score HZ_PARTY_SEARCH.IDList;
1751: h_cpt_id HZ_PARTY_SEARCH.IDList;
1752: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1753: h_cpt_score HZ_PARTY_SEARCH.IDList;
1754: detcnt NUMBER := 1;
1755:
1756:
1757: /********************* Find Parties private procedures *******/

Line 2284: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

2280: -------------------- BULK MATCH RULE ::: find_persons ------------------------------
2281: -------------------------------------------------------------------------------------
2282: PROCEDURE find_persons (
2283: p_rule_id IN NUMBER,
2284: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2285: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2286: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2287: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2288: p_restrict_sql IN VARCHAR2,

Line 2285: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

2281: -------------------------------------------------------------------------------------
2282: PROCEDURE find_persons (
2283: p_rule_id IN NUMBER,
2284: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2285: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2286: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2287: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2288: p_restrict_sql IN VARCHAR2,
2289: p_match_type IN VARCHAR2,

Line 2286: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

2282: PROCEDURE find_persons (
2283: p_rule_id IN NUMBER,
2284: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2285: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2286: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2287: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2288: p_restrict_sql IN VARCHAR2,
2289: p_match_type IN VARCHAR2,
2290: p_search_merged IN VARCHAR2,

Line 2287: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

2283: p_rule_id IN NUMBER,
2284: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2285: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2286: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2287: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2288: p_restrict_sql IN VARCHAR2,
2289: p_match_type IN VARCHAR2,
2290: p_search_merged IN VARCHAR2,
2291: p_ins_details IN VARCHAR2,

Line 2329: H_SCORES HZ_PARTY_SEARCH.score_list;

2325: l_TX59 VARCHAR2(2000);
2326: l_TX45 VARCHAR2(2000);
2327: l_TX14 VARCHAR2(2000);
2328: l_TX7 VARCHAR2(2000);
2329: H_SCORES HZ_PARTY_SEARCH.score_list;
2330: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2331: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2332:
2333: l_score NUMBER;

Line 2330: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

2326: l_TX45 VARCHAR2(2000);
2327: l_TX14 VARCHAR2(2000);
2328: l_TX7 VARCHAR2(2000);
2329: H_SCORES HZ_PARTY_SEARCH.score_list;
2330: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2331: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2332:
2333: l_score NUMBER;
2334: l_idx NUMBER;

Line 2331: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;

2327: l_TX14 VARCHAR2(2000);
2328: l_TX7 VARCHAR2(2000);
2329: H_SCORES HZ_PARTY_SEARCH.score_list;
2330: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2331: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2332:
2333: l_score NUMBER;
2334: l_idx NUMBER;
2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 2366: h_ps_id HZ_PARTY_SEARCH.IDList;

2362: l_tmp NUMBER;
2363: l_merge_flag VARCHAR2(1);
2364: l_num_eval NUMBER:=0;
2365:
2366: h_ps_id HZ_PARTY_SEARCH.IDList;
2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;

Line 2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;

2363: l_merge_flag VARCHAR2(1);
2364: l_num_eval NUMBER:=0;
2365:
2366: h_ps_id HZ_PARTY_SEARCH.IDList;
2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;

Line 2368: h_ps_score HZ_PARTY_SEARCH.IDList;

2364: l_num_eval NUMBER:=0;
2365:
2366: h_ps_id HZ_PARTY_SEARCH.IDList;
2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;

Line 2369: h_ct_id HZ_PARTY_SEARCH.IDList;

2365:
2366: h_ps_id HZ_PARTY_SEARCH.IDList;
2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

Line 2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;

2366: h_ps_id HZ_PARTY_SEARCH.IDList;
2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2374: h_cpt_score HZ_PARTY_SEARCH.IDList;

Line 2371: h_ct_score HZ_PARTY_SEARCH.IDList;

2367: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2374: h_cpt_score HZ_PARTY_SEARCH.IDList;
2375: detcnt NUMBER := 1;

Line 2372: h_cpt_id HZ_PARTY_SEARCH.IDList;

2368: h_ps_score HZ_PARTY_SEARCH.IDList;
2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2374: h_cpt_score HZ_PARTY_SEARCH.IDList;
2375: detcnt NUMBER := 1;
2376: l_person_id NUMBER;

Line 2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

2369: h_ct_id HZ_PARTY_SEARCH.IDList;
2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2374: h_cpt_score HZ_PARTY_SEARCH.IDList;
2375: detcnt NUMBER := 1;
2376: l_person_id NUMBER;
2377:

Line 2374: h_cpt_score HZ_PARTY_SEARCH.IDList;

2370: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2371: h_ct_score HZ_PARTY_SEARCH.IDList;
2372: h_cpt_id HZ_PARTY_SEARCH.IDList;
2373: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2374: h_cpt_score HZ_PARTY_SEARCH.IDList;
2375: detcnt NUMBER := 1;
2376: l_person_id NUMBER;
2377:
2378: /********************* Find Parties private procedures *******/

Line 2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END find_persons;
2933: PROCEDURE find_persons (
2934: p_rule_id IN NUMBER,
2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2936: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2937: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2938: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2939: p_restrict_sql IN VARCHAR2,

Line 2936: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

2932: END find_persons;
2933: PROCEDURE find_persons (
2934: p_rule_id IN NUMBER,
2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2936: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2937: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2938: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2939: p_restrict_sql IN VARCHAR2,
2940: p_match_type IN VARCHAR2,

Line 2937: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

2933: PROCEDURE find_persons (
2934: p_rule_id IN NUMBER,
2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2936: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2937: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2938: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2939: p_restrict_sql IN VARCHAR2,
2940: p_match_type IN VARCHAR2,
2941: p_ins_details IN VARCHAR2,

Line 2938: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

2934: p_rule_id IN NUMBER,
2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2936: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2937: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2938: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2939: p_restrict_sql IN VARCHAR2,
2940: p_match_type IN VARCHAR2,
2941: p_ins_details IN VARCHAR2,
2942: x_search_ctx_id OUT NUMBER,

Line 2955: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

2951: -------------------- BULK MATCH RULE ::: find_party_details ------------------------
2952: -------------------------------------------------------------------------------------
2953: PROCEDURE find_party_details (
2954: p_rule_id IN NUMBER,
2955: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2956: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2957: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2958: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2959: p_restrict_sql IN VARCHAR2,

Line 2956: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

2952: -------------------------------------------------------------------------------------
2953: PROCEDURE find_party_details (
2954: p_rule_id IN NUMBER,
2955: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2956: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2957: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2958: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2959: p_restrict_sql IN VARCHAR2,
2960: p_match_type IN VARCHAR2,

Line 2957: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

2953: PROCEDURE find_party_details (
2954: p_rule_id IN NUMBER,
2955: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2956: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2957: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2958: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2959: p_restrict_sql IN VARCHAR2,
2960: p_match_type IN VARCHAR2,
2961: p_search_merged IN VARCHAR2,

Line 2958: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

2954: p_rule_id IN NUMBER,
2955: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2956: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2957: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2958: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2959: p_restrict_sql IN VARCHAR2,
2960: p_match_type IN VARCHAR2,
2961: p_search_merged IN VARCHAR2,
2962: x_search_ctx_id OUT NUMBER,

Line 3018: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

3014: x_dup_set_id OUT NUMBER,
3015: x_search_ctx_id OUT NUMBER,
3016: x_num_matches OUT NUMBER
3017: ) IS
3018: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3019: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3020: l_contact_list HZ_PARTY_SEARCH.contact_list;
3021: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3022: l_match_idx NUMBER;

Line 3019: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3015: x_search_ctx_id OUT NUMBER,
3016: x_num_matches OUT NUMBER
3017: ) IS
3018: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3019: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3020: l_contact_list HZ_PARTY_SEARCH.contact_list;
3021: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3022: l_match_idx NUMBER;
3023:

Line 3020: l_contact_list HZ_PARTY_SEARCH.contact_list;

3016: x_num_matches OUT NUMBER
3017: ) IS
3018: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3019: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3020: l_contact_list HZ_PARTY_SEARCH.contact_list;
3021: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3022: l_match_idx NUMBER;
3023:
3024: BEGIN

Line 3021: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

3017: ) IS
3018: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3019: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3020: l_contact_list HZ_PARTY_SEARCH.contact_list;
3021: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3022: l_match_idx NUMBER;
3023:
3024: BEGIN
3025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

3101: x_search_ctx_id OUT NUMBER,
3102: x_num_matches OUT NUMBER
3103: ) IS
3104:
3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3102: x_num_matches OUT NUMBER
3103: ) IS
3104:
3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 3107: l_contact_list HZ_PARTY_SEARCH.contact_list;

3103: ) IS
3104:
3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

3104:
3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;

Line 3109: contact_point_ids HZ_PARTY_SEARCH.IDList;

3105: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;
3113: cursor get_cpts_for_party_sites is select contact_point_id

Line 3110: p_party_site_list HZ_PARTY_SEARCH.IDList;

3106: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;
3113: cursor get_cpts_for_party_sites is select contact_point_id
3114: from hz_contact_points

Line 3111: p_contact_ids HZ_PARTY_SEARCH.IDList;

3107: l_contact_list HZ_PARTY_SEARCH.contact_list;
3108: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3109: contact_point_ids HZ_PARTY_SEARCH.IDList;
3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;
3113: cursor get_cpts_for_party_sites is select contact_point_id
3114: from hz_contact_points
3115: where owner_table_name = 'HZ_PARTY_SITES'

Line 3140: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

3136:
3137: get_search_criteria (
3138: null,
3139: p_party_site_list,
3140: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3141: contact_point_ids,
3142: l_party_search_rec,
3143: l_party_site_list,
3144: l_contact_list,

Line 3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

3189: x_search_ctx_id OUT NUMBER,
3190: x_num_matches OUT NUMBER
3191: ) IS
3192:
3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3190: x_num_matches OUT NUMBER
3191: ) IS
3192:
3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 3195: l_contact_list HZ_PARTY_SEARCH.contact_list;

3191: ) IS
3192:
3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

3192:
3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;

Line 3197: contact_point_ids HZ_PARTY_SEARCH.IDList;

3193: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;
3201: cursor get_cpt_for_contact_id is select contact_point_id

Line 3198: p_party_site_list HZ_PARTY_SEARCH.IDList;

3194: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;
3201: cursor get_cpt_for_contact_id is select contact_point_id
3202: from hz_org_contacts a, hz_relationships b, hz_contact_points c

Line 3199: p_contact_ids HZ_PARTY_SEARCH.IDList;

3195: l_contact_list HZ_PARTY_SEARCH.contact_list;
3196: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3197: contact_point_ids HZ_PARTY_SEARCH.IDList;
3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;
3201: cursor get_cpt_for_contact_id is select contact_point_id
3202: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3203: where a.party_relationship_id = b.relationship_id

Line 3230: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

3226: CLOSE get_cpt_for_contact_id;
3227:
3228: get_search_criteria (
3229: null,
3230: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3231: p_contact_ids,
3232: contact_point_ids,
3233: l_party_search_rec,
3234: l_party_site_list,

Line 3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

3280: p_match_type IN VARCHAR2,
3281: x_search_ctx_id OUT NUMBER,
3282: x_num_matches OUT NUMBER
3283: ) IS
3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3281: x_search_ctx_id OUT NUMBER,
3282: x_num_matches OUT NUMBER
3283: ) IS
3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 3286: l_contact_list HZ_PARTY_SEARCH.contact_list;

3282: x_num_matches OUT NUMBER
3283: ) IS
3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;
3290: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

3283: ) IS
3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;
3290: p_contact_ids HZ_PARTY_SEARCH.IDList;
3291: l_match_idx NUMBER;

Line 3288: contact_point_ids HZ_PARTY_SEARCH.IDList;

3284: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;
3290: p_contact_ids HZ_PARTY_SEARCH.IDList;
3291: l_match_idx NUMBER;
3292:

Line 3289: p_party_site_list HZ_PARTY_SEARCH.IDList;

3285: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;
3290: p_contact_ids HZ_PARTY_SEARCH.IDList;
3291: l_match_idx NUMBER;
3292:
3293: BEGIN

Line 3290: p_contact_ids HZ_PARTY_SEARCH.IDList;

3286: l_contact_list HZ_PARTY_SEARCH.contact_list;
3287: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3288: contact_point_ids HZ_PARTY_SEARCH.IDList;
3289: p_party_site_list HZ_PARTY_SEARCH.IDList;
3290: p_contact_ids HZ_PARTY_SEARCH.IDList;
3291: l_match_idx NUMBER;
3292:
3293: BEGIN
3294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3307: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

3303: END IF;
3304: contact_point_ids(1) := p_contact_point_id;
3305: get_search_criteria (
3306: null,
3307: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3308: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3309: contact_point_ids,
3310: l_party_search_rec,
3311: l_party_site_list,

Line 3308: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

3304: contact_point_ids(1) := p_contact_point_id;
3305: get_search_criteria (
3306: null,
3307: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3308: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3309: contact_point_ids,
3310: l_party_search_rec,
3311: l_party_site_list,
3312: l_contact_list,

Line 3467: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

3463: ) IS
3464: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
3465: l_match_idx NUMBER;
3466: AttrVals AttrList;
3467: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3468: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3469: l_contact_list HZ_PARTY_SEARCH.contact_list;
3470: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3471: l_dup_set_id NUMBER;

Line 3468: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3464: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
3465: l_match_idx NUMBER;
3466: AttrVals AttrList;
3467: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3468: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3469: l_contact_list HZ_PARTY_SEARCH.contact_list;
3470: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3471: l_dup_set_id NUMBER;
3472: l_idx NUMBER;

Line 3469: l_contact_list HZ_PARTY_SEARCH.contact_list;

3465: l_match_idx NUMBER;
3466: AttrVals AttrList;
3467: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3468: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3469: l_contact_list HZ_PARTY_SEARCH.contact_list;
3470: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3471: l_dup_set_id NUMBER;
3472: l_idx NUMBER;
3473: l_cpt_type VARCHAR2(255);

Line 3470: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

3466: AttrVals AttrList;
3467: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3468: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3469: l_contact_list HZ_PARTY_SEARCH.contact_list;
3470: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3471: l_dup_set_id NUMBER;
3472: l_idx NUMBER;
3473: l_cpt_type VARCHAR2(255);
3474: FIRST BOOLEAN := TRUE;

Line 3746: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,

3742:
3743: PROCEDURE get_matching_party_sites (
3744: p_rule_id IN NUMBER,
3745: p_party_id IN NUMBER,
3746: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
3747: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3748: p_restrict_sql IN VARCHAR2,
3749: p_match_type IN VARCHAR2,
3750: p_dup_party_site_id IN NUMBER,

Line 3747: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

3743: PROCEDURE get_matching_party_sites (
3744: p_rule_id IN NUMBER,
3745: p_party_id IN NUMBER,
3746: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
3747: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3748: p_restrict_sql IN VARCHAR2,
3749: p_match_type IN VARCHAR2,
3750: p_dup_party_site_id IN NUMBER,
3751: x_search_ctx_id OUT NUMBER,

Line 3780: H_SCORES HZ_PARTY_SEARCH.score_list;

3776: l_TX5 VARCHAR2(2000);
3777: l_TX10 VARCHAR2(2000);
3778: l_TX14 VARCHAR2(2000);
3779: l_TX7 VARCHAR2(2000);
3780: H_SCORES HZ_PARTY_SEARCH.score_list;
3781:
3782: l_score NUMBER;
3783: l_idx NUMBER;
3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 3831: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, p_party_site_list, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);

3827: ELSIF p_match_type = 'OR' THEN
3828: l_match_str := ' OR ';
3829: END IF;
3830: SAVEPOINT get_matching_party_sites ;
3831: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, p_party_site_list, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3832: g_score_until_thresh := false;
3833: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3834:
3835: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

Line 3837: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,p_party_site_list,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);

3833: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3834:
3835: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3836: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3837: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,p_party_site_list,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
3838:
3839: -- Setup Search Context ID
3840: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3841: x_search_ctx_id := l_search_ctx_id;

Line 3974: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,

3970:
3971: PROCEDURE get_matching_contacts (
3972: p_rule_id IN NUMBER,
3973: p_party_id IN NUMBER,
3974: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
3975: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3976: p_restrict_sql IN VARCHAR2,
3977: p_match_type IN VARCHAR2,
3978: p_dup_contact_id IN NUMBER,

Line 3975: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

3971: PROCEDURE get_matching_contacts (
3972: p_rule_id IN NUMBER,
3973: p_party_id IN NUMBER,
3974: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
3975: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3976: p_restrict_sql IN VARCHAR2,
3977: p_match_type IN VARCHAR2,
3978: p_dup_contact_id IN NUMBER,
3979: x_search_ctx_id OUT NUMBER,

Line 4007: H_SCORES HZ_PARTY_SEARCH.score_list;

4003: l_TX158 VARCHAR2(2000);
4004: l_TX5 VARCHAR2(2000);
4005: l_TX10 VARCHAR2(2000);
4006: l_TX7 VARCHAR2(2000);
4007: H_SCORES HZ_PARTY_SEARCH.score_list;
4008:
4009: l_score NUMBER;
4010: l_idx NUMBER;
4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 4057: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, p_contact_list, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);

4053: ELSIF p_match_type = 'OR' THEN
4054: l_match_str := ' OR ';
4055: END IF;
4056: SAVEPOINT get_matching_contacts ;
4057: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, p_contact_list, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4058: g_score_until_thresh := false;
4059: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4060:
4061: l_contact_contains_str := check_contacts_bulk (p_contact_list);

Line 4063: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,p_contact_list,p_contact_point_list);

4059: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4060:
4061: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4062: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4063: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,p_contact_list,p_contact_point_list);
4064:
4065: -- Setup Search Context ID
4066: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4067: x_search_ctx_id := l_search_ctx_id;

Line 4197: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

4193:
4194: PROCEDURE get_matching_contact_points (
4195: p_rule_id IN NUMBER,
4196: p_party_id IN NUMBER,
4197: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4198: p_restrict_sql IN VARCHAR2,
4199: p_match_type IN VARCHAR2,
4200: p_dup_contact_point_id IN NUMBER,
4201: x_search_ctx_id OUT NUMBER,

Line 4229: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

4225: l_cpt_party_id NUMBER;
4226: l_cpt_ps_id NUMBER;
4227: l_cpt_contact_id NUMBER;
4228: l_contact_pt_id NUMBER;
4229: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4230: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4231: H_SCORE HZ_PARTY_SEARCH.IDList;
4232:
4233: cnt NUMBER :=0;

Line 4230: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;

4226: l_cpt_ps_id NUMBER;
4227: l_cpt_contact_id NUMBER;
4228: l_contact_pt_id NUMBER;
4229: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4230: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4231: H_SCORE HZ_PARTY_SEARCH.IDList;
4232:
4233: cnt NUMBER :=0;
4234: l_party_max_score NUMBER;

Line 4231: H_SCORE HZ_PARTY_SEARCH.IDList;

4227: l_cpt_contact_id NUMBER;
4228: l_contact_pt_id NUMBER;
4229: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4230: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4231: H_SCORE HZ_PARTY_SEARCH.IDList;
4232:
4233: cnt NUMBER :=0;
4234: l_party_max_score NUMBER;
4235: l_ps_max_score NUMBER;

Line 4261: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,

4257: ELSIF p_match_type = 'OR' THEN
4258: l_match_str := ' OR ';
4259: END IF;
4260: SAVEPOINT get_matching_contact_points ;
4261: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4262: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4263: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4264: g_score_until_thresh := false;
4265: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;

Line 4262: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

4258: l_match_str := ' OR ';
4259: END IF;
4260: SAVEPOINT get_matching_contact_points ;
4261: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4262: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4263: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4264: g_score_until_thresh := false;
4265: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4266:

Line 4268: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);

4264: g_score_until_thresh := false;
4265: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4266:
4267: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4268: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
4269:
4270: -- Setup Search Context ID
4271: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4272: x_search_ctx_id := l_search_ctx_id;

Line 4347: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

4343:
4344: PROCEDURE get_score_details (
4345: p_rule_id IN NUMBER,
4346: p_party_id IN NUMBER,
4347: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4348: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4349: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4350: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4351: x_search_ctx_id IN OUT NUMBER

Line 4348: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

4344: PROCEDURE get_score_details (
4345: p_rule_id IN NUMBER,
4346: p_party_id IN NUMBER,
4347: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4348: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4349: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4350: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4351: x_search_ctx_id IN OUT NUMBER
4352: ) IS

Line 4349: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

4345: p_rule_id IN NUMBER,
4346: p_party_id IN NUMBER,
4347: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4348: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4349: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4350: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4351: x_search_ctx_id IN OUT NUMBER
4352: ) IS
4353:

Line 4350: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

4346: p_party_id IN NUMBER,
4347: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4348: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4349: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4350: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4351: x_search_ctx_id IN OUT NUMBER
4352: ) IS
4353:
4354: -- Strings to hold the generated Intermedia query strings

Line 4395: H_SCORES HZ_PARTY_SEARCH.score_list;

4391: l_TX14 VARCHAR2(2000);
4392: l_max_TX14 VARCHAR2(2000);
4393: l_TX7 VARCHAR2(2000);
4394: l_max_TX7 VARCHAR2(2000);
4395: H_SCORES HZ_PARTY_SEARCH.score_list;
4396:
4397: l_score NUMBER;
4398: l_match_idx NUMBER;
4399: l_idx NUMBER;

Line 4577: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

4573: ************************************************/
4574:
4575: PROCEDURE get_party_for_search (
4576: p_party_id IN NUMBER,
4577: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4578: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS

Line 4578: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

4574:
4575: PROCEDURE get_party_for_search (
4576: p_party_id IN NUMBER,
4577: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4578: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS
4582: l_party_id NUMBER;

Line 4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

4575: PROCEDURE get_party_for_search (
4576: p_party_id IN NUMBER,
4577: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4578: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS
4582: l_party_id NUMBER;
4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;

Line 4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4576: p_party_id IN NUMBER,
4577: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4578: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS
4582: l_party_id NUMBER;
4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4584: l_contact_ids HZ_PARTY_SEARCH.IDList;

Line 4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;

4579: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS
4582: l_party_id NUMBER;
4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4584: l_contact_ids HZ_PARTY_SEARCH.IDList;
4585: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4586: ps NUMBER :=1;
4587: cpt NUMBER :=1;

Line 4584: l_contact_ids HZ_PARTY_SEARCH.IDList;

4580: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4581: ) IS
4582: l_party_id NUMBER;
4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4584: l_contact_ids HZ_PARTY_SEARCH.IDList;
4585: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4586: ps NUMBER :=1;
4587: cpt NUMBER :=1;
4588: ct NUMBER :=1;

Line 4585: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;

4581: ) IS
4582: l_party_id NUMBER;
4583: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4584: l_contact_ids HZ_PARTY_SEARCH.IDList;
4585: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4586: ps NUMBER :=1;
4587: cpt NUMBER :=1;
4588: ct NUMBER :=1;
4589: l_use_contact_info varchar2(1);

Line 4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

4686: END get_party_for_search;
4687:
4688: PROCEDURE get_search_criteria (
4689: p_party_id IN NUMBER,
4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

4687:
4688: PROCEDURE get_search_criteria (
4689: p_party_id IN NUMBER,
4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

Line 4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,

4688: PROCEDURE get_search_criteria (
4689: p_party_id IN NUMBER,
4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

Line 4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

4689: p_party_id IN NUMBER,
4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4697: ) IS

Line 4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

4690: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4697: ) IS
4698: BEGIN

Line 4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

4691: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4697: ) IS
4698: BEGIN
4699:

Line 4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4692: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4693: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4694: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4695: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4696: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4697: ) IS
4698: BEGIN
4699:
4700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4748: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type

4744: ************************************************/
4745:
4746: PROCEDURE get_party_rec (
4747: p_party_id IN NUMBER,
4748: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
4749: ) IS
4750: l_party_type VARCHAR2(255);
4751: BEGIN
4752:

Line 4815: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

4811: the party site search record structure
4812: ************************************************/
4813:
4814: PROCEDURE get_party_site_rec (
4815: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4816: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4817: ) IS
4818: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4819: SELECT party_site_id

Line 4816: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list

4812: ************************************************/
4813:
4814: PROCEDURE get_party_site_rec (
4815: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4816: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4817: ) IS
4818: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4819: SELECT party_site_id
4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')

Line 4877: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

4873: the contact search record structure
4874: ************************************************/
4875:
4876: PROCEDURE get_contact_rec (
4877: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4878: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4879: ) IS
4880: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4881: SELECT org_contact_id

Line 4878: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list

4874: ************************************************/
4875:
4876: PROCEDURE get_contact_rec (
4877: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4878: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4879: ) IS
4880: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4881: SELECT org_contact_id
4882: ,translate(HZ_ORG_CONTACTS.JOB_TITLE, '%',' ')

Line 4937: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,

4933: the contact point search record structure
4934: ************************************************/
4935:
4936: PROCEDURE get_contact_point_rec (
4937: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
4938: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4939: ) IS
4940:
4941: -- Cursor to fetch primary contact points for party

Line 4938: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4934: ************************************************/
4935:
4936: PROCEDURE get_contact_point_rec (
4937: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
4938: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4939: ) IS
4940:
4941: -- Cursor to fetch primary contact points for party
4942: CURSOR c_cpts(cp_contact_point_id NUMBER) IS

Line 4998: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

4994: ************************************************/
4995:
4996: PROCEDURE MAP_PARTY_REC(
4997: p_search_ctx IN BOOLEAN,
4998: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4999: x_entered_max_score OUT NUMBER,
5000: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5001: ) IS
5002: tmp VARCHAR2(4000);

Line 5127: p_search_list IN HZ_PARTY_SEARCH.party_site_list,

5123: ************************************************/
5124:
5125: PROCEDURE MAP_PARTY_SITE_REC(
5126: p_search_ctx IN BOOLEAN,
5127: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5128: x_entered_max_score OUT NUMBER,
5129: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5130: ) IS
5131: l_current_max_score NUMBER;

Line 5280: p_search_list IN HZ_PARTY_SEARCH.contact_list,

5276: ************************************************/
5277:
5278: PROCEDURE MAP_CONTACT_REC(
5279: p_search_ctx IN BOOLEAN,
5280: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5281: x_entered_max_score OUT NUMBER,
5282: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5283: ) IS
5284: l_current_max_score NUMBER;

Line 5381: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,

5377: ************************************************/
5378:
5379: PROCEDURE MAP_CONTACT_POINT_REC(
5380: p_search_ctx IN BOOLEAN,
5381: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5382: x_entered_max_score OUT NUMBER,
5383: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5384: ) IS
5385: l_current_max_score NUMBER;

Line 5498: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

5494: 2. Contact Point Type is not null for each condition
5495: ************************************************/
5496:
5497: FUNCTION check_prim_cond(
5498: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5499: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5500: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5501: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5502: RETURN BOOLEAN IS

Line 5499: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

5495: ************************************************/
5496:
5497: FUNCTION check_prim_cond(
5498: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5499: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5500: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5501: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5502: RETURN BOOLEAN IS
5503: BEGIN

Line 5500: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

5496:
5497: FUNCTION check_prim_cond(
5498: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5499: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5500: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5501: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5502: RETURN BOOLEAN IS
5503: BEGIN
5504: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5501: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)

5497: FUNCTION check_prim_cond(
5498: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5499: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5500: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5501: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5502: RETURN BOOLEAN IS
5503: BEGIN
5504: FOR I IN 1..p_contact_point_list.COUNT LOOP
5505: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (

Line 5568: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

5564: has party site criteria.
5565: ************************************************/
5566:
5567: PROCEDURE check_party_site_cond(
5568: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5569: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5570: x_secondary OUT BOOLEAN,
5571: x_primary OUT BOOLEAN
5572: ) IS

Line 5569: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5565: ************************************************/
5566:
5567: PROCEDURE check_party_site_cond(
5568: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5569: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5570: x_secondary OUT BOOLEAN,
5571: x_primary OUT BOOLEAN
5572: ) IS
5573: BEGIN

Line 5628: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

5624: has contact criteria.
5625: ************************************************/
5626:
5627: PROCEDURE check_contact_cond(
5628: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5629: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5630: x_secondary OUT BOOLEAN,
5631: x_primary OUT BOOLEAN
5632: ) IS

Line 5629: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5625: ************************************************/
5626:
5627: PROCEDURE check_contact_cond(
5628: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5629: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5630: x_secondary OUT BOOLEAN,
5631: x_primary OUT BOOLEAN
5632: ) IS
5633: BEGIN

Line 5687: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5683: has valid contact point criteria.
5684: ************************************************/
5685:
5686: PROCEDURE check_contact_point_cond(
5687: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5688: x_secondary OUT BOOLEAN,
5689: x_primary OUT BOOLEAN
5690: ) IS
5691: BEGIN