APPS.JTF_RS_CONC_RES_PUB dependencies on FND_PROFILE_OPTION_VALUES

Line 153: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

149: IS
150:
151: /* Moved the initial assignment of below variables to inside begin */
152: set_err_var VARCHAR2(1);
153: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
154:
155: BEGIN
156:
157: set_err_var := 'N';

Line 264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);

Line 265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);
269: r_msg_count NUMBER;

Line 266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;

262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);
269: r_msg_count NUMBER;
270: r_msg_data VARCHAR2(2000);