DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULES_VL

Line 75: FROM HZ_MATCH_RULES_VL

71: x_msg_data OUT VARCHAR2
72: ) IS
73: CURSOR c_match_rule IS
74: SELECT COMPILATION_FLAG
75: FROM HZ_MATCH_RULES_VL
76: WHERE MATCH_RULE_ID = p_rule_id;
77: l_cmp_flag VARCHAR2(1);
78: BEGIN
79:

Line 476: FROM HZ_MATCH_RULES_VL

472: x_msg_data OUT VARCHAR2
473: ) IS
474: CURSOR c_match_rule IS
475: SELECT COMPILATION_FLAG
476: FROM HZ_MATCH_RULES_VL
477: WHERE MATCH_RULE_ID = p_rule_id;
478: l_cmp_flag VARCHAR2(1);
479: BEGIN
480:

Line 895: FROM HZ_MATCH_RULES_VL

891: x_msg_data OUT VARCHAR2
892: ) IS
893: CURSOR c_match_rule IS
894: SELECT COMPILATION_FLAG
895: FROM HZ_MATCH_RULES_VL
896: WHERE MATCH_RULE_ID = p_rule_id;
897: l_cmp_flag VARCHAR2(1);
898: BEGIN
899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1291: FROM HZ_MATCH_RULES_VL

1287: x_msg_data OUT VARCHAR2
1288: ) IS
1289: CURSOR c_match_rule IS
1290: SELECT COMPILATION_FLAG
1291: FROM HZ_MATCH_RULES_VL
1292: WHERE MATCH_RULE_ID = p_rule_id;
1293: l_cmp_flag VARCHAR2(1);
1294: BEGIN
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1690: FROM HZ_MATCH_RULES_VL

1686: x_msg_data OUT VARCHAR2
1687: ) IS
1688: CURSOR c_match_rule IS
1689: SELECT COMPILATION_FLAG
1690: FROM HZ_MATCH_RULES_VL
1691: WHERE MATCH_RULE_ID = p_rule_id;
1692: l_cmp_flag VARCHAR2(1);
1693: BEGIN
1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2084: FROM HZ_MATCH_RULES_VL

2080: x_msg_data OUT VARCHAR2
2081: ) IS
2082: CURSOR c_match_rule IS
2083: SELECT COMPILATION_FLAG
2084: FROM HZ_MATCH_RULES_VL
2085: WHERE MATCH_RULE_ID = p_rule_id;
2086: l_cmp_flag VARCHAR2(1);
2087: BEGIN
2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2478: FROM HZ_MATCH_RULES_VL

2474: x_msg_data OUT VARCHAR2
2475: ) IS
2476: CURSOR c_match_rule IS
2477: SELECT COMPILATION_FLAG
2478: FROM HZ_MATCH_RULES_VL
2479: WHERE MATCH_RULE_ID = p_rule_id;
2480: l_cmp_flag VARCHAR2(1);
2481: BEGIN
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2912: FROM HZ_MATCH_RULES_VL

2908: x_msg_data OUT VARCHAR2
2909: ) IS
2910: CURSOR c_match_rule IS
2911: SELECT COMPILATION_FLAG
2912: FROM HZ_MATCH_RULES_VL
2913: WHERE MATCH_RULE_ID = p_rule_id;
2914: l_cmp_flag VARCHAR2(1);
2915: BEGIN
2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3595: FROM HZ_MATCH_RULES_VL

3591: x_msg_data OUT VARCHAR2
3592: ) IS
3593: CURSOR c_match_rule IS
3594: SELECT COMPILATION_FLAG
3595: FROM HZ_MATCH_RULES_VL
3596: WHERE MATCH_RULE_ID = p_rule_id;
3597: l_cmp_flag VARCHAR2(1);
3598: BEGIN
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4472: FROM HZ_MATCH_RULES_VL

4468: x_msg_data OUT VARCHAR2
4469: ) IS
4470: CURSOR c_match_rule IS
4471: SELECT COMPILATION_FLAG
4472: FROM HZ_MATCH_RULES_VL
4473: WHERE MATCH_RULE_ID = p_rule_id;
4474: l_cmp_flag VARCHAR2(1);
4475: BEGIN
4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4891: FROM HZ_MATCH_RULES_VL

4887: x_msg_data OUT VARCHAR2
4888: ) IS
4889: CURSOR c_match_rule IS
4890: SELECT COMPILATION_FLAG
4891: FROM HZ_MATCH_RULES_VL
4892: WHERE MATCH_RULE_ID = p_rule_id;
4893: l_cmp_flag VARCHAR2(1);
4894: BEGIN
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5308: FROM HZ_MATCH_RULES_VL

5304: x_msg_data OUT VARCHAR2
5305: ) IS
5306: CURSOR c_match_rule IS
5307: SELECT COMPILATION_FLAG
5308: FROM HZ_MATCH_RULES_VL
5309: WHERE MATCH_RULE_ID = p_rule_id;
5310: l_cmp_flag VARCHAR2(1);
5311: BEGIN
5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5728: FROM HZ_MATCH_RULES_VL

5724: x_msg_data OUT VARCHAR2
5725: ) IS
5726: CURSOR c_match_rule IS
5727: SELECT COMPILATION_FLAG
5728: FROM HZ_MATCH_RULES_VL
5729: WHERE MATCH_RULE_ID = p_rule_id;
5730: l_cmp_flag VARCHAR2(1);
5731: BEGIN
5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6148: FROM HZ_MATCH_RULES_VL

6144: x_msg_data OUT VARCHAR2
6145: ) IS
6146: CURSOR c_match_rule IS
6147: SELECT COMPILATION_FLAG
6148: FROM HZ_MATCH_RULES_VL
6149: WHERE MATCH_RULE_ID = p_rule_id;
6150: l_cmp_flag VARCHAR2(1);
6151: BEGIN
6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6540: FROM HZ_MATCH_RULES_VL

6536: x_msg_data OUT VARCHAR2
6537: ) IS
6538: CURSOR c_match_rule IS
6539: SELECT COMPILATION_FLAG
6540: FROM HZ_MATCH_RULES_VL
6541: WHERE MATCH_RULE_ID = p_rule_id;
6542: l_cmp_flag VARCHAR2(1);
6543: BEGIN
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN