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 456: FROM HZ_MATCH_RULES_VL

452: x_msg_data OUT VARCHAR2
453: ) IS
454: CURSOR c_match_rule IS
455: SELECT COMPILATION_FLAG
456: FROM HZ_MATCH_RULES_VL
457: WHERE MATCH_RULE_ID = p_rule_id;
458: l_cmp_flag VARCHAR2(1);
459: BEGIN
460:

Line 855: FROM HZ_MATCH_RULES_VL

851: x_msg_data OUT VARCHAR2
852: ) IS
853: CURSOR c_match_rule IS
854: SELECT COMPILATION_FLAG
855: FROM HZ_MATCH_RULES_VL
856: WHERE MATCH_RULE_ID = p_rule_id;
857: l_cmp_flag VARCHAR2(1);
858: BEGIN
859: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1231: FROM HZ_MATCH_RULES_VL

1227: x_msg_data OUT VARCHAR2
1228: ) IS
1229: CURSOR c_match_rule IS
1230: SELECT COMPILATION_FLAG
1231: FROM HZ_MATCH_RULES_VL
1232: WHERE MATCH_RULE_ID = p_rule_id;
1233: l_cmp_flag VARCHAR2(1);
1234: BEGIN
1235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1610: FROM HZ_MATCH_RULES_VL

1606: x_msg_data OUT VARCHAR2
1607: ) IS
1608: CURSOR c_match_rule IS
1609: SELECT COMPILATION_FLAG
1610: FROM HZ_MATCH_RULES_VL
1611: WHERE MATCH_RULE_ID = p_rule_id;
1612: l_cmp_flag VARCHAR2(1);
1613: BEGIN
1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1984: FROM HZ_MATCH_RULES_VL

1980: x_msg_data OUT VARCHAR2
1981: ) IS
1982: CURSOR c_match_rule IS
1983: SELECT COMPILATION_FLAG
1984: FROM HZ_MATCH_RULES_VL
1985: WHERE MATCH_RULE_ID = p_rule_id;
1986: l_cmp_flag VARCHAR2(1);
1987: BEGIN
1988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2358: FROM HZ_MATCH_RULES_VL

2354: x_msg_data OUT VARCHAR2
2355: ) IS
2356: CURSOR c_match_rule IS
2357: SELECT COMPILATION_FLAG
2358: FROM HZ_MATCH_RULES_VL
2359: WHERE MATCH_RULE_ID = p_rule_id;
2360: l_cmp_flag VARCHAR2(1);
2361: BEGIN
2362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2772: FROM HZ_MATCH_RULES_VL

2768: x_msg_data OUT VARCHAR2
2769: ) IS
2770: CURSOR c_match_rule IS
2771: SELECT COMPILATION_FLAG
2772: FROM HZ_MATCH_RULES_VL
2773: WHERE MATCH_RULE_ID = p_rule_id;
2774: l_cmp_flag VARCHAR2(1);
2775: BEGIN
2776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3419: FROM HZ_MATCH_RULES_VL

3415: x_msg_data OUT VARCHAR2
3416: ) IS
3417: CURSOR c_match_rule IS
3418: SELECT COMPILATION_FLAG
3419: FROM HZ_MATCH_RULES_VL
3420: WHERE MATCH_RULE_ID = p_rule_id;
3421: l_cmp_flag VARCHAR2(1);
3422: BEGIN
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4260: FROM HZ_MATCH_RULES_VL

4256: x_msg_data OUT VARCHAR2
4257: ) IS
4258: CURSOR c_match_rule IS
4259: SELECT COMPILATION_FLAG
4260: FROM HZ_MATCH_RULES_VL
4261: WHERE MATCH_RULE_ID = p_rule_id;
4262: l_cmp_flag VARCHAR2(1);
4263: BEGIN
4264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4659: FROM HZ_MATCH_RULES_VL

4655: x_msg_data OUT VARCHAR2
4656: ) IS
4657: CURSOR c_match_rule IS
4658: SELECT COMPILATION_FLAG
4659: FROM HZ_MATCH_RULES_VL
4660: WHERE MATCH_RULE_ID = p_rule_id;
4661: l_cmp_flag VARCHAR2(1);
4662: BEGIN
4663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5056: FROM HZ_MATCH_RULES_VL

5052: x_msg_data OUT VARCHAR2
5053: ) IS
5054: CURSOR c_match_rule IS
5055: SELECT COMPILATION_FLAG
5056: FROM HZ_MATCH_RULES_VL
5057: WHERE MATCH_RULE_ID = p_rule_id;
5058: l_cmp_flag VARCHAR2(1);
5059: BEGIN
5060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5456: FROM HZ_MATCH_RULES_VL

5452: x_msg_data OUT VARCHAR2
5453: ) IS
5454: CURSOR c_match_rule IS
5455: SELECT COMPILATION_FLAG
5456: FROM HZ_MATCH_RULES_VL
5457: WHERE MATCH_RULE_ID = p_rule_id;
5458: l_cmp_flag VARCHAR2(1);
5459: BEGIN
5460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5854: FROM HZ_MATCH_RULES_VL

5850: x_msg_data OUT VARCHAR2
5851: ) IS
5852: CURSOR c_match_rule IS
5853: SELECT COMPILATION_FLAG
5854: FROM HZ_MATCH_RULES_VL
5855: WHERE MATCH_RULE_ID = p_rule_id;
5856: l_cmp_flag VARCHAR2(1);
5857: BEGIN
5858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6226: FROM HZ_MATCH_RULES_VL

6222: x_msg_data OUT VARCHAR2
6223: ) IS
6224: CURSOR c_match_rule IS
6225: SELECT COMPILATION_FLAG
6226: FROM HZ_MATCH_RULES_VL
6227: WHERE MATCH_RULE_ID = p_rule_id;
6228: l_cmp_flag VARCHAR2(1);
6229: BEGIN
6230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN