DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_VALUES_UPG dependencies on IRC_LOCATION_CRITERIA_VALUES

Line 82: -- update IRC_LOCATION_CRITERIA_VALUES

78: l_created_by(i),
79: l_create_date(i),
80: 1
81: from dual where l_prof_area(i) is not null;
82: -- update IRC_LOCATION_CRITERIA_VALUES
83: FORALL i IN l_criteria_id.FIRST..l_criteria_id.LAST
84: insert into irc_location_criteria_values
85: (location_criteria_value_id
86: ,search_criteria_id

Line 84: insert into irc_location_criteria_values

80: 1
81: from dual where l_prof_area(i) is not null;
82: -- update IRC_LOCATION_CRITERIA_VALUES
83: FORALL i IN l_criteria_id.FIRST..l_criteria_id.LAST
84: insert into irc_location_criteria_values
85: (location_criteria_value_id
86: ,search_criteria_id
87: ,derived_locale
88: ,last_update_date

Line 95: select irc_location_criteria_values_s.nextval,

91: ,created_by
92: ,creation_date
93: ,object_version_number
94: )
95: select irc_location_criteria_values_s.nextval,
96: l_criteria_id(i),
97: l_location(i),
98: l_update_date(i),
99: l_updated_by(i),