152: -- {Start Of Comments}
153: --
154: -- Description:
155: -- This procedure is used to ensure that offer_status_history_id exists in
156: -- irc_offer_status_history.
157: --
158: -- Pre Conditions:
159: -- g_old_rec has been populated with details of the values currently in
160: -- the database.
178: l_num number;
179: --
180: cursor csr_offer_status_history_id is
181: select 1
182: from irc_offer_status_history
183: where offer_status_history_id = p_offer_status_history_id;
184: --
185: Begin
186: --