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_51 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 78: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list

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

Line 108: p_contact_list IN HZ_PARTY_SEARCH.contact_list

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

Line 133: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list

129: has contact criteria.
130: ************************************************/
131:
132: FUNCTION check_cpts_bulk (
133: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list
134: )
135: RETURN VARCHAR2 IS
136: x_primary boolean := FALSE;
137: BEGIN

Line 440: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type

436: PROCEDURE INSERT_PARTY_SCORE (
437: p_party_id IN NUMBER
438: ,p_record_id IN NUMBER
439: ,p_search_ctx_id IN NUMBER
440: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
441: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
442: ,p_table_TX2 VARCHAR2
443: ,p_table_TX59 VARCHAR2
444: ,p_table_TX45 VARCHAR2

Line 515: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type

511: PROCEDURE INSERT_PARTY_SITES_SCORE (
512: p_party_id IN NUMBER
513: ,p_record_id IN NUMBER
514: ,p_search_ctx_id IN NUMBER
515: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
516: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
517: ,p_table_TX26 VARCHAR2
518: ,p_table_TX9 VARCHAR2
519: ,p_table_TX14 VARCHAR2

Line 635: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type

631: PROCEDURE INSERT_CONTACTS_SCORE (
632: p_party_id IN NUMBER
633: ,p_record_id IN NUMBER
634: ,p_search_ctx_id IN NUMBER
635: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
636: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
637: ,p_idx IN NUMBER) IS
638: l_current_score NUMBER:=0;
639: l_score NUMBER;

Line 651: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type

647: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
648: p_party_id IN NUMBER
649: ,p_record_id IN NUMBER
650: ,p_search_ctx_id IN NUMBER
651: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
652: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
653: ,p_table_TX5 VARCHAR2
654: ,p_table_TX158 VARCHAR2
655: ,p_table_TX10 VARCHAR2

Line 729: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type

725: for the PARTY Entity
726: ************************************************/
727:
728: PROCEDURE POP_PARTY_COND_REC(
729: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
730: ) IS
731: BEGIN
732: NULL ;
733: EXCEPTION

Line 749: p_search_list IN HZ_PARTY_SEARCH.party_site_list

745: for the PARTY_SITES Entity
746: ************************************************/
747:
748: PROCEDURE POP_PARTY_SITES_COND_REC(
749: p_search_list IN HZ_PARTY_SEARCH.party_site_list
750: ) IS
751: BEGIN
752: ---------POPULATE THE GLOBAL WORD CONDITION REC FOR PARTY_SITES-------------
753: ------ Populate global condition record only if search list is not empty -----------

Line 774: p_search_list IN HZ_PARTY_SEARCH.contact_list

770: for the CONTACTS Entity
771: ************************************************/
772:
773: PROCEDURE POP_CONTACTS_COND_REC(
774: p_search_list IN HZ_PARTY_SEARCH.contact_list
775: ) IS
776: BEGIN
777: NULL ;
778: EXCEPTION

Line 794: p_search_list IN HZ_PARTY_SEARCH.contact_point_list

790: for the CONTACT_POINTS Entity
791: ************************************************/
792:
793: PROCEDURE POP_CONTACT_POINTS_COND_REC(
794: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
795: ) IS
796: BEGIN
797: NULL ;
798: EXCEPTION

Line 808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END;
806:
807: PROCEDURE init_score_context (
808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

Line 809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,

805: END;
806:
807: PROCEDURE init_score_context (
808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

Line 810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=

806:
807: PROCEDURE init_score_context (
808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

Line 811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,

807: PROCEDURE init_score_context (
808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST

Line 812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
816: ) IS

Line 813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

809: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
816: ) IS
817: l_dummy NUMBER;

Line 814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

810: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
816: ) IS
817: l_dummy NUMBER;
818: BEGIN

Line 815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST

811: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
812: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
813: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
814: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
815: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
816: ) IS
817: l_dummy NUMBER;
818: BEGIN
819: -- Transform search criteria

Line 828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

824: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
825:
826: END;
827: FUNCTION init_search(
828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

Line 829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,

825:
826: END;
827: FUNCTION init_search(
828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

Line 830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=

826: END;
827: FUNCTION init_search(
828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

Line 831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,

827: FUNCTION init_search(
828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,

Line 832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=

828: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
836: p_match_type IN VARCHAR2,

Line 833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

829: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
836: p_match_type IN VARCHAR2,
837: x_party_max_score OUT NUMBER,

Line 834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=

830: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
836: p_match_type IN VARCHAR2,
837: x_party_max_score OUT NUMBER,
838: x_ps_max_score OUT NUMBER,

Line 835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,

831: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
832: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
833: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
834: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
835: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
836: p_match_type IN VARCHAR2,
837: x_party_max_score OUT NUMBER,
838: x_ps_max_score OUT NUMBER,
839: x_contact_max_score OUT NUMBER,

Line 847: maxscore HZ_PARTY_SEARCH.IDList;

843: l_ps_entered_max_score NUMBER:=0;
844: l_ct_entered_max_score NUMBER:=0;
845: l_cpt_entered_max_score NUMBER:=0;
846: vlist vlisttype;
847: maxscore HZ_PARTY_SEARCH.IDList;
848: l_name VARCHAR2(200);
849: l_idx NUMBER;
850: l_num NUMBER;
851: total NUMBER;

Line 1284: RETURN HZ_PARTY_SEARCH.score_rec IS

1280: p_party_id NUMBER,
1281: p_party_site_id NUMBER,
1282: p_org_contact_id NUMBER,
1283: p_contact_point_id NUMBER)
1284: RETURN HZ_PARTY_SEARCH.score_rec IS
1285: l_score_rec HZ_PARTY_SEARCH.score_rec;
1286: BEGIN
1287: l_score_rec.TOTAL_SCORE := p_init_total_score;
1288: l_score_rec.PARTY_SCORE := p_init_party_score;

Line 1285: l_score_rec HZ_PARTY_SEARCH.score_rec;

1281: p_party_site_id NUMBER,
1282: p_org_contact_id NUMBER,
1283: p_contact_point_id NUMBER)
1284: RETURN HZ_PARTY_SEARCH.score_rec IS
1285: l_score_rec HZ_PARTY_SEARCH.score_rec;
1286: BEGIN
1287: l_score_rec.TOTAL_SCORE := p_init_total_score;
1288: l_score_rec.PARTY_SCORE := p_init_party_score;
1289: l_score_rec.PARTY_SITE_SCORE := p_init_party_site_score;

Line 1316: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

1312: -------------------- BULK MATCH RULE ::: find_parties ------------------------------
1313: -------------------------------------------------------------------------------------
1314: PROCEDURE find_parties (
1315: p_rule_id IN NUMBER,
1316: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1317: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1318: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1319: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1320: p_restrict_sql IN VARCHAR2,

Line 1317: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

1313: -------------------------------------------------------------------------------------
1314: PROCEDURE find_parties (
1315: p_rule_id IN NUMBER,
1316: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1317: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1318: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1319: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1320: p_restrict_sql IN VARCHAR2,
1321: p_match_type IN VARCHAR2,

Line 1318: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

1314: PROCEDURE find_parties (
1315: p_rule_id IN NUMBER,
1316: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1317: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1318: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1319: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1320: p_restrict_sql IN VARCHAR2,
1321: p_match_type IN VARCHAR2,
1322: p_search_merged IN VARCHAR2,

Line 1319: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

1315: p_rule_id IN NUMBER,
1316: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1317: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1318: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1319: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1320: p_restrict_sql IN VARCHAR2,
1321: p_match_type IN VARCHAR2,
1322: p_search_merged IN VARCHAR2,
1323: p_dup_party_id IN NUMBER,

Line 1361: H_SCORES HZ_PARTY_SEARCH.score_list;

1357: l_TX10 VARCHAR2(2000);
1358: l_TX59 VARCHAR2(2000);
1359: l_TX45 VARCHAR2(2000);
1360: l_TX14 VARCHAR2(2000);
1361: H_SCORES HZ_PARTY_SEARCH.score_list;
1362: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1363: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1364:
1365: l_score NUMBER;

Line 1362: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

1358: l_TX59 VARCHAR2(2000);
1359: l_TX45 VARCHAR2(2000);
1360: l_TX14 VARCHAR2(2000);
1361: H_SCORES HZ_PARTY_SEARCH.score_list;
1362: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1363: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1364:
1365: l_score NUMBER;
1366: l_idx NUMBER;

Line 1363: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;

1359: l_TX45 VARCHAR2(2000);
1360: l_TX14 VARCHAR2(2000);
1361: H_SCORES HZ_PARTY_SEARCH.score_list;
1362: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1363: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1364:
1365: l_score NUMBER;
1366: l_idx NUMBER;
1367: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 1404: h_ps_id HZ_PARTY_SEARCH.IDList;

1400: l_use_contact_cpt_info BOOLEAN := TRUE;
1401: l_use_contact_addr_flag VARCHAR2(1) := 'Y';
1402: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1403:
1404: h_ps_id HZ_PARTY_SEARCH.IDList;
1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;

Line 1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;

1401: l_use_contact_addr_flag VARCHAR2(1) := 'Y';
1402: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1403:
1404: h_ps_id HZ_PARTY_SEARCH.IDList;
1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;

Line 1406: h_ps_score HZ_PARTY_SEARCH.IDList;

1402: l_use_contact_cpt_flag VARCHAR2(1) := 'Y';
1403:
1404: h_ps_id HZ_PARTY_SEARCH.IDList;
1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;

Line 1407: h_ct_id HZ_PARTY_SEARCH.IDList;

1403:
1404: h_ps_id HZ_PARTY_SEARCH.IDList;
1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

Line 1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;

1404: h_ps_id HZ_PARTY_SEARCH.IDList;
1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1412: h_cpt_score HZ_PARTY_SEARCH.IDList;

Line 1409: h_ct_score HZ_PARTY_SEARCH.IDList;

1405: h_ps_party_id HZ_PARTY_SEARCH.IDList;
1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1412: h_cpt_score HZ_PARTY_SEARCH.IDList;
1413: detcnt NUMBER := 1;

Line 1410: h_cpt_id HZ_PARTY_SEARCH.IDList;

1406: h_ps_score HZ_PARTY_SEARCH.IDList;
1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1412: h_cpt_score HZ_PARTY_SEARCH.IDList;
1413: detcnt NUMBER := 1;
1414:

Line 1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

1407: h_ct_id HZ_PARTY_SEARCH.IDList;
1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1412: h_cpt_score HZ_PARTY_SEARCH.IDList;
1413: detcnt NUMBER := 1;
1414:
1415:

Line 1412: h_cpt_score HZ_PARTY_SEARCH.IDList;

1408: h_ct_party_id HZ_PARTY_SEARCH.IDList;
1409: h_ct_score HZ_PARTY_SEARCH.IDList;
1410: h_cpt_id HZ_PARTY_SEARCH.IDList;
1411: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
1412: h_cpt_score HZ_PARTY_SEARCH.IDList;
1413: detcnt NUMBER := 1;
1414:
1415:
1416: /********************* Find Parties private procedures *******/

Line 1943: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

1939: -------------------- BULK MATCH RULE ::: find_persons ------------------------------
1940: -------------------------------------------------------------------------------------
1941: PROCEDURE find_persons (
1942: p_rule_id IN NUMBER,
1943: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1944: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1945: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1946: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1947: p_restrict_sql IN VARCHAR2,

Line 1944: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

1940: -------------------------------------------------------------------------------------
1941: PROCEDURE find_persons (
1942: p_rule_id IN NUMBER,
1943: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1944: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1945: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1946: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1947: p_restrict_sql IN VARCHAR2,
1948: p_match_type IN VARCHAR2,

Line 1945: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

1941: PROCEDURE find_persons (
1942: p_rule_id IN NUMBER,
1943: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1944: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1945: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1946: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1947: p_restrict_sql IN VARCHAR2,
1948: p_match_type IN VARCHAR2,
1949: p_search_merged IN VARCHAR2,

Line 1946: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

1942: p_rule_id IN NUMBER,
1943: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1944: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1945: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1946: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1947: p_restrict_sql IN VARCHAR2,
1948: p_match_type IN VARCHAR2,
1949: p_search_merged IN VARCHAR2,
1950: p_ins_details IN VARCHAR2,

Line 1985: H_SCORES HZ_PARTY_SEARCH.score_list;

1981: l_TX10 VARCHAR2(2000);
1982: l_TX59 VARCHAR2(2000);
1983: l_TX45 VARCHAR2(2000);
1984: l_TX14 VARCHAR2(2000);
1985: H_SCORES HZ_PARTY_SEARCH.score_list;
1986: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1987: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1988:
1989: l_score NUMBER;

Line 1986: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

1982: l_TX59 VARCHAR2(2000);
1983: l_TX45 VARCHAR2(2000);
1984: l_TX14 VARCHAR2(2000);
1985: H_SCORES HZ_PARTY_SEARCH.score_list;
1986: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1987: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1988:
1989: l_score NUMBER;
1990: l_idx NUMBER;

Line 1987: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;

1983: l_TX45 VARCHAR2(2000);
1984: l_TX14 VARCHAR2(2000);
1985: H_SCORES HZ_PARTY_SEARCH.score_list;
1986: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1987: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1988:
1989: l_score NUMBER;
1990: l_idx NUMBER;
1991: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 2022: h_ps_id HZ_PARTY_SEARCH.IDList;

2018: l_tmp NUMBER;
2019: l_merge_flag VARCHAR2(1);
2020: l_num_eval NUMBER:=0;
2021:
2022: h_ps_id HZ_PARTY_SEARCH.IDList;
2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;

Line 2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;

2019: l_merge_flag VARCHAR2(1);
2020: l_num_eval NUMBER:=0;
2021:
2022: h_ps_id HZ_PARTY_SEARCH.IDList;
2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;

Line 2024: h_ps_score HZ_PARTY_SEARCH.IDList;

2020: l_num_eval NUMBER:=0;
2021:
2022: h_ps_id HZ_PARTY_SEARCH.IDList;
2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;

Line 2025: h_ct_id HZ_PARTY_SEARCH.IDList;

2021:
2022: h_ps_id HZ_PARTY_SEARCH.IDList;
2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

Line 2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;

2022: h_ps_id HZ_PARTY_SEARCH.IDList;
2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2030: h_cpt_score HZ_PARTY_SEARCH.IDList;

Line 2027: h_ct_score HZ_PARTY_SEARCH.IDList;

2023: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2030: h_cpt_score HZ_PARTY_SEARCH.IDList;
2031: detcnt NUMBER := 1;

Line 2028: h_cpt_id HZ_PARTY_SEARCH.IDList;

2024: h_ps_score HZ_PARTY_SEARCH.IDList;
2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2030: h_cpt_score HZ_PARTY_SEARCH.IDList;
2031: detcnt NUMBER := 1;
2032: l_person_id NUMBER;

Line 2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;

2025: h_ct_id HZ_PARTY_SEARCH.IDList;
2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2030: h_cpt_score HZ_PARTY_SEARCH.IDList;
2031: detcnt NUMBER := 1;
2032: l_person_id NUMBER;
2033:

Line 2030: h_cpt_score HZ_PARTY_SEARCH.IDList;

2026: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2027: h_ct_score HZ_PARTY_SEARCH.IDList;
2028: h_cpt_id HZ_PARTY_SEARCH.IDList;
2029: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2030: h_cpt_score HZ_PARTY_SEARCH.IDList;
2031: detcnt NUMBER := 1;
2032: l_person_id NUMBER;
2033:
2034: /********************* Find Parties private procedures *******/

Line 2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END find_persons;
2589: PROCEDURE find_persons (
2590: p_rule_id IN NUMBER,
2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2592: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2593: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2595: p_restrict_sql IN VARCHAR2,

Line 2592: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

2588: END find_persons;
2589: PROCEDURE find_persons (
2590: p_rule_id IN NUMBER,
2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2592: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2593: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2595: p_restrict_sql IN VARCHAR2,
2596: p_match_type IN VARCHAR2,

Line 2593: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

2589: PROCEDURE find_persons (
2590: p_rule_id IN NUMBER,
2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2592: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2593: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2595: p_restrict_sql IN VARCHAR2,
2596: p_match_type IN VARCHAR2,
2597: p_ins_details IN VARCHAR2,

Line 2594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

2590: p_rule_id IN NUMBER,
2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2592: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2593: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2595: p_restrict_sql IN VARCHAR2,
2596: p_match_type IN VARCHAR2,
2597: p_ins_details IN VARCHAR2,
2598: x_search_ctx_id OUT NUMBER,

Line 2611: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

2607: -------------------- BULK MATCH RULE ::: find_party_details ------------------------
2608: -------------------------------------------------------------------------------------
2609: PROCEDURE find_party_details (
2610: p_rule_id IN NUMBER,
2611: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2612: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2613: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2614: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2615: p_restrict_sql IN VARCHAR2,

Line 2612: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

2608: -------------------------------------------------------------------------------------
2609: PROCEDURE find_party_details (
2610: p_rule_id IN NUMBER,
2611: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2612: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2613: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2614: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2615: p_restrict_sql IN VARCHAR2,
2616: p_match_type IN VARCHAR2,

Line 2613: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

2609: PROCEDURE find_party_details (
2610: p_rule_id IN NUMBER,
2611: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2612: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2613: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2614: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2615: p_restrict_sql IN VARCHAR2,
2616: p_match_type IN VARCHAR2,
2617: p_search_merged IN VARCHAR2,

Line 2614: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

2610: p_rule_id IN NUMBER,
2611: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2612: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2613: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2614: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2615: p_restrict_sql IN VARCHAR2,
2616: p_match_type IN VARCHAR2,
2617: p_search_merged IN VARCHAR2,
2618: x_search_ctx_id OUT NUMBER,

Line 2674: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

2670: x_dup_set_id OUT NUMBER,
2671: x_search_ctx_id OUT NUMBER,
2672: x_num_matches OUT NUMBER
2673: ) IS
2674: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
2675: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2676: l_contact_list HZ_PARTY_SEARCH.contact_list;
2677: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
2678: l_match_idx NUMBER;

Line 2675: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

2671: x_search_ctx_id OUT NUMBER,
2672: x_num_matches OUT NUMBER
2673: ) IS
2674: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
2675: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2676: l_contact_list HZ_PARTY_SEARCH.contact_list;
2677: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
2678: l_match_idx NUMBER;
2679:

Line 2676: l_contact_list HZ_PARTY_SEARCH.contact_list;

2672: x_num_matches OUT NUMBER
2673: ) IS
2674: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
2675: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2676: l_contact_list HZ_PARTY_SEARCH.contact_list;
2677: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
2678: l_match_idx NUMBER;
2679:
2680: BEGIN

Line 2677: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

2673: ) IS
2674: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
2675: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2676: l_contact_list HZ_PARTY_SEARCH.contact_list;
2677: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
2678: l_match_idx NUMBER;
2679:
2680: BEGIN
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

2757: x_search_ctx_id OUT NUMBER,
2758: x_num_matches OUT NUMBER
2759: ) IS
2760:
2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

2758: x_num_matches OUT NUMBER
2759: ) IS
2760:
2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 2763: l_contact_list HZ_PARTY_SEARCH.contact_list;

2759: ) IS
2760:
2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

2760:
2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;
2768: l_match_idx NUMBER;

Line 2765: contact_point_ids HZ_PARTY_SEARCH.IDList;

2761: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;
2768: l_match_idx NUMBER;
2769: cursor get_cpts_for_party_sites is select contact_point_id

Line 2766: p_party_site_list HZ_PARTY_SEARCH.IDList;

2762: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;
2768: l_match_idx NUMBER;
2769: cursor get_cpts_for_party_sites is select contact_point_id
2770: from hz_contact_points

Line 2767: p_contact_ids HZ_PARTY_SEARCH.IDList;

2763: l_contact_list HZ_PARTY_SEARCH.contact_list;
2764: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2765: contact_point_ids HZ_PARTY_SEARCH.IDList;
2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;
2768: l_match_idx NUMBER;
2769: cursor get_cpts_for_party_sites is select contact_point_id
2770: from hz_contact_points
2771: where owner_table_name = 'HZ_PARTY_SITES'

Line 2796: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

2792:
2793: get_search_criteria (
2794: null,
2795: p_party_site_list,
2796: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2797: contact_point_ids,
2798: l_party_search_rec,
2799: l_party_site_list,
2800: l_contact_list,

Line 2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

2845: x_search_ctx_id OUT NUMBER,
2846: x_num_matches OUT NUMBER
2847: ) IS
2848:
2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

2846: x_num_matches OUT NUMBER
2847: ) IS
2848:
2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 2851: l_contact_list HZ_PARTY_SEARCH.contact_list;

2847: ) IS
2848:
2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

2848:
2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;

Line 2853: contact_point_ids HZ_PARTY_SEARCH.IDList;

2849: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;
2857: cursor get_cpt_for_contact_id is select contact_point_id

Line 2854: p_party_site_list HZ_PARTY_SEARCH.IDList;

2850: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;
2857: cursor get_cpt_for_contact_id is select contact_point_id
2858: from hz_org_contacts a, hz_relationships b, hz_contact_points c

Line 2855: p_contact_ids HZ_PARTY_SEARCH.IDList;

2851: l_contact_list HZ_PARTY_SEARCH.contact_list;
2852: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2853: contact_point_ids HZ_PARTY_SEARCH.IDList;
2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;
2857: cursor get_cpt_for_contact_id is select contact_point_id
2858: from hz_org_contacts a, hz_relationships b, hz_contact_points c
2859: where a.party_relationship_id = b.relationship_id

Line 2886: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

2882: CLOSE get_cpt_for_contact_id;
2883:
2884: get_search_criteria (
2885: null,
2886: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2887: p_contact_ids,
2888: contact_point_ids,
2889: l_party_search_rec,
2890: l_party_site_list,

Line 2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

2936: p_match_type IN VARCHAR2,
2937: x_search_ctx_id OUT NUMBER,
2938: x_num_matches OUT NUMBER
2939: ) IS
2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;

Line 2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

2937: x_search_ctx_id OUT NUMBER,
2938: x_num_matches OUT NUMBER
2939: ) IS
2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;

Line 2942: l_contact_list HZ_PARTY_SEARCH.contact_list;

2938: x_num_matches OUT NUMBER
2939: ) IS
2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;
2946: p_contact_ids HZ_PARTY_SEARCH.IDList;

Line 2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

2939: ) IS
2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;
2946: p_contact_ids HZ_PARTY_SEARCH.IDList;
2947: l_match_idx NUMBER;

Line 2944: contact_point_ids HZ_PARTY_SEARCH.IDList;

2940: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;
2946: p_contact_ids HZ_PARTY_SEARCH.IDList;
2947: l_match_idx NUMBER;
2948:

Line 2945: p_party_site_list HZ_PARTY_SEARCH.IDList;

2941: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;
2946: p_contact_ids HZ_PARTY_SEARCH.IDList;
2947: l_match_idx NUMBER;
2948:
2949: BEGIN

Line 2946: p_contact_ids HZ_PARTY_SEARCH.IDList;

2942: l_contact_list HZ_PARTY_SEARCH.contact_list;
2943: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
2944: contact_point_ids HZ_PARTY_SEARCH.IDList;
2945: p_party_site_list HZ_PARTY_SEARCH.IDList;
2946: p_contact_ids HZ_PARTY_SEARCH.IDList;
2947: l_match_idx NUMBER;
2948:
2949: BEGIN
2950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2963: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

2959: END IF;
2960: contact_point_ids(1) := p_contact_point_id;
2961: get_search_criteria (
2962: null,
2963: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2964: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2965: contact_point_ids,
2966: l_party_search_rec,
2967: l_party_site_list,

Line 2964: HZ_PARTY_SEARCH.G_MISS_ID_LIST,

2960: contact_point_ids(1) := p_contact_point_id;
2961: get_search_criteria (
2962: null,
2963: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2964: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
2965: contact_point_ids,
2966: l_party_search_rec,
2967: l_party_site_list,
2968: l_contact_list,

Line 3123: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

3119: ) IS
3120: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
3121: l_match_idx NUMBER;
3122: AttrVals AttrList;
3123: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3124: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3125: l_contact_list HZ_PARTY_SEARCH.contact_list;
3126: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3127: l_dup_set_id NUMBER;

Line 3124: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

3120: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
3121: l_match_idx NUMBER;
3122: AttrVals AttrList;
3123: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3124: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3125: l_contact_list HZ_PARTY_SEARCH.contact_list;
3126: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3127: l_dup_set_id NUMBER;
3128: l_idx NUMBER;

Line 3125: l_contact_list HZ_PARTY_SEARCH.contact_list;

3121: l_match_idx NUMBER;
3122: AttrVals AttrList;
3123: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3124: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3125: l_contact_list HZ_PARTY_SEARCH.contact_list;
3126: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3127: l_dup_set_id NUMBER;
3128: l_idx NUMBER;
3129: l_cpt_type VARCHAR2(255);

Line 3126: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

3122: AttrVals AttrList;
3123: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3124: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3125: l_contact_list HZ_PARTY_SEARCH.contact_list;
3126: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3127: l_dup_set_id NUMBER;
3128: l_idx NUMBER;
3129: l_cpt_type VARCHAR2(255);
3130: FIRST BOOLEAN := TRUE;

Line 3350: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,

3346:
3347: PROCEDURE get_matching_party_sites (
3348: p_rule_id IN NUMBER,
3349: p_party_id IN NUMBER,
3350: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
3351: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3352: p_restrict_sql IN VARCHAR2,
3353: p_match_type IN VARCHAR2,
3354: p_dup_party_site_id IN NUMBER,

Line 3351: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

3347: PROCEDURE get_matching_party_sites (
3348: p_rule_id IN NUMBER,
3349: p_party_id IN NUMBER,
3350: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
3351: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3352: p_restrict_sql IN VARCHAR2,
3353: p_match_type IN VARCHAR2,
3354: p_dup_party_site_id IN NUMBER,
3355: x_search_ctx_id OUT NUMBER,

Line 3383: H_SCORES HZ_PARTY_SEARCH.score_list;

3379: l_TX158 VARCHAR2(2000);
3380: l_TX5 VARCHAR2(2000);
3381: l_TX10 VARCHAR2(2000);
3382: l_TX14 VARCHAR2(2000);
3383: H_SCORES HZ_PARTY_SEARCH.score_list;
3384:
3385: l_score NUMBER;
3386: l_idx NUMBER;
3387: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 3434: 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);

3430: ELSIF p_match_type = 'OR' THEN
3431: l_match_str := ' OR ';
3432: END IF;
3433: SAVEPOINT get_matching_party_sites ;
3434: 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);
3435: g_score_until_thresh := false;
3436: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3437:
3438: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

Line 3440: 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);

3436: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3437:
3438: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3439: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3440: 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);
3441:
3442: -- Setup Search Context ID
3443: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3444: x_search_ctx_id := l_search_ctx_id;

Line 3577: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,

3573:
3574: PROCEDURE get_matching_contacts (
3575: p_rule_id IN NUMBER,
3576: p_party_id IN NUMBER,
3577: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
3578: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3579: p_restrict_sql IN VARCHAR2,
3580: p_match_type IN VARCHAR2,
3581: p_dup_contact_id IN NUMBER,

Line 3578: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

3574: PROCEDURE get_matching_contacts (
3575: p_rule_id IN NUMBER,
3576: p_party_id IN NUMBER,
3577: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
3578: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3579: p_restrict_sql IN VARCHAR2,
3580: p_match_type IN VARCHAR2,
3581: p_dup_contact_id IN NUMBER,
3582: x_search_ctx_id OUT NUMBER,

Line 3606: H_SCORES HZ_PARTY_SEARCH.score_list;

3602:
3603: l_TX158 VARCHAR2(2000);
3604: l_TX5 VARCHAR2(2000);
3605: l_TX10 VARCHAR2(2000);
3606: H_SCORES HZ_PARTY_SEARCH.score_list;
3607:
3608: l_score NUMBER;
3609: l_idx NUMBER;
3610: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

Line 3656: 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);

3652: ELSIF p_match_type = 'OR' THEN
3653: l_match_str := ' OR ';
3654: END IF;
3655: SAVEPOINT get_matching_contacts ;
3656: 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);
3657: g_score_until_thresh := false;
3658: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3659:
3660: l_contact_contains_str := check_contacts_bulk (p_contact_list);

Line 3662: 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);

3658: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3659:
3660: l_contact_contains_str := check_contacts_bulk (p_contact_list);
3661: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3662: 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);
3663:
3664: -- Setup Search Context ID
3665: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3666: x_search_ctx_id := l_search_ctx_id;

Line 3796: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,

3792:
3793: PROCEDURE get_matching_contact_points (
3794: p_rule_id IN NUMBER,
3795: p_party_id IN NUMBER,
3796: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
3797: p_restrict_sql IN VARCHAR2,
3798: p_match_type IN VARCHAR2,
3799: p_dup_contact_point_id IN NUMBER,
3800: x_search_ctx_id OUT NUMBER,

Line 3827: H_PARTY_ID HZ_PARTY_SEARCH.IDList;

3823: l_cpt_party_id NUMBER;
3824: l_cpt_ps_id NUMBER;
3825: l_cpt_contact_id NUMBER;
3826: l_contact_pt_id NUMBER;
3827: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3828: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
3829: H_SCORE HZ_PARTY_SEARCH.IDList;
3830:
3831: cnt NUMBER :=0;

Line 3828: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;

3824: l_cpt_ps_id NUMBER;
3825: l_cpt_contact_id NUMBER;
3826: l_contact_pt_id NUMBER;
3827: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3828: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
3829: H_SCORE HZ_PARTY_SEARCH.IDList;
3830:
3831: cnt NUMBER :=0;
3832: l_party_max_score NUMBER;

Line 3829: H_SCORE HZ_PARTY_SEARCH.IDList;

3825: l_cpt_contact_id NUMBER;
3826: l_contact_pt_id NUMBER;
3827: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3828: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
3829: H_SCORE HZ_PARTY_SEARCH.IDList;
3830:
3831: cnt NUMBER :=0;
3832: l_party_max_score NUMBER;
3833: l_ps_max_score NUMBER;

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

3855: ELSIF p_match_type = 'OR' THEN
3856: l_match_str := ' OR ';
3857: END IF;
3858: SAVEPOINT get_matching_contact_points ;
3859: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
3860: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
3861: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3862: g_score_until_thresh := false;
3863: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;

Line 3860: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,

3856: l_match_str := ' OR ';
3857: END IF;
3858: SAVEPOINT get_matching_contact_points ;
3859: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
3860: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
3861: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3862: g_score_until_thresh := false;
3863: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3864:

Line 3866: 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);

3862: g_score_until_thresh := false;
3863: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3864:
3865: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3866: 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);
3867:
3868: -- Setup Search Context ID
3869: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3870: x_search_ctx_id := l_search_ctx_id;

Line 3945: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

3941:
3942: PROCEDURE get_score_details (
3943: p_rule_id IN NUMBER,
3944: p_party_id IN NUMBER,
3945: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3946: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3947: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3948: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3949: x_search_ctx_id IN OUT NUMBER

Line 3946: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

3942: PROCEDURE get_score_details (
3943: p_rule_id IN NUMBER,
3944: p_party_id IN NUMBER,
3945: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3946: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3947: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3948: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3949: x_search_ctx_id IN OUT NUMBER
3950: ) IS

Line 3947: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

3943: p_rule_id IN NUMBER,
3944: p_party_id IN NUMBER,
3945: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3946: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3947: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3948: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3949: x_search_ctx_id IN OUT NUMBER
3950: ) IS
3951:

Line 3948: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

3944: p_party_id IN NUMBER,
3945: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3946: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3947: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3948: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3949: x_search_ctx_id IN OUT NUMBER
3950: ) IS
3951:
3952: -- Strings to hold the generated Intermedia query strings

Line 3987: H_SCORES HZ_PARTY_SEARCH.score_list;

3983: l_TX45 VARCHAR2(2000);
3984: l_max_TX45 VARCHAR2(2000);
3985: l_TX14 VARCHAR2(2000);
3986: l_max_TX14 VARCHAR2(2000);
3987: H_SCORES HZ_PARTY_SEARCH.score_list;
3988:
3989: l_score NUMBER;
3990: l_match_idx NUMBER;
3991: l_idx NUMBER;

