DBA Data[Home] [Help]

APPS.MSC_PROFILE_PRE_PROCESS dependencies on FND_APPLICATION

Line 72: SELECT application_id into appl_id from fnd_application where application_short_name=cur_rec.application_name;

68:
69: v_sql_stmt := 2;
70:
71:
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;

Line 88: select application_id into appl_id from fnd_application where application_short_name=cur_rec.level_name;

84: ELSIF cur_rec.level_type='APPL' THEN
85:
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;