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

Line 2417: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

2413: 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);
2414: END IF;
2415: OPEN x_cursor FOR
2416: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX32, TX34, TX35, TX39, TX158, TX40, TX43, TX42, TX44, TX46, TX47, TX48, TX156, TX157
2417: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
2418: WHERE contains( concat_col, p_contains_str)>0
2419: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
2420: AND d.party_id = stage.party_id
2421: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2574: END IF;
2575: IF p_person_api = 'Y' THEN
2576: OPEN x_cursor FOR
2577: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2579: WHERE contains( concat_col, p_contains_str)>0
2580: AND( (l_search_merged ='Y' )
2581: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2582: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2584: AND d.party_id = stage.party_id
2585: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2586: UNION
2587: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2588: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2589: WHERE contains( concat_col, p_contains_str)>0
2590: AND( (l_search_merged ='Y' )
2591: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2592: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2601: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2597: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2598: ELSE
2599: OPEN x_cursor FOR
2600: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2601: FROM HZ_DQM_PARTIES_GT d, 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 2802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2798: 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);
2799: END IF;
2800: OPEN x_cursor FOR
2801: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2803: WHERE contains( concat_col, p_contains_str)>0
2804: AND d.search_context_id = p_search_ctx_id
2805: AND d.party_id = stage.party_id
2806: AND( (l_search_merged ='Y' )

Line 2909: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2905: IF p_restrict_entity = 'CONTACTS'
2906: THEN
2907: OPEN x_cursor FOR
2908: 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, TX3, TX4
2909: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2910: WHERE contains( concat_col, p_contains_str)>0
2911: AND d.search_context_id = p_search_ctx_id
2912: AND( (l_search_merged ='Y' )
2913: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2921: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2993: END IF;
2994: IF p_person_api = 'Y' THEN
2995: OPEN x_cursor FOR
2996: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2998: WHERE contains( concat_col, p_contains_str)>0
2999: AND d.search_context_id = p_search_ctx_id
3000: AND d.party_id = stage.party_id
3001: AND( (l_search_merged ='Y' )

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

3003: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3004: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
3005: UNION
3006: 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, TX3, TX4
3007: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
3008: WHERE contains( concat_col, p_contains_str)>0
3009: AND d.search_context_id = p_search_ctx_id
3010: AND d.party_id = r.subject_id
3011: AND r.relationship_id = oc.party_relationship_id

Line 3020: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

3016: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
3017: ELSE
3018: OPEN x_cursor FOR
3019: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
3020: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
3024: AND( (l_search_merged ='Y' )

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

3370: SAVEPOINT eval_start;
3371: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3372: l_ctx_id := l_search_ctx_id;
3373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3374: 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);
3375: END IF;
3376: FORALL I in 1..H_PARTY_ID.COUNT
3377: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3378: l_search_ctx_id,H_PARTY_ID(I));

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

3373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3374: 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);
3375: END IF;
3376: FORALL I in 1..H_PARTY_ID.COUNT
3377: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3378: l_search_ctx_id,H_PARTY_ID(I));
3379: H_PARTY_ID.DELETE;
3380: H_PARTY_ID_LIST.DELETE;
3381: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3383: 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);
3384: END IF;
3385: l_ctx_id := l_search_ctx_id;
3386: FORALL I in 1..H_PARTY_ID.COUNT
3387: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3388: l_search_ctx_id,H_PARTY_ID(I));
3389: l_party_id_idx := H_PARTY_ID.COUNT+1;
3390: ELSE
3391: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3505: END IF;
3506: SAVEPOINT eval_start;
3507: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3509: 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);
3510: END IF;
3511: l_ctx_id := l_search_ctx_id;
3512: FORALL I in 1..H_PARTY_ID.COUNT
3513: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3509: 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);
3510: END IF;
3511: l_ctx_id := l_search_ctx_id;
3512: FORALL I in 1..H_PARTY_ID.COUNT
3513: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3514: l_search_ctx_id,H_PARTY_ID(I));
3515: H_PARTY_ID.DELETE;
3516: H_PARTY_ID_LIST.DELETE;
3517: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3519: 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);
3520: END IF;
3521: l_ctx_id := l_search_ctx_id;
3522: FORALL I in 1..H_PARTY_ID.COUNT
3523: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3524: l_search_ctx_id,H_PARTY_ID(I));
3525: l_party_id_idx := H_PARTY_ID.COUNT+1;
3526: ELSE
3527: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3617: END IF;
3618: SAVEPOINT eval_start;
3619: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3621: 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);
3622: END IF;
3623: l_ctx_id := l_search_ctx_id;
3624: FORALL I in 1..H_PARTY_ID.COUNT
3625: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3621: 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);
3622: END IF;
3623: l_ctx_id := l_search_ctx_id;
3624: FORALL I in 1..H_PARTY_ID.COUNT
3625: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3626: l_search_ctx_id,H_PARTY_ID(I));
3627: H_PARTY_ID.DELETE;
3628: H_PARTY_ID_LIST.DELETE;
3629: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3631: 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);
3632: END IF;
3633: l_ctx_id := l_search_ctx_id;
3634: FORALL I in 1..H_PARTY_ID.COUNT
3635: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3636: l_search_ctx_id,H_PARTY_ID(I));
3637: l_party_id_idx := H_PARTY_ID.COUNT+1;
3638: ELSE
3639: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3728: END IF;
3729: SAVEPOINT eval_start;
3730: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3731: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3732: 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);
3733: END IF;
3734: l_ctx_id := l_search_ctx_id;
3735: FORALL I in 1..H_PARTY_ID.COUNT
3736: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3732: 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);
3733: END IF;
3734: l_ctx_id := l_search_ctx_id;
3735: FORALL I in 1..H_PARTY_ID.COUNT
3736: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3737: l_search_ctx_id,H_PARTY_ID(I));
3738: H_PARTY_ID.DELETE;
3739: H_PARTY_ID_LIST.DELETE;
3740: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3742: 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);
3743: END IF;
3744: l_ctx_id := l_search_ctx_id;
3745: FORALL I in 1..H_PARTY_ID.COUNT
3746: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3747: l_search_ctx_id,H_PARTY_ID(I));
3748: l_party_id_idx := H_PARTY_ID.COUNT+1;
3749: ELSE
3750: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4699: l_search_ctx_id,H_PARTY_ID(I));
4700: l_party_id_idx := H_PARTY_ID.COUNT+1;
4701: ELSE
4702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4703: 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: END IF;
4705: l_ctx_id := NULL;
4706: l_party_id_idx := H_PARTY_ID.COUNT+1;
4707: END IF;

Line 6096: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6092: IF l_match_str = ' AND ' OR (
6093: ((l_cpt_max_score/l_entered_max_score)<(72/805))
6094: ) THEN
6095: FORALL I in 1..l_match_ps_list.COUNT
6096: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6097: values (l_search_ctx_id,l_match_ps_list(I));
6098: 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');
6099: ELSE
6100: 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 6326: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

6322: IF l_match_str = ' AND ' OR (
6323: ((l_cpt_max_score/l_entered_max_score)<(72/805))
6324: ) THEN
6325: FORALL I in 1..l_match_contact_list.COUNT
6326: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
6327: values (l_search_ctx_id,l_match_contact_list(I));
6328: 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');
6329: ELSE
6330: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);