DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_PRO_PARAM

Line 1134: from xtr_pro_param

1130: -- Begin 1336492 additions.
1131:
1132: Cursor VALREQ(p_param_name varchar2) is
1133: Select param_value
1134: from xtr_pro_param
1135: where param_name = p_param_name;
1136:
1137: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1138: l_val_flag varchar2(1) := 'N';

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

1133: Select param_value
1134: from xtr_pro_param
1135: where param_name = p_param_name;
1136:
1137: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1138: l_val_flag varchar2(1) := 'N';
1139: l_ret_value number := 0;
1140: l_updt_flag VARCHAR2(1) := 'Y';
1141: l_iac_valreq xtr_pro_param.param_value%type;

Line 1141: l_iac_valreq xtr_pro_param.param_value%type;

1137: l_valreq XTR_PRO_PARAM.param_value%TYPE := NULL;
1138: l_val_flag varchar2(1) := 'N';
1139: l_ret_value number := 0;
1140: l_updt_flag VARCHAR2(1) := 'Y';
1141: l_iac_valreq xtr_pro_param.param_value%type;
1142:
1143: FUNCTION VALIDATED
1144: (l_deal_type in varchar2,
1145: l_deal_no in number,