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_OFFERS_API dependencies on IRC_OFFERS

Line 1: Package Body IRC_OFFERS_API as

1: Package Body IRC_OFFERS_API as
2: /* $Header: iriofapi.pkb 120.41 2011/04/08 12:04:28 amikukum ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: iriofapi.pkb 120.41 2011/04/08 12:04:28 amikukum ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'IRC_OFFERS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |---------------------< create_offer_assignment_copy >---------------------|
10: -- ----------------------------------------------------------------------------

Line 661: l_object_version_number irc_offers.object_version_number%TYPE;

657: ,P_STATUS_CHANGE_DATE IN date default null
658: ) is
659: --
660: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
661: l_object_version_number irc_offers.object_version_number%TYPE;
662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
665: l_offer_version irc_offers.offer_version%TYPE;

Line 664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

660: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
661: l_object_version_number irc_offers.object_version_number%TYPE;
662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
665: l_offer_version irc_offers.offer_version%TYPE;
666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 665: l_offer_version irc_offers.offer_version%TYPE;

661: l_object_version_number irc_offers.object_version_number%TYPE;
662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
665: l_offer_version irc_offers.offer_version%TYPE;
666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 666: l_updated_offer_status irc_offers.offer_status%TYPE;

662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
665: l_offer_version irc_offers.offer_version%TYPE;
666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 680: from irc_offers

676: cursor csr_offer_details is
677: select offer_assignment_id
678: ,object_version_number
679: ,offer_status
680: from irc_offers
681: where offer_id = p_offer_id;
682: --
683: cursor csr_assignment_ovn is
684: select object_version_number

Line 804: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

800: )
801: Is
802: --
803: l_proc varchar2(72) := g_package||'copy_offer_asg_to_appl_asg';
804: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
805: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
806: --
807: -- Out and In Out variables
808: --

Line 805: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

801: Is
802: --
803: l_proc varchar2(72) := g_package||'copy_offer_asg_to_appl_asg';
804: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
805: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
806: --
807: -- Out and In Out variables
808: --
809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 829: from irc_offers

825: --
826: cursor csr_assignment_ids is
827: select applicant_assignment_id
828: ,offer_assignment_id
829: from irc_offers
830: where offer_id = p_offer_id;
831: --
832: cursor csr_appl_asg_effective_date is
833: select effective_start_date

Line 1209: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

1205: l_approved_warning boolean;
1206: l_payroll_warning boolean;
1207: l_salary_warning boolean;
1208:
1209: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
1210: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
1211: --
1212: -- Define cursors
1213: --

Line 1210: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

1206: l_payroll_warning boolean;
1207: l_salary_warning boolean;
1208:
1209: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
1210: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
1211: --
1212: -- Define cursors
1213: --
1214: cursor csr_assignment_ids is

Line 1217: from irc_offers

1213: --
1214: cursor csr_assignment_ids is
1215: select applicant_assignment_id
1216: ,offer_assignment_id
1217: from irc_offers
1218: where offer_id = p_offer_id;
1219: --
1220: cursor csr_appl_pay_proposal is
1221: select pay_proposal_id

Line 1464: FROM IRC_OFFERS otheroffer

1460: AND effective_end_date;
1461: --
1462: CURSOR csr_other_extended_offers IS
1463: SELECT count(otheroffer.offer_id)
1464: FROM IRC_OFFERS otheroffer
1465: ,PER_ALL_ASSIGNMENTS_F otherasg
1466: ,PER_ALL_PEOPLE_F per
1467: ,PER_ALL_PEOPLE_F linkper
1468: ,IRC_OFFER_STATUS_HISTORY otherhistory

Line 1566: where transaction_ref_table='IRC_OFFERS'

1562: select transaction_id
1563: ,item_type
1564: ,item_key
1565: from hr_api_transactions
1566: where transaction_ref_table='IRC_OFFERS'
1567: and transaction_ref_id = p_offer_id;
1568: --
1569: cursor csr_get_sfl_txn_details is
1570: select hat.transaction_id

Line 1575: where hat.transaction_ref_table='IRC_OFFERS'

1571: ,wn.MESSAGE_TYPE
1572: ,wn.item_key
1573: from hr_api_transactions hat,
1574: wf_notifications wn
1575: where hat.transaction_ref_table='IRC_OFFERS'
1576: and hat.STATUS='S'
1577: and wn.MESSAGE_TYPE='HRSFL'
1578: and to_char(hat.transaction_id)=wn.user_key
1579: and hat.ASSIGNMENT_ID = p_applicant_assignment_id;

Line 1712: l_offer_id irc_offers.offer_id%TYPE;

1708: --
1709: -- Declare cursors and local variables
1710: --
1711: l_proc varchar2(72) := g_package||'create_offer';
1712: l_offer_id irc_offers.offer_id%TYPE;
1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;
1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;

Line 1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;

1709: -- Declare cursors and local variables
1710: --
1711: l_proc varchar2(72) := g_package||'create_offer';
1712: l_offer_id irc_offers.offer_id%TYPE;
1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;
1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

Line 1715: l_expiry_date irc_offers.expiry_date%TYPE;

1711: l_proc varchar2(72) := g_package||'create_offer';
1712: l_offer_id irc_offers.offer_id%TYPE;
1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;
1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
1719: l_latest_offer irc_offers.latest_offer%TYPE;

Line 1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;

1712: l_offer_id irc_offers.offer_id%TYPE;
1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;
1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
1719: l_latest_offer irc_offers.latest_offer%TYPE;
1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

Line 1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

1713: l_object_version_number irc_offers.object_version_number%TYPE := 1;
1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
1719: l_latest_offer irc_offers.latest_offer%TYPE;
1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

Line 1719: l_latest_offer irc_offers.latest_offer%TYPE;

1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
1719: l_latest_offer irc_offers.latest_offer%TYPE;
1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
1722: l_offer_version irc_offers.offer_version%TYPE;
1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 1722: l_offer_version irc_offers.offer_version%TYPE;

1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
1719: l_latest_offer irc_offers.latest_offer%TYPE;
1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
1722: l_offer_version irc_offers.offer_version%TYPE;
1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1724: --
1725: l_updated_offer_id irc_offers.offer_id%TYPE;
1726: l_updated_offer_status irc_offers.offer_status%TYPE;

Line 1725: l_updated_offer_id irc_offers.offer_id%TYPE;

1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
1722: l_offer_version irc_offers.offer_version%TYPE;
1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1724: --
1725: l_updated_offer_id irc_offers.offer_id%TYPE;
1726: l_updated_offer_status irc_offers.offer_status%TYPE;
1727: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;
1728: --
1729: cursor csr_latest_offer is

Line 1726: l_updated_offer_status irc_offers.offer_status%TYPE;

1722: l_offer_version irc_offers.offer_version%TYPE;
1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1724: --
1725: l_updated_offer_id irc_offers.offer_id%TYPE;
1726: l_updated_offer_status irc_offers.offer_status%TYPE;
1727: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;
1728: --
1729: cursor csr_latest_offer is
1730: select offer_id

Line 1727: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;

1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1724: --
1725: l_updated_offer_id irc_offers.offer_id%TYPE;
1726: l_updated_offer_status irc_offers.offer_status%TYPE;
1727: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;
1728: --
1729: cursor csr_latest_offer is
1730: select offer_id
1731: ,offer_status

Line 1733: from irc_offers

1729: cursor csr_latest_offer is
1730: select offer_id
1731: ,offer_status
1732: ,applicant_assignment_id
1733: from irc_offers
1734: where latest_offer = 'Y'
1735: and ( applicant_assignment_id = nvl(p_applicant_assignment_id,-1)
1736: OR
1737: applicant_assignment_id = nvl(p_src_apl_asg_id,-1)

Line 1833: IRC_OFFERS_BK1.create_offer_b

1829: --
1830: -- Call Before Process User Hook
1831: --
1832: begin
1833: IRC_OFFERS_BK1.create_offer_b
1834: ( P_EFFECTIVE_DATE => l_effective_date
1835: , P_LATEST_OFFER => l_latest_offer
1836: , P_OFFER_STATUS => P_OFFER_STATUS
1837: , P_DISCRETIONARY_JOB_TITLE => P_DISCRETIONARY_JOB_TITLE

Line 1972: IRC_OFFERS_BK1.create_offer_a

1968: --
1969: -- Call After Process User Hook
1970: --
1971: begin
1972: IRC_OFFERS_BK1.create_offer_a
1973: ( P_EFFECTIVE_DATE => l_effective_date
1974: , P_LATEST_OFFER => l_latest_offer
1975: , P_OFFER_STATUS => P_OFFER_STATUS
1976: , P_DISCRETIONARY_JOB_TITLE => P_DISCRETIONARY_JOB_TITLE

Line 2145: l_object_version_number irc_offers.object_version_number%TYPE;

2141: --
2142: -- Declare local variables
2143: --
2144: l_proc varchar2(72) := g_package||'update_offer';
2145: l_object_version_number irc_offers.object_version_number%TYPE;
2146: l_effective_date date;
2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;

Line 2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;

2143: --
2144: l_proc varchar2(72) := g_package||'update_offer';
2145: l_object_version_number irc_offers.object_version_number%TYPE;
2146: l_effective_date date;
2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

Line 2148: l_expiry_date irc_offers.expiry_date%TYPE;

2144: l_proc varchar2(72) := g_package||'update_offer';
2145: l_object_version_number irc_offers.object_version_number%TYPE;
2146: l_effective_date date;
2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

Line 2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;

2145: l_object_version_number irc_offers.object_version_number%TYPE;
2146: l_effective_date date;
2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;

Line 2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;

2146: l_effective_date date;
2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

Line 2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

2147: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;

Line 2153: l_prev_offer_status irc_offers.offer_status%TYPE;

2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

Line 2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;

Line 2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;

2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;

Line 2159: l_offer_version irc_offers.offer_version%TYPE;

2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;
2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;
2161: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2162:
2163: l_create_new_version boolean := false;

Line 2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;

2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;
2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;
2161: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2162:
2163: l_create_new_version boolean := false;
2164: l_other_extended_offer_count number := 0;

Line 2161: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;
2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;
2161: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2162:
2163: l_create_new_version boolean := false;
2164: l_other_extended_offer_count number := 0;
2165: --

Line 2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

2170: l_org_now_no_manager_warning boolean;
2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

Line 2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;

Line 2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;

2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;

Line 2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;

2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;
2181: --

Line 2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;

2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;
2181: --
2182: -- Declare cursors

Line 2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;

2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;
2181: --
2182: -- Declare cursors
2183: --

Line 2193: from irc_offers

2189: ,offer_letter_tracking_code
2190: ,offer_postal_service
2191: ,offer_shipping_date
2192: ,object_version_number
2193: from irc_offers
2194: where offer_id = p_offer_id;
2195: --
2196: cursor csr_assignment_record is
2197: select object_version_number

Line 2274: from irc_offers

2270: ,attribute27
2271: ,attribute28
2272: ,attribute29
2273: ,attribute30
2274: from irc_offers
2275: where offer_id = p_offer_id;
2276:
2277: l_offer_record csr_offer_record%ROWTYPE;
2278: l_temp_offer_record csr_offer_record%ROWTYPE;

Line 2774: IRC_OFFERS_BK2.update_offer_b

2770: --
2771: -- Proceed with normal Update.
2772: --
2773: begin
2774: IRC_OFFERS_BK2.update_offer_b
2775: ( P_EFFECTIVE_DATE => l_effective_date
2776: , P_OFFER_ID => P_OFFER_ID
2777: , P_LATEST_OFFER => l_latest_offer
2778: , P_OFFER_STATUS => l_offer_status

Line 3187: irc_offers_api.update_appl_assg_status

3183: -- to set the appropriate Assignment Status for the application.
3184: --
3185: hr_utility.set_location(l_proc,141);
3186: --
3187: irc_offers_api.update_appl_assg_status
3188: ( p_validate => p_validate
3189: , p_effective_date => l_effective_date
3190: , p_applicant_assignment_id => l_prev_applicant_assignment_id
3191: , p_offer_status => l_offer_status

Line 3289: IRC_OFFERS_BK2.update_offer_a

3285: --
3286: -- Call After Process User Hook
3287: --
3288: begin
3289: IRC_OFFERS_BK2.update_offer_a
3290: ( P_EFFECTIVE_DATE => l_effective_date
3291: , P_OFFER_ID => P_OFFER_ID
3292: , P_OFFER_VERSION => l_offer_version
3293: , P_LATEST_OFFER => l_latest_offer

Line 3418: l_offer_id irc_offers.offer_id%TYPE;

3414: --
3415: -- Declare cursors and local variables
3416: --
3417: l_proc varchar2(72) := g_package||'delete_offer';
3418: l_offer_id irc_offers.offer_id%TYPE;
3419: l_prev_offer_status irc_offers.offer_status%TYPE;
3420: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3422: l_effective_date date;

Line 3419: l_prev_offer_status irc_offers.offer_status%TYPE;

3415: -- Declare cursors and local variables
3416: --
3417: l_proc varchar2(72) := g_package||'delete_offer';
3418: l_offer_id irc_offers.offer_id%TYPE;
3419: l_prev_offer_status irc_offers.offer_status%TYPE;
3420: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3422: l_effective_date date;
3423: l_validation_start_date date;

Line 3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3422: l_effective_date date;
3423: l_validation_start_date date;
3424: l_validation_end_date date;
3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3426: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
3427: l_offer_status irc_offers.offer_status%TYPE;
3428: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3429: l_asg_object_version_number number(9);

Line 3426: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

3422: l_effective_date date;
3423: l_validation_start_date date;
3424: l_validation_end_date date;
3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3426: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
3427: l_offer_status irc_offers.offer_status%TYPE;
3428: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3429: l_asg_object_version_number number(9);
3430: l_org_now_no_manager_warning boolean;

Line 3427: l_offer_status irc_offers.offer_status%TYPE;

3423: l_validation_start_date date;
3424: l_validation_end_date date;
3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3426: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
3427: l_offer_status irc_offers.offer_status%TYPE;
3428: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3429: l_asg_object_version_number number(9);
3430: l_org_now_no_manager_warning boolean;
3431: --

Line 3436: from irc_offers

3432: cursor csr_prev_offer_rec is
3433: select offer_status
3434: ,applicant_assignment_id
3435: ,offer_assignment_id
3436: from irc_offers
3437: where offer_id = p_offer_id;
3438: --
3439: l_prev_offer_rec csr_prev_offer_rec%ROWTYPE;
3440: --

Line 3444: from irc_offers

3440: --
3441: cursor csr_latest_offer is
3442: select offer_id
3443: ,offer_status
3444: from irc_offers
3445: where applicant_assignment_id = l_applicant_assignment_id
3446: and offer_version = ( select max(offer_version) from irc_offers
3447: where applicant_assignment_id = l_applicant_assignment_id );
3448: --

Line 3446: and offer_version = ( select max(offer_version) from irc_offers

3442: select offer_id
3443: ,offer_status
3444: from irc_offers
3445: where applicant_assignment_id = l_applicant_assignment_id
3446: and offer_version = ( select max(offer_version) from irc_offers
3447: where applicant_assignment_id = l_applicant_assignment_id );
3448: --
3449: cursor csr_assignment_ovn is
3450: select object_version_number

Line 3494: IRC_OFFERS_BK3.delete_offer_b

3490: --
3491: -- Call Before Process User Hook
3492: --
3493: begin
3494: IRC_OFFERS_BK3.delete_offer_b
3495: (
3496: P_OBJECT_VERSION_NUMBER
3497: ,P_OFFER_ID
3498: );

Line 3605: IRC_OFFERS_BK3.delete_offer_a

3601: --
3602: -- Call After Process User Hook
3603: --
3604: begin
3605: IRC_OFFERS_BK3.delete_offer_a
3606: (
3607: P_OBJECT_VERSION_NUMBER
3608: ,P_OFFER_ID
3609: );

Line 3745: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE := null;

3741: ,P_STATUS_CHANGE_DATE IN date default null
3742: ) Is
3743: --
3744: l_proc varchar2(72) := g_package||'close_offer';
3745: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE := null;
3746: l_offer_id irc_offers.offer_id%TYPE := null;
3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;

Line 3746: l_offer_id irc_offers.offer_id%TYPE := null;

3742: ) Is
3743: --
3744: l_proc varchar2(72) := g_package||'close_offer';
3745: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE := null;
3746: l_offer_id irc_offers.offer_id%TYPE := null;
3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;
3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;

Line 3747: l_prev_offer_status irc_offers.offer_status%TYPE;

3743: --
3744: l_proc varchar2(72) := g_package||'close_offer';
3745: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE := null;
3746: l_offer_id irc_offers.offer_id%TYPE := null;
3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;
3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3751: l_change_reason irc_offer_status_history.change_reason%TYPE;

Line 3748: l_offer_version irc_offers.offer_version%TYPE;

3744: l_proc varchar2(72) := g_package||'close_offer';
3745: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE := null;
3746: l_offer_id irc_offers.offer_id%TYPE := null;
3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;
3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3751: l_change_reason irc_offer_status_history.change_reason%TYPE;
3752: -- Date variables

Line 3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;

3746: l_offer_id irc_offers.offer_id%TYPE := null;
3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;
3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3751: l_change_reason irc_offer_status_history.change_reason%TYPE;
3752: -- Date variables
3753: l_effective_date date;
3754: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

Line 3760: from irc_offers

3756: cursor csr_offer_assignment_1 is
3757: select offer_assignment_id
3758: ,offer_id
3759: ,offer_status
3760: from irc_offers
3761: where applicant_assignment_id = p_applicant_assignment_id
3762: and latest_offer = 'Y';
3763: --
3764: cursor csr_saved_offers is

Line 3767: from irc_offers

3763: --
3764: cursor csr_saved_offers is
3765: select offer_id
3766: ,object_version_number
3767: from irc_offers
3768: where applicant_assignment_id = p_applicant_assignment_id
3769: and offer_status = 'SAVED';
3770: --
3771: cursor csr_offer_assignment_2 is

Line 3774: from irc_offers

3770: --
3771: cursor csr_offer_assignment_2 is
3772: select offer_assignment_id
3773: ,offer_status
3774: from irc_offers
3775: where offer_id = p_offer_id;
3776: --
3777: cursor csr_iof_object_version_number is
3778: select object_version_number

Line 3779: from irc_offers

3775: where offer_id = p_offer_id;
3776: --
3777: cursor csr_iof_object_version_number is
3778: select object_version_number
3779: from irc_offers
3780: where offer_id = l_offer_id;
3781: --
3782: Begin
3783: --

Line 3890: -- Update the offer record in IRC_OFFERS and set the offer_status to

3886: else
3887: l_change_reason := p_change_reason;
3888: end if;
3889: --
3890: -- Update the offer record in IRC_OFFERS and set the offer_status to
3891: -- Closed and end date the offer assignment.
3892: -- Do this only if the offer is previously not in CLOSED status.
3893: -- Also do this if the change reason is MGR_WITHDRAW, APL_DECLINED_ACCEPTANCE, APL_HIRED
3894: if l_prev_offer_status <> 'CLOSED' or p_change_reason='MGR_WITHDRAW' or p_change_reason='APL_DECLINED_ACCEPTANCE' or p_change_reason='APL_HIRED'

Line 3997: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;

3993: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
3994: ) is
3995: --
3996: l_proc varchar2(72) := g_package||'hold_offer';
3997: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3998: l_offer_version irc_offers.offer_version%TYPE;
3999: --
4000: Begin
4001: hr_utility.set_location('Entering:'||l_proc,10);

Line 3998: l_offer_version irc_offers.offer_version%TYPE;

3994: ) is
3995: --
3996: l_proc varchar2(72) := g_package||'hold_offer';
3997: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3998: l_offer_version irc_offers.offer_version%TYPE;
3999: --
4000: Begin
4001: hr_utility.set_location('Entering:'||l_proc,10);
4002: --

Line 4040: l_prev_offer_status irc_offers.offer_status%TYPE;

4036: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
4037: ) is
4038: --
4039: l_proc varchar2(72) := g_package||'release_offer';
4040: l_prev_offer_status irc_offers.offer_status%TYPE;
4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;

Line 4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

4037: ) is
4038: --
4039: l_proc varchar2(72) := g_package||'release_offer';
4040: l_prev_offer_status irc_offers.offer_status%TYPE;
4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;

Line 4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

4038: --
4039: l_proc varchar2(72) := g_package||'release_offer';
4040: l_prev_offer_status irc_offers.offer_status%TYPE;
4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;

Line 4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;

4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
4049: l_other_extended_offer_count number := 0;

Line 4046: l_offer_version irc_offers.offer_version%TYPE;

4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
4049: l_other_extended_offer_count number := 0;
4050: l_prev_expiry_date irc_offers.expiry_date%TYPE;

Line 4050: l_prev_expiry_date irc_offers.expiry_date%TYPE;

4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
4049: l_other_extended_offer_count number := 0;
4050: l_prev_expiry_date irc_offers.expiry_date%TYPE;
4051: --
4052: cursor csr_prev_to_prev_offer_status is
4053: SELECT ios1.offer_status,
4054: ios1.change_reason,

Line 4078: from irc_offers

4074: cursor csr_prev_offer_status is
4075: select offer_status
4076: ,applicant_assignment_id
4077: ,expiry_date
4078: from irc_offers
4079: where offer_id = p_offer_id;
4080: --
4081: Begin
4082: --

Line 4722: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;

4718: l_org_now_no_manager_warning boolean;
4719: l_validation_start_date date;
4720: l_validation_end_date date;
4721: l_effective_date date;
4722: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4723:
4724: l_prev_offer_status irc_offers.offer_status%TYPE;
4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4726: l_offer_version irc_offers.offer_version%TYPE;

Line 4724: l_prev_offer_status irc_offers.offer_status%TYPE;

4720: l_validation_end_date date;
4721: l_effective_date date;
4722: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4723:
4724: l_prev_offer_status irc_offers.offer_status%TYPE;
4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4726: l_offer_version irc_offers.offer_version%TYPE;
4727: l_datetrack_mode varchar2(30) := hr_api.g_update;
4728: --

Line 4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;

4721: l_effective_date date;
4722: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4723:
4724: l_prev_offer_status irc_offers.offer_status%TYPE;
4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4726: l_offer_version irc_offers.offer_version%TYPE;
4727: l_datetrack_mode varchar2(30) := hr_api.g_update;
4728: --
4729: cursor csr_prev_offer_details is

Line 4726: l_offer_version irc_offers.offer_version%TYPE;

4722: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4723:
4724: l_prev_offer_status irc_offers.offer_status%TYPE;
4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4726: l_offer_version irc_offers.offer_version%TYPE;
4727: l_datetrack_mode varchar2(30) := hr_api.g_update;
4728: --
4729: cursor csr_prev_offer_details is
4730: select offer_status

Line 4732: from irc_offers

4728: --
4729: cursor csr_prev_offer_details is
4730: select offer_status
4731: ,offer_assignment_id
4732: from irc_offers
4733: where offer_id = p_offer_id;
4734: --
4735: cursor csr_asg_effective_start_date is
4736: select effective_start_date

Line 4793: from irc_offers

4789: ,attribute27
4790: ,attribute28
4791: ,attribute29
4792: ,attribute30
4793: from irc_offers
4794: where offer_id = p_offer_id;
4795:
4796: l_offer_record csr_offer_record%ROWTYPE;
4797: --

Line 5206: l_offer_id irc_offers.offer_id%TYPE;

5202: ,P_OFFER_ASSIGNMENT_ID IN number
5203: ) Is
5204: --
5205: l_proc varchar2(72) := g_package||'delete_offer_assignment';
5206: l_offer_id irc_offers.offer_id%TYPE;
5207: l_offer_object_version_number irc_offers.object_version_number%TYPE;
5208: --
5209: cursor csr_offer_id is
5210: select offer_id

Line 5207: l_offer_object_version_number irc_offers.object_version_number%TYPE;

5203: ) Is
5204: --
5205: l_proc varchar2(72) := g_package||'delete_offer_assignment';
5206: l_offer_id irc_offers.offer_id%TYPE;
5207: l_offer_object_version_number irc_offers.object_version_number%TYPE;
5208: --
5209: cursor csr_offer_id is
5210: select offer_id
5211: ,object_version_number

Line 5212: from irc_offers

5208: --
5209: cursor csr_offer_id is
5210: select offer_id
5211: ,object_version_number
5212: from irc_offers
5213: where offer_assignment_id = p_offer_assignment_id;
5214: --
5215: Begin
5216: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5337: end IRC_OFFERS_API;

5333: hr_utility.set_location(' Leaving:'||l_proc, 60);
5334: raise;
5335: end upload_offer_letter;
5336: --
5337: end IRC_OFFERS_API;