DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_PRO_PARAM

Line 1133: from xtr_pro_param

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

Line 1136: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;

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;

Line 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,