APPS.FUN_RULE_VALIDATE_PKG dependencies on FUN_LOOKUPS

Line 198: IF UPPER(l_lookup_table) = 'FUN_LOOKUPS' THEN

194: l_lookup_type := SUBSTRB(p_val, l_position1 + G_LENGTH,
195: l_position2 - l_position1 - G_LENGTH);
196: l_lookup_code := SUBSTRB(p_val, l_position2 + G_LENGTH);
197:
198: IF UPPER(l_lookup_table) = 'FUN_LOOKUPS' THEN
199: BEGIN
200: SELECT 'Y' INTO l_dummy
201: FROM FUN_LOOKUPS
202: WHERE LOOKUP_TYPE = l_lookup_type

Line 201: FROM FUN_LOOKUPS

197:
198: IF UPPER(l_lookup_table) = 'FUN_LOOKUPS' THEN
199: BEGIN
200: SELECT 'Y' INTO l_dummy
201: FROM FUN_LOOKUPS
202: WHERE LOOKUP_TYPE = l_lookup_type
203: AND LOOKUP_CODE = l_lookup_code
204: AND (ENABLED_FLAG = 'Y' AND
205: TRUNC(SYSDATE) BETWEEN

Line 716: p_lookup_table => 'FUN_LOOKUPS',

712:
713: -- RESULT_TYPE is lookup code in lookup type FUN_RULE_RESULT_TYPE
714: validate_lookup (
715: p_column => 'RESULT_TYPE',
716: p_lookup_table => 'FUN_LOOKUPS',
717: p_lookup_type => 'FUN_RULE_RESULT_TYPE',
718: p_column_value => p_rule_objects_rec.result_type,
719: x_return_status => x_return_status);
720:

Line 1121: p_lookup_table => 'FUN_LOOKUPS',

1117:
1118: -- DATA_TYPE is lookup code in lookup type FUN_RULE_DATA_TYPE
1119: validate_lookup (
1120: p_column => 'DATA_TYPE',
1121: p_lookup_table => 'FUN_LOOKUPS',
1122: p_lookup_type => 'FUN_RULE_DATA_TYPE',
1123: p_column_value => p_rule_crit_params_rec.data_type,
1124: x_return_status => x_return_status);
1125:

Line 1272: p_lookup_table => 'FUN_LOOKUPS',

1268:
1269: -- OPERATOR is lookup code in lookup type FUN_RULE_OPERATORS
1270: validate_lookup (
1271: p_column => 'OPERATOR',
1272: p_lookup_table => 'FUN_LOOKUPS',
1273: p_lookup_type => 'FUN_RULE_OPERATORS',
1274: p_column_value => p_rule_details_rec.operator,
1275: x_return_status => x_return_status);
1276: --------------------

Line 1444: p_lookup_table => 'FUN_LOOKUPS',

1440:
1441: -- CONDITION is lookup code in lookup type FUN_RULE_OPERATORS
1442: validate_lookup (
1443: p_column => 'CONDITION',
1444: p_lookup_table => 'FUN_LOOKUPS',
1445: p_lookup_type => 'FUN_RULE_MATCHING_CONDITIONS',
1446: p_column_value => p_rule_criteria_rec.condition,
1447: x_return_status => x_return_status);
1448:

Line 1453: p_lookup_table => 'FUN_LOOKUPS',

1449: -- CASE_SENSITIVE is lookup code in lookup type FUN_RULE_OPERATORS
1450: IF(p_rule_criteria_rec.case_sensitive_flag IS NOT NULL) THEN
1451: validate_lookup (
1452: p_column => 'CASE_SENSITIVE',
1453: p_lookup_table => 'FUN_LOOKUPS',
1454: p_lookup_type => 'FUN_RULE_YES_NO',
1455: p_column_value => p_rule_criteria_rec.case_sensitive_flag,
1456: x_return_status => x_return_status);
1457: END IF;