1129: -- Begin 1336492 additions.
1130:
1131: Cursor VALREQ(p_param_name varchar2) is
1132: Select param_value
1133: from xtr_pro_param
1134: where param_name = p_param_name;
1135:
1136: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1137: l_val_flag varchar2(1) := 'N';
1132: Select param_value
1133: from xtr_pro_param
1134: where param_name = p_param_name;
1135:
1136: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1137: l_val_flag varchar2(1) := 'N';
1138: l_ret_value number := 0;
1139: l_updt_flag VARCHAR2(1) := 'Y';
1140: l_iac_valreq xtr_pro_param.param_value%type;
1136: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1137: l_val_flag varchar2(1) := 'N';
1138: l_ret_value number := 0;
1139: l_updt_flag VARCHAR2(1) := 'Y';
1140: l_iac_valreq xtr_pro_param.param_value%type;
1141:
1142: FUNCTION VALIDATED
1143: (l_deal_type in varchar2,
1144: l_deal_no in number,