Line 4165: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

4161: ************************************************/
4162:
4163: PROCEDURE get_party_for_search (
4164: p_party_id IN NUMBER,
4165: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4166: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS

Line 4166: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

4162:
4163: PROCEDURE get_party_for_search (
4164: p_party_id IN NUMBER,
4165: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4166: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS
4170: l_party_id NUMBER;

Line 4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

4163: PROCEDURE get_party_for_search (
4164: p_party_id IN NUMBER,
4165: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4166: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS
4170: l_party_id NUMBER;
4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;

Line 4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4164: p_party_id IN NUMBER,
4165: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4166: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS
4170: l_party_id NUMBER;
4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4172: l_contact_ids HZ_PARTY_SEARCH.IDList;

Line 4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;

4167: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS
4170: l_party_id NUMBER;
4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4172: l_contact_ids HZ_PARTY_SEARCH.IDList;
4173: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4174: ps NUMBER :=1;
4175: cpt NUMBER :=1;

Line 4172: l_contact_ids HZ_PARTY_SEARCH.IDList;

4168: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4169: ) IS
4170: l_party_id NUMBER;
4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4172: l_contact_ids HZ_PARTY_SEARCH.IDList;
4173: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4174: ps NUMBER :=1;
4175: cpt NUMBER :=1;
4176: ct NUMBER :=1;

Line 4173: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;

4169: ) IS
4170: l_party_id NUMBER;
4171: l_party_site_ids HZ_PARTY_SEARCH.IDList;
4172: l_contact_ids HZ_PARTY_SEARCH.IDList;
4173: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
4174: ps NUMBER :=1;
4175: cpt NUMBER :=1;
4176: ct NUMBER :=1;
4177: l_use_contact_info varchar2(1);

Line 4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

4262: END get_party_for_search;
4263:
4264: PROCEDURE get_search_criteria (
4265: p_party_id IN NUMBER,
4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

4263:
4264: PROCEDURE get_search_criteria (
4265: p_party_id IN NUMBER,
4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

Line 4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,

4264: PROCEDURE get_search_criteria (
4265: p_party_id IN NUMBER,
4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

Line 4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

4265: p_party_id IN NUMBER,
4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4273: ) IS

Line 4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

4266: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4273: ) IS
4274: BEGIN

Line 4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

4267: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4273: ) IS
4274: BEGIN
4275:

Line 4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4268: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
4269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
4270: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
4271: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
4272: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4273: ) IS
4274: BEGIN
4275:
4276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4318: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type

4314: ************************************************/
4315:
4316: PROCEDURE get_party_rec (
4317: p_party_id IN NUMBER,
4318: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
4319: ) IS
4320: l_party_type VARCHAR2(255);
4321: BEGIN
4322:

Line 4381: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

4377: the party site search record structure
4378: ************************************************/
4379:
4380: PROCEDURE get_party_site_rec (
4381: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4382: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4383: ) IS
4384: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4385: SELECT party_site_id

Line 4382: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list

4378: ************************************************/
4379:
4380: PROCEDURE get_party_site_rec (
4381: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
4382: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4383: ) IS
4384: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4385: SELECT party_site_id
4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')

Line 4443: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

4439: the contact search record structure
4440: ************************************************/
4441:
4442: PROCEDURE get_contact_rec (
4443: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4444: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4445: ) IS
4446: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4447: SELECT org_contact_id

Line 4444: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list

4440: ************************************************/
4441:
4442: PROCEDURE get_contact_rec (
4443: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
4444: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4445: ) IS
4446: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4447: SELECT org_contact_id
4448: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

Line 4499: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,

4495: the contact point search record structure
4496: ************************************************/
4497:
4498: PROCEDURE get_contact_point_rec (
4499: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
4500: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4501: ) IS
4502:
4503: -- Cursor to fetch primary contact points for party

