eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFER_STATUS_HISTORY_API dependencies on IRC_OFFER_STATUS_HISTORY

Line 1: Package Body IRC_OFFER_STATUS_HISTORY_API as

1: Package Body IRC_OFFER_STATUS_HISTORY_API as
2: /* $Header: iriosapi.pkb 120.3.12000000.2 2007/06/22 13:37:33 gaukumar noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'IRC_OFFER_STATUS_HISTORY_API.';

2: /* $Header: iriosapi.pkb 120.3.12000000.2 2007/06/22 13:37:33 gaukumar noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'IRC_OFFER_STATUS_HISTORY_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |---------------------< create_offer_status_history >----------------------|
10: -- ----------------------------------------------------------------------------

Line 62: IRC_OFFER_STATUS_HISTORY_BK1.create_offer_status_history_b

58: --
59: -- Call Before Process User Hook
60: --
61: begin
62: IRC_OFFER_STATUS_HISTORY_BK1.create_offer_status_history_b
63: ( P_EFFECTIVE_DATE => l_effective_date
64: ,P_OFFER_ID => P_OFFER_ID
65: ,P_STATUS_CHANGE_DATE => l_status_change_date
66: ,P_OFFER_STATUS => P_OFFER_STATUS

Line 109: IRC_OFFER_STATUS_HISTORY_BK1.create_offer_status_history_a

105: --
106: -- Call After Process User Hook
107: --
108: begin
109: IRC_OFFER_STATUS_HISTORY_BK1.create_offer_status_history_a
110: ( P_EFFECTIVE_DATE => l_effective_date
111: ,P_OFFER_ID => P_OFFER_ID
112: ,P_STATUS_CHANGE_DATE => l_status_change_date
113: ,P_OFFER_STATUS => P_OFFER_STATUS

Line 225: IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_b

221: --
222: -- Call Before Process User Hook
223: --
224: begin
225: IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_b
226: (P_EFFECTIVE_DATE => l_effective_date
227: ,P_OFFER_STATUS_HISTORY_ID => P_OFFER_STATUS_HISTORY_ID
228: ,P_STATUS_CHANGE_DATE => l_status_change_date
229: ,P_CHANGE_REASON => P_CHANGE_REASON

Line 261: IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_a

257: --
258: -- Call After Process User Hook
259: --
260: begin
261: IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_a
262: (P_EFFECTIVE_DATE => l_effective_date
263: ,P_OFFER_STATUS_HISTORY_ID => P_OFFER_STATUS_HISTORY_ID
264: ,P_STATUS_CHANGE_DATE => l_status_change_date
265: ,P_CHANGE_REASON => P_CHANGE_REASON

Line 336: from irc_offer_status_history

332:
333: cursor csr_history_records is
334: select offer_status_history_id,
335: object_version_number
336: from irc_offer_status_history
337: where offer_id = p_offer_id;
338:
339: begin
340:

Line 356: IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_b

352: --
353: -- Call Before Process User Hook
354: --
355: begin
356: IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_b
357: ( P_OBJECT_VERSION_NUMBER => c_rec.object_version_number
358: ,P_OFFER_STATUS_HISTORY_ID => c_rec.offer_status_history_id
359: );
360: exception

Line 378: IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_a

374: --
375: -- Call After Process User Hook
376: --
377: begin
378: IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_a
379: ( P_OBJECT_VERSION_NUMBER => c_rec.object_version_number
380: ,P_OFFER_STATUS_HISTORY_ID => c_rec.offer_status_history_id
381: );
382: exception

Line 417: end IRC_OFFER_STATUS_HISTORY_API;

413: hr_utility.set_location(' Leaving:'||l_proc, 90);
414: raise;
415: end DELETE_OFFER_STATUS_HISTORY;
416: --
417: end IRC_OFFER_STATUS_HISTORY_API;