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_42 dependencies on HZ_DQM_PARTIES_GT

Line 2430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

2426: hz_utility_v2pub.debug(p_message=>'Search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2427: END IF;
2428: OPEN x_cursor FOR
2429: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX8, TX32, TX35, TX42, TX44, TX45, TX46, TX47, TX48, TX156, TX157
2430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
2431: WHERE contains( concat_col, p_contains_str)>0
2432: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
2433: AND d.party_id = stage.party_id
2434: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2589: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2585: END IF;
2586: IF p_person_api = 'Y' THEN
2587: OPEN x_cursor FOR
2588: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2589: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2590: WHERE contains( concat_col, p_contains_str)>0
2591: AND( (l_search_merged ='Y' )
2592: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2593: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2599: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

2595: AND d.party_id = stage.party_id
2596: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2597: UNION
2598: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2599: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2600: WHERE contains( concat_col, p_contains_str)>0
2601: AND( (l_search_merged ='Y' )
2602: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2603: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2612: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2608: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2609: ELSE
2610: OPEN x_cursor FOR
2611: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2612: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2613: WHERE contains( concat_col, p_contains_str)>0
2614: AND( (l_search_merged ='Y' )
2615: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2616: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2813: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2809: hz_utility_v2pub.debug(p_message=>'Search Context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2810: END IF;
2811: OPEN x_cursor FOR
2812: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
2813: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2814: WHERE contains( concat_col, p_contains_str)>0
2815: AND d.search_context_id = p_search_ctx_id
2816: AND d.party_id = stage.party_id
2817: AND( (l_search_merged ='Y' )

Line 2920: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2916: IF p_restrict_entity = 'CONTACTS'
2917: THEN
2918: OPEN x_cursor FOR
2919: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5
2920: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2921: WHERE contains( concat_col, p_contains_str)>0
2922: AND d.search_context_id = p_search_ctx_id
2923: AND( (l_search_merged ='Y' )
2924: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2932: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2928: IF p_restrict_entity = 'PARTY_SITES'
2929: THEN
2930: OPEN x_cursor FOR
2931: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5
2932: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2933: WHERE contains( concat_col, p_contains_str)>0
2934: AND d.search_context_id = p_search_ctx_id
2935: AND( (l_search_merged ='Y' )
2936: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 3008: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

3004: END IF;
3005: IF p_person_api = 'Y' THEN
3006: OPEN x_cursor FOR
3007: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5
3008: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
3009: WHERE contains( concat_col, p_contains_str)>0
3010: AND d.search_context_id = p_search_ctx_id
3011: AND d.party_id = stage.party_id
3012: AND( (l_search_merged ='Y' )

Line 3018: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

3014: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3015: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
3016: UNION
3017: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX5
3018: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
3019: WHERE contains( concat_col, p_contains_str)>0
3020: AND d.search_context_id = p_search_ctx_id
3021: AND d.party_id = r.subject_id
3022: AND r.relationship_id = oc.party_relationship_id

Line 3031: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

3027: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
3028: ELSE
3029: OPEN x_cursor FOR
3030: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5
3031: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
3032: WHERE contains( concat_col, p_contains_str)>0
3033: AND d.search_context_id = p_search_ctx_id
3034: AND d.party_id = stage.party_id
3035: AND( (l_search_merged ='Y' )

Line 3380: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3376: SAVEPOINT eval_start;
3377: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3378: l_ctx_id := l_search_ctx_id;
3379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3380: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3381: END IF;
3382: FORALL I in 1..H_PARTY_ID.COUNT
3383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3384: l_search_ctx_id,H_PARTY_ID(I));

Line 3383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3380: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3381: END IF;
3382: FORALL I in 1..H_PARTY_ID.COUNT
3383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3384: l_search_ctx_id,H_PARTY_ID(I));
3385: H_PARTY_ID.DELETE;
3386: H_PARTY_ID_LIST.DELETE;
3387: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3389: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3385: H_PARTY_ID.DELETE;
3386: H_PARTY_ID_LIST.DELETE;
3387: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3389: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3390: END IF;
3391: l_ctx_id := l_search_ctx_id;
3392: FORALL I in 1..H_PARTY_ID.COUNT
3393: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3393: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3389: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3390: END IF;
3391: l_ctx_id := l_search_ctx_id;
3392: FORALL I in 1..H_PARTY_ID.COUNT
3393: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3394: l_search_ctx_id,H_PARTY_ID(I));
3395: l_party_id_idx := H_PARTY_ID.COUNT+1;
3396: ELSE
3397: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3513: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3509: END IF;
3510: SAVEPOINT eval_start;
3511: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3513: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3514: END IF;
3515: l_ctx_id := l_search_ctx_id;
3516: FORALL I in 1..H_PARTY_ID.COUNT
3517: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3517: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3513: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3514: END IF;
3515: l_ctx_id := l_search_ctx_id;
3516: FORALL I in 1..H_PARTY_ID.COUNT
3517: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3518: l_search_ctx_id,H_PARTY_ID(I));
3519: H_PARTY_ID.DELETE;
3520: H_PARTY_ID_LIST.DELETE;
3521: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3523: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3519: H_PARTY_ID.DELETE;
3520: H_PARTY_ID_LIST.DELETE;
3521: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3523: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3524: END IF;
3525: l_ctx_id := l_search_ctx_id;
3526: FORALL I in 1..H_PARTY_ID.COUNT
3527: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3527: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3523: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3524: END IF;
3525: l_ctx_id := l_search_ctx_id;
3526: FORALL I in 1..H_PARTY_ID.COUNT
3527: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3528: l_search_ctx_id,H_PARTY_ID(I));
3529: l_party_id_idx := H_PARTY_ID.COUNT+1;
3530: ELSE
3531: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3625: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3621: END IF;
3622: SAVEPOINT eval_start;
3623: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3625: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3626: END IF;
3627: l_ctx_id := l_search_ctx_id;
3628: FORALL I in 1..H_PARTY_ID.COUNT
3629: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3629: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3625: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3626: END IF;
3627: l_ctx_id := l_search_ctx_id;
3628: FORALL I in 1..H_PARTY_ID.COUNT
3629: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3630: l_search_ctx_id,H_PARTY_ID(I));
3631: H_PARTY_ID.DELETE;
3632: H_PARTY_ID_LIST.DELETE;
3633: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3635: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3631: H_PARTY_ID.DELETE;
3632: H_PARTY_ID_LIST.DELETE;
3633: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3635: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3636: END IF;
3637: l_ctx_id := l_search_ctx_id;
3638: FORALL I in 1..H_PARTY_ID.COUNT
3639: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3639: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3635: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3636: END IF;
3637: l_ctx_id := l_search_ctx_id;
3638: FORALL I in 1..H_PARTY_ID.COUNT
3639: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3640: l_search_ctx_id,H_PARTY_ID(I));
3641: l_party_id_idx := H_PARTY_ID.COUNT+1;
3642: ELSE
3643: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3736: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3732: END IF;
3733: SAVEPOINT eval_start;
3734: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3737: END IF;
3738: l_ctx_id := l_search_ctx_id;
3739: FORALL I in 1..H_PARTY_ID.COUNT
3740: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3740: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3736: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3737: END IF;
3738: l_ctx_id := l_search_ctx_id;
3739: FORALL I in 1..H_PARTY_ID.COUNT
3740: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3741: l_search_ctx_id,H_PARTY_ID(I));
3742: H_PARTY_ID.DELETE;
3743: H_PARTY_ID_LIST.DELETE;
3744: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3746: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3742: H_PARTY_ID.DELETE;
3743: H_PARTY_ID_LIST.DELETE;
3744: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3746: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3747: END IF;
3748: l_ctx_id := l_search_ctx_id;
3749: FORALL I in 1..H_PARTY_ID.COUNT
3750: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3750: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3746: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3747: END IF;
3748: l_ctx_id := l_search_ctx_id;
3749: FORALL I in 1..H_PARTY_ID.COUNT
3750: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3751: l_search_ctx_id,H_PARTY_ID(I));
3752: l_party_id_idx := H_PARTY_ID.COUNT+1;
3753: ELSE
3754: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 4376: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4372: set_person_party_type;
4373: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4374: l_ctx_id := l_search_ctx_id;
4375: FORALL I in 1..H_PARTY_ID.COUNT
4376: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4377: l_search_ctx_id,H_PARTY_ID(I));
4378: H_PARTY_ID.DELETE;
4379: H_PARTY_ID_LIST.DELETE;
4380: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 4383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4379: H_PARTY_ID_LIST.DELETE;
4380: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4381: l_ctx_id := l_search_ctx_id;
4382: FORALL I in 1..H_PARTY_ID.COUNT
4383: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4384: l_search_ctx_id,H_PARTY_ID(I));
4385: l_party_id_idx := H_PARTY_ID.COUNT+1;
4386: ELSE
4387: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 4484: SELECT /+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)/

4480: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
4481: FROM HZ_STAGED_CONTACTS stage
4482: WHERE contains( concat_col, p_contains_str)>0
4483: AND ORG_CONTACT_ID in (
4484: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4485: org_contact_id
4486: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4487: where d.party_id = r.subject_id
4488: and oc.party_relationship_id = r.relationship_id

Line 4486: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

4482: WHERE contains( concat_col, p_contains_str)>0
4483: AND ORG_CONTACT_ID in (
4484: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4485: org_contact_id
4486: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4487: where d.party_id = r.subject_id
4488: and oc.party_relationship_id = r.relationship_id
4489: and d.search_context_id = p_search_ctx_id);
4490: exception

Line 4520: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4516: unset_person_party_type;
4517: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4518: l_ctx_id := l_search_ctx_id;
4519: FORALL I in 1..H_PARTY_ID.COUNT
4520: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4521: l_search_ctx_id,H_PARTY_ID(I));
4522: H_PARTY_ID.DELETE;
4523: H_PARTY_ID_LIST.DELETE;
4524: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 4527: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4523: H_PARTY_ID_LIST.DELETE;
4524: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4525: l_ctx_id := l_search_ctx_id;
4526: FORALL I in 1..H_PARTY_ID.COUNT
4527: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4528: l_search_ctx_id,H_PARTY_ID(I));
4529: l_party_id_idx := H_PARTY_ID.COUNT+1;
4530: ELSE
4531: l_party_id_idx := H_PARTY_ID.COUNT+1;

Line 4618: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4614: SAVEPOINT eval_start;
4615: l_ctx_id := l_search_ctx_id;
4616: unset_person_party_type;
4617: FORALL I in 1..H_PARTY_ID.COUNT
4618: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4619: l_search_ctx_id,H_PARTY_ID(I));
4620: l_party_id_idx := H_PARTY_ID.COUNT+1;
4621: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4622: LOOP

Line 4685: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4681: unset_person_party_type;
4682: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4683: l_ctx_id := l_search_ctx_id;
4684: FORALL I in 1..H_PARTY_ID.COUNT
4685: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4686: l_search_ctx_id,H_PARTY_ID(I));
4687: H_PARTY_ID.DELETE;
4688: H_PARTY_ID_LIST.DELETE;
4689: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 4691: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4687: H_PARTY_ID.DELETE;
4688: H_PARTY_ID_LIST.DELETE;
4689: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4691: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4692: END IF;
4693: l_ctx_id := l_search_ctx_id;
4694: FORALL I in 1..H_PARTY_ID.COUNT
4695: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 4695: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

4691: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4692: END IF;
4693: l_ctx_id := l_search_ctx_id;
4694: FORALL I in 1..H_PARTY_ID.COUNT
4695: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4696: l_search_ctx_id,H_PARTY_ID(I));
4697: l_party_id_idx := H_PARTY_ID.COUNT+1;
4698: ELSE
4699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4700: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4696: l_search_ctx_id,H_PARTY_ID(I));
4697: l_party_id_idx := H_PARTY_ID.COUNT+1;
4698: ELSE
4699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4700: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4701: END IF;
4702: l_ctx_id := NULL;
4703: l_party_id_idx := H_PARTY_ID.COUNT+1;
4704: END IF;

Line 6081: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6077: IF l_match_str = ' AND ' OR (
6078: ((l_cpt_max_score/l_entered_max_score)<(528/880))
6079: ) THEN
6080: FORALL I in 1..l_match_ps_list.COUNT
6081: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6082: values (l_search_ctx_id,l_match_ps_list(I));
6083: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur,'PARTY_SITES');
6084: ELSE
6085: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);

Line 6311: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6307: IF l_match_str = ' AND ' OR (
6308: ((l_cpt_max_score/l_entered_max_score)<(528/880))
6309: ) THEN
6310: FORALL I in 1..l_match_contact_list.COUNT
6311: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6312: values (l_search_ctx_id,l_match_contact_list(I));
6313: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur,'CONTACTS');
6314: ELSE
6315: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);