DBA Data[Home] [Help]

APPS.MSC_PROFILE_PRE_PROCESS dependencies on FND_PROFILE

Line 61: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'USER',usr_id);

57: v_sql_stmt := 1;
58:
59: SELECT user_id into usr_id from fnd_user where user_name=cur_rec.level_name;
60:
61: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'USER',usr_id);
62: IF ret_value = FALSE THEN
63: RAISE x_prof_err;
64: END IF;
65:

Line 79: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'RESP',resp_id,appl_id);

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
81: RAISE x_prof_err;
82: END IF;
83:

Line 90: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'APPL',appl_id);

86: v_sql_stmt := 4;
87:
88: select application_id into appl_id from fnd_application where application_short_name=cur_rec.level_name;
89:
90: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'APPL',appl_id);
91: IF ret_value = FALSE THEN
92: RAISE x_prof_err;
93: END IF;
94:

Line 98: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'SITE');

94:
95: ELSE
96: --Check if the user has selected the upload site level values to YES.
97: IF p_upload_profile=SYS_YES THEN
98: ret_value := FND_PROFILE.SAVE(cur_rec.profile_option_name,cur_rec.profile_option_value,'SITE');
99: IF ret_value = FALSE THEN
100: RAISE x_prof_err;
101: END IF;
102: END IF;