DBA Data[Home] [Help]

APPS.MSC_PROFILE_PRE_PROCESS dependencies on FND_RESPONSIBILITY_VL

Line 76: SELECT responsibility_id into resp_id from fnd_responsibility_vl where responsibility_name=cur_rec.level_name and application_id=appl_id;

72: SELECT application_id into appl_id from fnd_application where application_short_name=cur_rec.application_name;
73:
74: v_sql_stmt := 3;
75:
76: SELECT responsibility_id into resp_id from fnd_responsibility_vl where responsibility_name=cur_rec.level_name and application_id=appl_id;
77:
78:
79: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'RESP',resp_id,appl_id);
80: IF ret_value = FALSE THEN