DBA Data[Home] [Help]

APPS.FUN_RULE_VALIDATE_PKG dependencies on FUN_RULE_DETAILS

Line 1195: p_rule_details_rec IN FUN_RULE_DETAILS_PUB.rule_details_rec_type,

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:

Line 1201: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;

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;

Line 1202: l_seq FUN_RULE_DETAILS.SEQ%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;

Line 1203: l_operator FUN_RULE_DETAILS.OPERATOR%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;

Line 1204: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%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:

Line 1205: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;

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);

Line 1206: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%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);
1210:

Line 1207: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%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:
1211: BEGIN

Line 1231: FROM FUN_RULE_DETAILS

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: