1191: */
1192:
1193: PROCEDURE validate_rule_details(
1194: p_create_update_flag IN VARCHAR2,
1195: p_rule_details_rec IN FUN_RULE_DETAILS_PUB.rule_details_rec_type,
1196: p_rowid IN ROWID ,
1197: x_return_status IN OUT NOCOPY VARCHAR2
1198: ) IS
1199:
1197: x_return_status IN OUT NOCOPY VARCHAR2
1198: ) IS
1199:
1200: l_dummy VARCHAR2(1);
1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1198: ) IS
1199:
1200: l_dummy VARCHAR2(1);
1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1199:
1200: l_dummy VARCHAR2(1);
1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
1200: l_dummy VARCHAR2(1);
1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
1208:
1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
1208:
1209: l_return_status VARCHAR2(1);
1202: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
1208:
1209: l_return_status VARCHAR2(1);
1210:
1203: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
1208:
1209: l_return_status VARCHAR2(1);
1210:
1211: BEGIN
1227: l_enabled_flag,
1228: l_result_application_id,
1229: l_result_value,
1230: l_created_by_module
1231: FROM FUN_RULE_DETAILS
1232: WHERE ROWID = p_rowid;
1233: END IF;
1234:
1235: