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

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

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

2582: AND d.party_id = stage.party_id
2583: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2584: UNION
2585: 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
2586: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2587: WHERE contains( concat_col, p_contains_str)>0
2588: AND( (l_search_merged ='Y' )
2589: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2590: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2599: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2595: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2596: ELSE
2597: OPEN x_cursor FOR
2598: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2599: FROM HZ_DQM_PARTIES_GT d, 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 2800: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2907: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2919: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2991: END IF;
2992: IF p_person_api = 'Y' THEN
2993: OPEN x_cursor FOR
2994: 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, TX3, TX4
2995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2996: WHERE contains( concat_col, p_contains_str)>0
2997: AND d.search_context_id = p_search_ctx_id
2998: AND d.party_id = stage.party_id
2999: AND( (l_search_merged ='Y' )

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

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

Line 3018: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

3014: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
3015: ELSE
3016: OPEN x_cursor FOR
3017: 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, TX3, TX4
3018: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
3022: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

3500: END IF;
3501: SAVEPOINT eval_start;
3502: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3504: 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: l_ctx_id := l_search_ctx_id;
3507: FORALL I in 1..H_PARTY_ID.COUNT
3508: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3612: END IF;
3613: SAVEPOINT eval_start;
3614: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3616: 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: l_ctx_id := l_search_ctx_id;
3619: FORALL I in 1..H_PARTY_ID.COUNT
3620: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3723: END IF;
3724: SAVEPOINT eval_start;
3725: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3726: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3727: 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: l_ctx_id := l_search_ctx_id;
3730: FORALL I in 1..H_PARTY_ID.COUNT
3731: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

4367: set_person_party_type;
4368: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4369: l_ctx_id := l_search_ctx_id;
4370: FORALL I in 1..H_PARTY_ID.COUNT
4371: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4372: l_search_ctx_id,H_PARTY_ID(I));
4373: H_PARTY_ID.DELETE;
4374: H_PARTY_ID_LIST.DELETE;
4375: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

4475: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
4476: FROM HZ_STAGED_CONTACTS stage
4477: WHERE contains( concat_col, p_contains_str)>0
4478: AND ORG_CONTACT_ID in (
4479: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4480: org_contact_id
4481: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4482: where d.party_id = r.subject_id
4483: and oc.party_relationship_id = r.relationship_id

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

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

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

4511: unset_person_party_type;
4512: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4513: l_ctx_id := l_search_ctx_id;
4514: FORALL I in 1..H_PARTY_ID.COUNT
4515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4516: l_search_ctx_id,H_PARTY_ID(I));
4517: H_PARTY_ID.DELETE;
4518: H_PARTY_ID_LIST.DELETE;
4519: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

4609: SAVEPOINT eval_start;
4610: l_ctx_id := l_search_ctx_id;
4611: unset_person_party_type;
4612: FORALL I in 1..H_PARTY_ID.COUNT
4613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4614: l_search_ctx_id,H_PARTY_ID(I));
4615: l_party_id_idx := H_PARTY_ID.COUNT+1;
4616: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4617: LOOP

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

4676: unset_person_party_type;
4677: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4678: l_ctx_id := l_search_ctx_id;
4679: FORALL I in 1..H_PARTY_ID.COUNT
4680: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4681: l_search_ctx_id,H_PARTY_ID(I));
4682: H_PARTY_ID.DELETE;
4683: H_PARTY_ID_LIST.DELETE;
4684: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4682: H_PARTY_ID.DELETE;
4683: H_PARTY_ID_LIST.DELETE;
4684: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4685: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4686: 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: END IF;
4688: l_ctx_id := l_search_ctx_id;
4689: FORALL I in 1..H_PARTY_ID.COUNT
4690: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4686: 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: END IF;
4688: l_ctx_id := l_search_ctx_id;
4689: FORALL I in 1..H_PARTY_ID.COUNT
4690: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4691: l_search_ctx_id,H_PARTY_ID(I));
4692: l_party_id_idx := H_PARTY_ID.COUNT+1;
4693: ELSE
4694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4691: l_search_ctx_id,H_PARTY_ID(I));
4692: l_party_id_idx := H_PARTY_ID.COUNT+1;
4693: ELSE
4694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4695: 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: END IF;
4697: l_ctx_id := NULL;
4698: l_party_id_idx := H_PARTY_ID.COUNT+1;
4699: END IF;

Line 6088: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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