22: begin
23:
24: select profile_option_id
25: into l_old_ovr_requester_profile_id
26: from fnd_profile_options
27: where profile_option_name = 'ICX_REQ_OVERRIDE_REQUESTOR_CODE';
28:
29: select profile_option_id
30: into l_new_ovr_requester_profile_id
27: where profile_option_name = 'ICX_REQ_OVERRIDE_REQUESTOR_CODE';
28:
29: select profile_option_id
30: into l_new_ovr_requester_profile_id
31: from fnd_profile_options
32: where profile_option_name = 'POR_OVERRIDE_REQUESTER';
33:
34: select profile_option_id
35: into l_old_ovr_location_profile_id
32: where profile_option_name = 'POR_OVERRIDE_REQUESTER';
33:
34: select profile_option_id
35: into l_old_ovr_location_profile_id
36: from fnd_profile_options
37: where profile_option_name = 'ICX_REQ_OVERRIDE_LOCATION_FLAG';
38:
39: select profile_option_id
40: into l_new_ovr_location_profile_id
37: where profile_option_name = 'ICX_REQ_OVERRIDE_LOCATION_FLAG';
38:
39: select profile_option_id
40: into l_new_ovr_location_profile_id
41: from fnd_profile_options
42: where profile_option_name = 'POR_OVERRIDE_LOCATION';
43:
44: select profile_option_id
45: into l_old_days_need_by_profile_id
42: where profile_option_name = 'POR_OVERRIDE_LOCATION';
43:
44: select profile_option_id
45: into l_old_days_need_by_profile_id
46: from fnd_profile_options
47: where profile_option_name = 'ICX_DAYS_NEEDED_BY';
48:
49: select profile_option_id
50: into l_new_days_need_by_profile_id
47: where profile_option_name = 'ICX_DAYS_NEEDED_BY';
48:
49: select profile_option_id
50: into l_new_days_need_by_profile_id
51: from fnd_profile_options
52: where profile_option_name = 'POR_DAYS_NEEDED_BY';
53:
54: l_new_def_exist := true;
55: