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 2591: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

2597: AND d.party_id = stage.party_id
2598: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2599: UNION
2600: 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
2601: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2602: WHERE contains( concat_col, p_contains_str)>0
2603: AND( (l_search_merged ='Y' )
2604: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2605: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 2815: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2811: 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);
2812: END IF;
2813: OPEN x_cursor FOR
2814: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
2815: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2816: WHERE contains( concat_col, p_contains_str)>0
2817: AND d.search_context_id = p_search_ctx_id
2818: AND d.party_id = stage.party_id
2819: AND( (l_search_merged ='Y' )

Line 2922: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2918: IF p_restrict_entity = 'CONTACTS'
2919: THEN
2920: OPEN x_cursor FOR
2921: 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
2922: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2923: WHERE contains( concat_col, p_contains_str)>0
2924: AND d.search_context_id = p_search_ctx_id
2925: AND( (l_search_merged ='Y' )
2926: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2934: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2930: IF p_restrict_entity = 'PARTY_SITES'
2931: THEN
2932: OPEN x_cursor FOR
2933: 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
2934: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2935: WHERE contains( concat_col, p_contains_str)>0
2936: AND d.search_context_id = p_search_ctx_id
2937: AND( (l_search_merged ='Y' )
2938: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 3010: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

3016: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3017: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
3018: UNION
3019: 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
3020: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
3021: WHERE contains( concat_col, p_contains_str)>0
3022: AND d.search_context_id = p_search_ctx_id
3023: AND d.party_id = r.subject_id
3024: AND r.relationship_id = oc.party_relationship_id

Line 3033: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

3379: SAVEPOINT eval_start;
3380: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3381: l_ctx_id := l_search_ctx_id;
3382: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3383: 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);
3384: END IF;
3385: FORALL I in 1..H_PARTY_ID.COUNT
3386: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3387: l_search_ctx_id,H_PARTY_ID(I));

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

3382: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3383: 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);
3384: END IF;
3385: FORALL I in 1..H_PARTY_ID.COUNT
3386: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3387: l_search_ctx_id,H_PARTY_ID(I));
3388: H_PARTY_ID.DELETE;
3389: H_PARTY_ID_LIST.DELETE;
3390: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3388: H_PARTY_ID.DELETE;
3389: H_PARTY_ID_LIST.DELETE;
3390: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3391: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3392: 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);
3393: END IF;
3394: l_ctx_id := l_search_ctx_id;
3395: FORALL I in 1..H_PARTY_ID.COUNT
3396: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3392: 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);
3393: END IF;
3394: l_ctx_id := l_search_ctx_id;
3395: FORALL I in 1..H_PARTY_ID.COUNT
3396: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3397: l_search_ctx_id,H_PARTY_ID(I));
3398: l_party_id_idx := H_PARTY_ID.COUNT+1;
3399: ELSE
3400: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3518: 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: SAVEPOINT eval_start;
3516: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3518: 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);
3519: END IF;
3520: l_ctx_id := l_search_ctx_id;
3521: FORALL I in 1..H_PARTY_ID.COUNT
3522: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3518: 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);
3519: END IF;
3520: l_ctx_id := l_search_ctx_id;
3521: FORALL I in 1..H_PARTY_ID.COUNT
3522: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3523: l_search_ctx_id,H_PARTY_ID(I));
3524: H_PARTY_ID.DELETE;
3525: H_PARTY_ID_LIST.DELETE;
3526: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3528: 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: H_PARTY_ID.DELETE;
3525: H_PARTY_ID_LIST.DELETE;
3526: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3527: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3528: 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);
3529: END IF;
3530: l_ctx_id := l_search_ctx_id;
3531: FORALL I in 1..H_PARTY_ID.COUNT
3532: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3528: 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);
3529: END IF;
3530: l_ctx_id := l_search_ctx_id;
3531: FORALL I in 1..H_PARTY_ID.COUNT
3532: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3533: l_search_ctx_id,H_PARTY_ID(I));
3534: l_party_id_idx := H_PARTY_ID.COUNT+1;
3535: ELSE
3536: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3630: 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: SAVEPOINT eval_start;
3628: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3630: 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);
3631: END IF;
3632: l_ctx_id := l_search_ctx_id;
3633: FORALL I in 1..H_PARTY_ID.COUNT
3634: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3630: 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);
3631: END IF;
3632: l_ctx_id := l_search_ctx_id;
3633: FORALL I in 1..H_PARTY_ID.COUNT
3634: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3635: l_search_ctx_id,H_PARTY_ID(I));
3636: H_PARTY_ID.DELETE;
3637: H_PARTY_ID_LIST.DELETE;
3638: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3640: 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: H_PARTY_ID.DELETE;
3637: H_PARTY_ID_LIST.DELETE;
3638: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3639: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3640: 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);
3641: END IF;
3642: l_ctx_id := l_search_ctx_id;
3643: FORALL I in 1..H_PARTY_ID.COUNT
3644: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3640: 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);
3641: END IF;
3642: l_ctx_id := l_search_ctx_id;
3643: FORALL I in 1..H_PARTY_ID.COUNT
3644: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3645: l_search_ctx_id,H_PARTY_ID(I));
3646: l_party_id_idx := H_PARTY_ID.COUNT+1;
3647: ELSE
3648: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3741: 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: SAVEPOINT eval_start;
3739: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3741: 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);
3742: END IF;
3743: l_ctx_id := l_search_ctx_id;
3744: FORALL I in 1..H_PARTY_ID.COUNT
3745: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3741: 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);
3742: END IF;
3743: l_ctx_id := l_search_ctx_id;
3744: FORALL I in 1..H_PARTY_ID.COUNT
3745: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3746: l_search_ctx_id,H_PARTY_ID(I));
3747: H_PARTY_ID.DELETE;
3748: H_PARTY_ID_LIST.DELETE;
3749: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3751: 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: H_PARTY_ID.DELETE;
3748: H_PARTY_ID_LIST.DELETE;
3749: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3751: 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);
3752: END IF;
3753: l_ctx_id := l_search_ctx_id;
3754: FORALL I in 1..H_PARTY_ID.COUNT
3755: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3751: 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);
3752: END IF;
3753: l_ctx_id := l_search_ctx_id;
3754: FORALL I in 1..H_PARTY_ID.COUNT
3755: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3756: l_search_ctx_id,H_PARTY_ID(I));
3757: l_party_id_idx := H_PARTY_ID.COUNT+1;
3758: ELSE
3759: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

4378: set_person_party_type;
4379: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4380: l_ctx_id := l_search_ctx_id;
4381: FORALL I in 1..H_PARTY_ID.COUNT
4382: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4383: l_search_ctx_id,H_PARTY_ID(I));
4384: H_PARTY_ID.DELETE;
4385: H_PARTY_ID_LIST.DELETE;
4386: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4385: H_PARTY_ID_LIST.DELETE;
4386: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4387: l_ctx_id := l_search_ctx_id;
4388: FORALL I in 1..H_PARTY_ID.COUNT
4389: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4390: l_search_ctx_id,H_PARTY_ID(I));
4391: l_party_id_idx := H_PARTY_ID.COUNT+1;
4392: ELSE
4393: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

4488: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
4489: FROM HZ_STAGED_CONTACTS stage
4490: WHERE contains( concat_col, p_contains_str)>0
4491: AND ORG_CONTACT_ID in (
4492: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4493: org_contact_id
4494: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4495: where d.party_id = r.subject_id
4496: and oc.party_relationship_id = r.relationship_id

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

4490: WHERE contains( concat_col, p_contains_str)>0
4491: AND ORG_CONTACT_ID in (
4492: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4493: org_contact_id
4494: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4495: where d.party_id = r.subject_id
4496: and oc.party_relationship_id = r.relationship_id
4497: and d.search_context_id = p_search_ctx_id);
4498: exception

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

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

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

4531: H_PARTY_ID_LIST.DELETE;
4532: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4533: l_ctx_id := l_search_ctx_id;
4534: FORALL I in 1..H_PARTY_ID.COUNT
4535: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4536: l_search_ctx_id,H_PARTY_ID(I));
4537: l_party_id_idx := H_PARTY_ID.COUNT+1;
4538: ELSE
4539: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

4622: SAVEPOINT eval_start;
4623: l_ctx_id := l_search_ctx_id;
4624: unset_person_party_type;
4625: FORALL I in 1..H_PARTY_ID.COUNT
4626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4627: l_search_ctx_id,H_PARTY_ID(I));
4628: l_party_id_idx := H_PARTY_ID.COUNT+1;
4629: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4630: LOOP

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

4689: unset_person_party_type;
4690: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4691: l_ctx_id := l_search_ctx_id;
4692: FORALL I in 1..H_PARTY_ID.COUNT
4693: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4694: l_search_ctx_id,H_PARTY_ID(I));
4695: H_PARTY_ID.DELETE;
4696: H_PARTY_ID_LIST.DELETE;
4697: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4695: H_PARTY_ID.DELETE;
4696: H_PARTY_ID_LIST.DELETE;
4697: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4699: 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);
4700: END IF;
4701: l_ctx_id := l_search_ctx_id;
4702: FORALL I in 1..H_PARTY_ID.COUNT
4703: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4699: 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);
4700: END IF;
4701: l_ctx_id := l_search_ctx_id;
4702: FORALL I in 1..H_PARTY_ID.COUNT
4703: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4704: l_search_ctx_id,H_PARTY_ID(I));
4705: l_party_id_idx := H_PARTY_ID.COUNT+1;
4706: ELSE
4707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4704: l_search_ctx_id,H_PARTY_ID(I));
4705: l_party_id_idx := H_PARTY_ID.COUNT+1;
4706: ELSE
4707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4708: 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);
4709: END IF;
4710: l_ctx_id := NULL;
4711: l_party_id_idx := H_PARTY_ID.COUNT+1;
4712: END IF;

Line 6089: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6085: IF l_match_str = ' AND ' OR (
6086: ((l_cpt_max_score/l_entered_max_score)<(528/880))
6087: ) THEN
6088: FORALL I in 1..l_match_ps_list.COUNT
6089: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6090: values (l_search_ctx_id,l_match_ps_list(I));
6091: 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');
6092: ELSE
6093: 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 6319: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6315: IF l_match_str = ' AND ' OR (
6316: ((l_cpt_max_score/l_entered_max_score)<(528/880))
6317: ) THEN
6318: FORALL I in 1..l_match_contact_list.COUNT
6319: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6320: values (l_search_ctx_id,l_match_contact_list(I));
6321: 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');
6322: ELSE
6323: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);