APPS.FUN_RULE_VALIDATE_PKG dependencies on FUN_RULE_CRITERIA

Line 1385: p_rule_criteria_rec IN FUN_RULE_CRITERIA_PUB.rule_criteria_rec_type,

1381: */
1382:
1383: PROCEDURE validate_rule_criteria(
1384: p_create_update_flag IN VARCHAR2,
1385: p_rule_criteria_rec IN FUN_RULE_CRITERIA_PUB.rule_criteria_rec_type,
1386: p_rowid IN ROWID ,
1387: x_return_status IN OUT NOCOPY VARCHAR2
1388: ) IS
1389:

Line 1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;

1387: x_return_status IN OUT NOCOPY VARCHAR2
1388: ) IS
1389:
1390: l_dummy VARCHAR2(1);
1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;
1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;

Line 1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

1388: ) IS
1389:
1390: l_dummy VARCHAR2(1);
1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;
1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;
1396:

Line 1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

1389:
1390: l_dummy VARCHAR2(1);
1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;
1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;
1396:
1397: l_return_status VARCHAR2(1);

Line 1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

1390: l_dummy VARCHAR2(1);
1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;
1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;
1396:
1397: l_return_status VARCHAR2(1);
1398:

Line 1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;

1391: l_criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE;
1392: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
1393: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
1394: l_case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
1395: l_created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE;
1396:
1397: l_return_status VARCHAR2(1);
1398:
1399: BEGIN

Line 1415: FROM FUN_RULE_CRITERIA

1411: l_condition,
1412: l_param_value,
1413: l_case_sensitive_flag,
1414: l_created_by_module
1415: FROM FUN_RULE_CRITERIA
1416: WHERE ROWID = p_rowid;
1417: END IF;
1418:
1419: --------------------