APPS.FUN_RULE_VALIDATE_PKG dependencies on FUN_RULE_CRIT_PARAMS_B

Line 1046: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;

1042: x_return_status IN OUT NOCOPY VARCHAR2
1043: ) IS
1044:
1045: l_dummy VARCHAR2(1);
1046: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
1047: l_user_param_name FUN_RULE_CRIT_PARAMS_TL.USER_PARAM_NAME%TYPE;
1048: l_description FUN_RULE_CRIT_PARAMS_TL.DESCRIPTION%TYPE;
1049: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
1050: l_created_by_module FUN_RULE_CRIT_PARAMS_B.CREATED_BY_MODULE%TYPE;

Line 1049: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;

1045: l_dummy VARCHAR2(1);
1046: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
1047: l_user_param_name FUN_RULE_CRIT_PARAMS_TL.USER_PARAM_NAME%TYPE;
1048: l_description FUN_RULE_CRIT_PARAMS_TL.DESCRIPTION%TYPE;
1049: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
1050: l_created_by_module FUN_RULE_CRIT_PARAMS_B.CREATED_BY_MODULE%TYPE;
1051: l_return_status VARCHAR2(1);
1052: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1053:

Line 1050: l_created_by_module FUN_RULE_CRIT_PARAMS_B.CREATED_BY_MODULE%TYPE;

1046: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
1047: l_user_param_name FUN_RULE_CRIT_PARAMS_TL.USER_PARAM_NAME%TYPE;
1048: l_description FUN_RULE_CRIT_PARAMS_TL.DESCRIPTION%TYPE;
1049: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
1050: l_created_by_module FUN_RULE_CRIT_PARAMS_B.CREATED_BY_MODULE%TYPE;
1051: l_return_status VARCHAR2(1);
1052: l_rule_object_id FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
1053:
1054: BEGIN

Line 1065: FROM FUN_RULE_CRIT_PARAMS_B

1061: created_by_module
1062: INTO l_param_name,
1063: l_data_type,
1064: l_created_by_module
1065: FROM FUN_RULE_CRIT_PARAMS_B
1066: WHERE ROWID = p_rowid;
1067: END IF;
1068:
1069: -- Validate if a valid rule object id is passed or not