Line 4500: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list

4496: ************************************************/
4497:
4498: PROCEDURE get_contact_point_rec (
4499: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
4500: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
4501: ) IS
4502:
4503: -- Cursor to fetch primary contact points for party
4504: CURSOR c_cpts(cp_contact_point_id NUMBER) IS

Line 4558: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

4554: ************************************************/
4555:
4556: PROCEDURE MAP_PARTY_REC(
4557: p_search_ctx IN BOOLEAN,
4558: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4559: x_entered_max_score OUT NUMBER,
4560: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
4561: ) IS
4562: tmp VARCHAR2(4000);

Line 4662: p_search_list IN HZ_PARTY_SEARCH.party_site_list,

4658: ************************************************/
4659:
4660: PROCEDURE MAP_PARTY_SITE_REC(
4661: p_search_ctx IN BOOLEAN,
4662: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
4663: x_entered_max_score OUT NUMBER,
4664: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
4665: ) IS
4666: l_current_max_score NUMBER;

Line 4815: p_search_list IN HZ_PARTY_SEARCH.contact_list,

4811: ************************************************/
4812:
4813: PROCEDURE MAP_CONTACT_REC(
4814: p_search_ctx IN BOOLEAN,
4815: p_search_list IN HZ_PARTY_SEARCH.contact_list,
4816: x_entered_max_score OUT NUMBER,
4817: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
4818: ) IS
4819: l_current_max_score NUMBER;

Line 4857: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,

4853: ************************************************/
4854:
4855: PROCEDURE MAP_CONTACT_POINT_REC(
4856: p_search_ctx IN BOOLEAN,
4857: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
4858: x_entered_max_score OUT NUMBER,
4859: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
4860: ) IS
4861: l_current_max_score NUMBER;

Line 4958: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

4954: 2. Contact Point Type is not null for each condition
4955: ************************************************/
4956:
4957: FUNCTION check_prim_cond(
4958: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4959: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4960: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4961: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
4962: RETURN BOOLEAN IS

Line 4959: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

4955: ************************************************/
4956:
4957: FUNCTION check_prim_cond(
4958: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4959: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4960: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4961: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
4962: RETURN BOOLEAN IS
4963: BEGIN

Line 4960: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

4956:
4957: FUNCTION check_prim_cond(
4958: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4959: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4960: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4961: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
4962: RETURN BOOLEAN IS
4963: BEGIN
4964: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 4961: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)

4957: FUNCTION check_prim_cond(
4958: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4959: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4960: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4961: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
4962: RETURN BOOLEAN IS
4963: BEGIN
4964: FOR I IN 1..p_contact_point_list.COUNT LOOP
4965: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (

Line 5014: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

5010: has party site criteria.
5011: ************************************************/
5012:
5013: PROCEDURE check_party_site_cond(
5014: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5015: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5016: x_secondary OUT BOOLEAN,
5017: x_primary OUT BOOLEAN
5018: ) IS

Line 5015: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5011: ************************************************/
5012:
5013: PROCEDURE check_party_site_cond(
5014: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5015: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5016: x_secondary OUT BOOLEAN,
5017: x_primary OUT BOOLEAN
5018: ) IS
5019: BEGIN

Line 5072: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

5068: has contact criteria.
5069: ************************************************/
5070:
5071: PROCEDURE check_contact_cond(
5072: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5073: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5074: x_secondary OUT BOOLEAN,
5075: x_primary OUT BOOLEAN
5076: ) IS

Line 5073: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5069: ************************************************/
5070:
5071: PROCEDURE check_contact_cond(
5072: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5073: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5074: x_secondary OUT BOOLEAN,
5075: x_primary OUT BOOLEAN
5076: ) IS
5077: BEGIN

Line 5120: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

5116: has valid contact point criteria.
5117: ************************************************/
5118:
5119: PROCEDURE check_contact_point_cond(
5120: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5121: x_secondary OUT BOOLEAN,
5122: x_primary OUT BOOLEAN
5123: ) IS
5124: BEGIN