APPS.JTF_RS_CONC_RES_PUB dependencies on FND_PROFILE_OPTION_VALUES

Line 211: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

207: IS
208:
209: /* Moved the initial assignment of below variables to inside begin */
210: set_err_var VARCHAR2(1);
211: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
212:
213: BEGIN
214:
215: set_err_var := 'N';

Line 322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);

Line 323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);
327: r_msg_count NUMBER;

Line 324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;

320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);
327: r_msg_count NUMBER;
328: r_msg_data VARCHAR2(2000);