APPS.POR_R12_UPGRADE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 71: update fnd_profile_option_values v1

67: -- Update non site level profile values
68:
69: WHILE(l_continue) LOOP
70:
71: update fnd_profile_option_values v1
72: set v1.profile_option_id = decode(v1.profile_option_id,
73: l_old_ovr_requester_profile_id,
74: l_new_ovr_requester_profile_id,
75: l_old_ovr_location_profile_id,

Line 84: from fnd_profile_option_values v2

80: l_old_ovr_location_profile_id,
81: l_old_days_need_by_profile_id)
82: and v1.level_id <> 10001
83: and not exists (select 1
84: from fnd_profile_option_values v2
85: where v2.profile_option_id =
86: decode(v1.profile_option_id,
87: l_old_ovr_requester_profile_id,
88: l_new_ovr_requester_profile_id,

Line 107: update fnd_profile_option_values p1

103: END LOOP;
104:
105: -- Update site level profile value
106:
107: update fnd_profile_option_values p1
108: set p1.profile_option_value =
109: (select p2.profile_option_value
110: from fnd_profile_option_values p2
111: where p2.profile_option_id = decode(p1.profile_option_id,

Line 110: from fnd_profile_option_values p2

106:
107: update fnd_profile_option_values p1
108: set p1.profile_option_value =
109: (select p2.profile_option_value
110: from fnd_profile_option_values p2
111: where p2.profile_option_id = decode(p1.profile_option_id,
112: l_new_ovr_requester_profile_id,
113: l_old_ovr_requester_profile_id,
114: l_new_ovr_location_profile_id,