1: PACKAGE BODY PER_ASSIGNMENTS_F1_PKG AS
2: /* $Header: peasg01t.pkb 120.50.12020000.8 2013/02/06 07:35:03 srannama ship $ */
3: --
4: g_package varchar2(33) := 'per_assignments_f1_pkg.'; -- Global package name
5: g_debug boolean; -- debug flag
1: PACKAGE BODY PER_ASSIGNMENTS_F1_PKG AS
2: /* $Header: peasg01t.pkb 120.50.12020000.8 2013/02/06 07:35:03 srannama ship $ */
3: --
4: g_package varchar2(33) := 'per_assignments_f1_pkg.'; -- Global package name
5: g_debug boolean; -- debug flag
6: --
7: -----------------------------------------------------------------------------
8: --
349: if sql%rowcount = 0 then
350: fnd_message.set_name('PAY',
351: 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE',
353: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
354: fnd_message.set_token('STEP', '1');
355: fnd_message.raise_error;
356: end if;
357: */
538: if sql%rowcount = 0 then
539: fnd_message.set_name('PAY',
540: 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE',
542: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
543: fnd_message.set_token('STEP', '1');
544: fnd_message.raise_error;
545: end if;
546: end if;
687: p_sess_date date,
688: p_val_st_date date) is
689: l_start_date date;
690: begin
691: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.terminate_entries' , 5);
692: if p_per_sys_st = 'END' then
693: l_start_date := p_sess_date;
694: else
695: l_start_date := p_val_st_date;
711: -- This is to ensure that assignments cannot be 'opened up' past the Period
712: -- of Service End Date.
713: --
714: begin
715: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
716:
717: update per_assignments_f a
718: set a.effective_end_date = P_NEW_END_DATE
719: where a.assignment_id = P_ASS_ID
713: --
714: begin
715: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
716:
717: update per_assignments_f a
718: set a.effective_end_date = P_NEW_END_DATE
719: where a.assignment_id = P_ASS_ID
720: and a.effective_end_date = (
721: select max(a2.effective_end_date)
718: set a.effective_end_date = P_NEW_END_DATE
719: where a.assignment_id = P_ASS_ID
720: and a.effective_end_date = (
721: select max(a2.effective_end_date)
722: from per_assignments_f a2
723: where a2.assignment_id = a.assignment_id);
724: end set_end_date;
725: -----------------------------------------------------------------------------
726: procedure maintain_entries(
752: -- Maintain element entries for insert/update/delete
753: --
754: begin
755: --
756: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
757: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
758: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
759:
760: if p_dt_upd_mode is null then
792: if l_mode = 'DELETE' then
793: l_val_start_date := l_val_start_date + 1;
794: end if;
795: --
796: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',2);
797:
798: hrentmnt.maintain_entries_asg(
799: P_ASSIGNMENT_ID => p_ass_id,
800: P_OLD_PAYROLL_ID => p_old_pay_id,
1772: ,P_PO_HEADER_ID => cur_asg_rec.po_header_id
1773: ,P_PO_LINE_ID => cur_asg_rec.po_line_id
1774: ,P_PROJECTED_ASSIGNMENT_END => cur_asg_rec.projected_assignment_end
1775: ,P_APPLICANT_RANK_O
1776: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1777: ,P_APPLICATION_ID_O
1778: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1779: ,P_ASSIGNMENT_CATEGORY_O
1780: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1774: ,P_PROJECTED_ASSIGNMENT_END => cur_asg_rec.projected_assignment_end
1775: ,P_APPLICANT_RANK_O
1776: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1777: ,P_APPLICATION_ID_O
1778: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1779: ,P_ASSIGNMENT_CATEGORY_O
1780: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1781: ,P_ASSIGNMENT_NUMBER_O
1782: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1776: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1777: ,P_APPLICATION_ID_O
1778: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1779: ,P_ASSIGNMENT_CATEGORY_O
1780: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1781: ,P_ASSIGNMENT_NUMBER_O
1782: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1783: ,P_ASSIGNMENT_SEQUENCE_O
1784: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1778: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1779: ,P_ASSIGNMENT_CATEGORY_O
1780: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1781: ,P_ASSIGNMENT_NUMBER_O
1782: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1783: ,P_ASSIGNMENT_SEQUENCE_O
1784: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1785: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1786: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1780: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1781: ,P_ASSIGNMENT_NUMBER_O
1782: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1783: ,P_ASSIGNMENT_SEQUENCE_O
1784: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1785: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1786: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1787: ,P_ASSIGNMENT_TYPE_O
1788: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1782: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1783: ,P_ASSIGNMENT_SEQUENCE_O
1784: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1785: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1786: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1787: ,P_ASSIGNMENT_TYPE_O
1788: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1789: ,P_ASS_ATTRIBUTE1_O
1790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1784: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1785: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1786: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1787: ,P_ASSIGNMENT_TYPE_O
1788: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1789: ,P_ASS_ATTRIBUTE1_O
1790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1791: ,P_ASS_ATTRIBUTE10_O
1792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1786: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1787: ,P_ASSIGNMENT_TYPE_O
1788: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1789: ,P_ASS_ATTRIBUTE1_O
1790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1791: ,P_ASS_ATTRIBUTE10_O
1792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1793: ,P_ASS_ATTRIBUTE11_O
1794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1788: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1789: ,P_ASS_ATTRIBUTE1_O
1790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1791: ,P_ASS_ATTRIBUTE10_O
1792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1793: ,P_ASS_ATTRIBUTE11_O
1794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1795: ,P_ASS_ATTRIBUTE12_O
1796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1791: ,P_ASS_ATTRIBUTE10_O
1792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1793: ,P_ASS_ATTRIBUTE11_O
1794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1795: ,P_ASS_ATTRIBUTE12_O
1796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1797: ,P_ASS_ATTRIBUTE13_O
1798: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1793: ,P_ASS_ATTRIBUTE11_O
1794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1795: ,P_ASS_ATTRIBUTE12_O
1796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1797: ,P_ASS_ATTRIBUTE13_O
1798: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1799: ,P_ASS_ATTRIBUTE14_O
1800: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1795: ,P_ASS_ATTRIBUTE12_O
1796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1797: ,P_ASS_ATTRIBUTE13_O
1798: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1799: ,P_ASS_ATTRIBUTE14_O
1800: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1801: ,P_ASS_ATTRIBUTE15_O
1802: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1797: ,P_ASS_ATTRIBUTE13_O
1798: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1799: ,P_ASS_ATTRIBUTE14_O
1800: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1801: ,P_ASS_ATTRIBUTE15_O
1802: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1803: ,P_ASS_ATTRIBUTE16_O
1804: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1798: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1799: ,P_ASS_ATTRIBUTE14_O
1800: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1801: ,P_ASS_ATTRIBUTE15_O
1802: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1803: ,P_ASS_ATTRIBUTE16_O
1804: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1805: ,P_ASS_ATTRIBUTE17_O
1806: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1800: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1801: ,P_ASS_ATTRIBUTE15_O
1802: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1803: ,P_ASS_ATTRIBUTE16_O
1804: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1805: ,P_ASS_ATTRIBUTE17_O
1806: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1807: ,P_ASS_ATTRIBUTE18_O
1808: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1802: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1803: ,P_ASS_ATTRIBUTE16_O
1804: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1805: ,P_ASS_ATTRIBUTE17_O
1806: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1807: ,P_ASS_ATTRIBUTE18_O
1808: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1809: ,P_ASS_ATTRIBUTE19_O
1810: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1804: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1805: ,P_ASS_ATTRIBUTE17_O
1806: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1807: ,P_ASS_ATTRIBUTE18_O
1808: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1809: ,P_ASS_ATTRIBUTE19_O
1810: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1811: ,P_ASS_ATTRIBUTE2_O
1812: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1806: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1807: ,P_ASS_ATTRIBUTE18_O
1808: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1809: ,P_ASS_ATTRIBUTE19_O
1810: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1811: ,P_ASS_ATTRIBUTE2_O
1812: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1813: ,P_ASS_ATTRIBUTE20_O
1814: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1808: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1809: ,P_ASS_ATTRIBUTE19_O
1810: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1811: ,P_ASS_ATTRIBUTE2_O
1812: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1813: ,P_ASS_ATTRIBUTE20_O
1814: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1815: ,P_ASS_ATTRIBUTE21_O
1816: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1810: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1811: ,P_ASS_ATTRIBUTE2_O
1812: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1813: ,P_ASS_ATTRIBUTE20_O
1814: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1815: ,P_ASS_ATTRIBUTE21_O
1816: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1817: ,P_ASS_ATTRIBUTE22_O
1818: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1812: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1813: ,P_ASS_ATTRIBUTE20_O
1814: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1815: ,P_ASS_ATTRIBUTE21_O
1816: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1817: ,P_ASS_ATTRIBUTE22_O
1818: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1819: ,P_ASS_ATTRIBUTE23_O
1820: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1814: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1815: ,P_ASS_ATTRIBUTE21_O
1816: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1817: ,P_ASS_ATTRIBUTE22_O
1818: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1819: ,P_ASS_ATTRIBUTE23_O
1820: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1821: ,P_ASS_ATTRIBUTE24_O
1822: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1816: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1817: ,P_ASS_ATTRIBUTE22_O
1818: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1819: ,P_ASS_ATTRIBUTE23_O
1820: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1821: ,P_ASS_ATTRIBUTE24_O
1822: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1823: ,P_ASS_ATTRIBUTE25_O
1824: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1818: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1819: ,P_ASS_ATTRIBUTE23_O
1820: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1821: ,P_ASS_ATTRIBUTE24_O
1822: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1823: ,P_ASS_ATTRIBUTE25_O
1824: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1825: ,P_ASS_ATTRIBUTE26_O
1826: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1820: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1821: ,P_ASS_ATTRIBUTE24_O
1822: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1823: ,P_ASS_ATTRIBUTE25_O
1824: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1825: ,P_ASS_ATTRIBUTE26_O
1826: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1827: ,P_ASS_ATTRIBUTE27_O
1828: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1822: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1823: ,P_ASS_ATTRIBUTE25_O
1824: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1825: ,P_ASS_ATTRIBUTE26_O
1826: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1827: ,P_ASS_ATTRIBUTE27_O
1828: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1829: ,P_ASS_ATTRIBUTE28_O
1830: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1824: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1825: ,P_ASS_ATTRIBUTE26_O
1826: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1827: ,P_ASS_ATTRIBUTE27_O
1828: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1829: ,P_ASS_ATTRIBUTE28_O
1830: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1831: ,P_ASS_ATTRIBUTE29_O
1832: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1826: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1827: ,P_ASS_ATTRIBUTE27_O
1828: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1829: ,P_ASS_ATTRIBUTE28_O
1830: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1831: ,P_ASS_ATTRIBUTE29_O
1832: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1833: ,P_ASS_ATTRIBUTE3_O
1834: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1828: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1829: ,P_ASS_ATTRIBUTE28_O
1830: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1831: ,P_ASS_ATTRIBUTE29_O
1832: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1833: ,P_ASS_ATTRIBUTE3_O
1834: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1835: ,P_ASS_ATTRIBUTE30_O
1836: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1830: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1831: ,P_ASS_ATTRIBUTE29_O
1832: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1833: ,P_ASS_ATTRIBUTE3_O
1834: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1835: ,P_ASS_ATTRIBUTE30_O
1836: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1837: ,P_ASS_ATTRIBUTE4_O
1838: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1832: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1833: ,P_ASS_ATTRIBUTE3_O
1834: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1835: ,P_ASS_ATTRIBUTE30_O
1836: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1837: ,P_ASS_ATTRIBUTE4_O
1838: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1839: ,P_ASS_ATTRIBUTE5_O
1840: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1834: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1835: ,P_ASS_ATTRIBUTE30_O
1836: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1837: ,P_ASS_ATTRIBUTE4_O
1838: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1839: ,P_ASS_ATTRIBUTE5_O
1840: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1841: ,P_ASS_ATTRIBUTE6_O
1842: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1836: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1837: ,P_ASS_ATTRIBUTE4_O
1838: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1839: ,P_ASS_ATTRIBUTE5_O
1840: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1841: ,P_ASS_ATTRIBUTE6_O
1842: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1843: ,P_ASS_ATTRIBUTE7_O
1844: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1838: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1839: ,P_ASS_ATTRIBUTE5_O
1840: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1841: ,P_ASS_ATTRIBUTE6_O
1842: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1843: ,P_ASS_ATTRIBUTE7_O
1844: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1845: ,P_ASS_ATTRIBUTE8_O
1846: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1840: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1841: ,P_ASS_ATTRIBUTE6_O
1842: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1843: ,P_ASS_ATTRIBUTE7_O
1844: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1845: ,P_ASS_ATTRIBUTE8_O
1846: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1847: ,P_ASS_ATTRIBUTE9_O
1848: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1842: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1843: ,P_ASS_ATTRIBUTE7_O
1844: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1845: ,P_ASS_ATTRIBUTE8_O
1846: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1847: ,P_ASS_ATTRIBUTE9_O
1848: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1849: ,P_ASS_ATTRIBUTE_CATEGORY_O
1850: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1844: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1845: ,P_ASS_ATTRIBUTE8_O
1846: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1847: ,P_ASS_ATTRIBUTE9_O
1848: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1849: ,P_ASS_ATTRIBUTE_CATEGORY_O
1850: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1851: ,P_BARGAINING_UNIT_CODE_O
1852: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1846: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1847: ,P_ASS_ATTRIBUTE9_O
1848: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1849: ,P_ASS_ATTRIBUTE_CATEGORY_O
1850: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1851: ,P_BARGAINING_UNIT_CODE_O
1852: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1853: ,P_BUSINESS_GROUP_ID_O
1854: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1848: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1849: ,P_ASS_ATTRIBUTE_CATEGORY_O
1850: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1851: ,P_BARGAINING_UNIT_CODE_O
1852: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1853: ,P_BUSINESS_GROUP_ID_O
1854: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1855: ,P_CAGR_GRADE_DEF_ID_O
1856: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1850: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1851: ,P_BARGAINING_UNIT_CODE_O
1852: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1853: ,P_BUSINESS_GROUP_ID_O
1854: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1855: ,P_CAGR_GRADE_DEF_ID_O
1856: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1857: ,P_CAGR_ID_FLEX_NUM_O
1858: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1852: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1853: ,P_BUSINESS_GROUP_ID_O
1854: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1855: ,P_CAGR_GRADE_DEF_ID_O
1856: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1857: ,P_CAGR_ID_FLEX_NUM_O
1858: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1859: ,P_CHANGE_REASON_O
1860: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1854: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1855: ,P_CAGR_GRADE_DEF_ID_O
1856: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1857: ,P_CAGR_ID_FLEX_NUM_O
1858: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1859: ,P_CHANGE_REASON_O
1860: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1861: ,P_COLLECTIVE_AGREEMENT_ID_O
1862: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1856: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1857: ,P_CAGR_ID_FLEX_NUM_O
1858: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1859: ,P_CHANGE_REASON_O
1860: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1861: ,P_COLLECTIVE_AGREEMENT_ID_O
1862: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1863: ,P_COMMENT_ID_O
1864: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1858: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1859: ,P_CHANGE_REASON_O
1860: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1861: ,P_COLLECTIVE_AGREEMENT_ID_O
1862: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1863: ,P_COMMENT_ID_O
1864: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1865: ,P_CONTRACT_ID_O
1866: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1860: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1861: ,P_COLLECTIVE_AGREEMENT_ID_O
1862: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1863: ,P_COMMENT_ID_O
1864: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1865: ,P_CONTRACT_ID_O
1866: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1867: ,P_DATE_PROBATION_END_O
1868: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1862: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1863: ,P_COMMENT_ID_O
1864: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1865: ,P_CONTRACT_ID_O
1866: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1867: ,P_DATE_PROBATION_END_O
1868: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1869: ,P_DEFAULT_CODE_COMB_ID_O
1870: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1864: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1865: ,P_CONTRACT_ID_O
1866: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1867: ,P_DATE_PROBATION_END_O
1868: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1869: ,P_DEFAULT_CODE_COMB_ID_O
1870: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1871: ,P_EFFECTIVE_END_DATE_O
1872: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1866: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1867: ,P_DATE_PROBATION_END_O
1868: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1869: ,P_DEFAULT_CODE_COMB_ID_O
1870: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1871: ,P_EFFECTIVE_END_DATE_O
1872: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1873: ,P_EFFECTIVE_START_DATE_O
1874: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1868: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1869: ,P_DEFAULT_CODE_COMB_ID_O
1870: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1871: ,P_EFFECTIVE_END_DATE_O
1872: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1873: ,P_EFFECTIVE_START_DATE_O
1874: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1875: ,P_EMPLOYEE_CATEGORY_O
1876: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1870: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1871: ,P_EFFECTIVE_END_DATE_O
1872: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1873: ,P_EFFECTIVE_START_DATE_O
1874: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1875: ,P_EMPLOYEE_CATEGORY_O
1876: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1877: ,P_EMPLOYMENT_CATEGORY_O
1878: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1872: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1873: ,P_EFFECTIVE_START_DATE_O
1874: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1875: ,P_EMPLOYEE_CATEGORY_O
1876: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1877: ,P_EMPLOYMENT_CATEGORY_O
1878: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1879: ,P_ESTABLISHMENT_ID_O
1880: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1874: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1875: ,P_EMPLOYEE_CATEGORY_O
1876: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1877: ,P_EMPLOYMENT_CATEGORY_O
1878: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1879: ,P_ESTABLISHMENT_ID_O
1880: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1881: ,P_FREQUENCY_O
1882: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1876: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1877: ,P_EMPLOYMENT_CATEGORY_O
1878: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1879: ,P_ESTABLISHMENT_ID_O
1880: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1881: ,P_FREQUENCY_O
1882: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1883: ,P_GRADE_ID_O
1884: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1878: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1879: ,P_ESTABLISHMENT_ID_O
1880: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1881: ,P_FREQUENCY_O
1882: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1883: ,P_GRADE_ID_O
1884: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1885: ,P_HOURLY_SALARIED_CODE_O
1886: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1880: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1881: ,P_FREQUENCY_O
1882: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1883: ,P_GRADE_ID_O
1884: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1885: ,P_HOURLY_SALARIED_CODE_O
1886: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1887: ,P_INTERNAL_ADDRESS_LINE_O
1888: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1882: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1883: ,P_GRADE_ID_O
1884: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1885: ,P_HOURLY_SALARIED_CODE_O
1886: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1887: ,P_INTERNAL_ADDRESS_LINE_O
1888: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1889: ,P_JOB_ID_O
1890: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1884: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1885: ,P_HOURLY_SALARIED_CODE_O
1886: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1887: ,P_INTERNAL_ADDRESS_LINE_O
1888: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1889: ,P_JOB_ID_O
1890: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1891: ,P_JOB_POST_SOURCE_NAME_O
1892: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1886: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1887: ,P_INTERNAL_ADDRESS_LINE_O
1888: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1889: ,P_JOB_ID_O
1890: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1891: ,P_JOB_POST_SOURCE_NAME_O
1892: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1893: ,P_LABOUR_UNION_MEMBER_FLAG_O
1894: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1888: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1889: ,P_JOB_ID_O
1890: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1891: ,P_JOB_POST_SOURCE_NAME_O
1892: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1893: ,P_LABOUR_UNION_MEMBER_FLAG_O
1894: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1895: ,P_LOCATION_ID_O
1896: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1890: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1891: ,P_JOB_POST_SOURCE_NAME_O
1892: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1893: ,P_LABOUR_UNION_MEMBER_FLAG_O
1894: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1895: ,P_LOCATION_ID_O
1896: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1897: ,P_MANAGER_FLAG_O
1898: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1892: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1893: ,P_LABOUR_UNION_MEMBER_FLAG_O
1894: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1895: ,P_LOCATION_ID_O
1896: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1897: ,P_MANAGER_FLAG_O
1898: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1899: ,P_NORMAL_HOURS_O
1900: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1894: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1895: ,P_LOCATION_ID_O
1896: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1897: ,P_MANAGER_FLAG_O
1898: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1899: ,P_NORMAL_HOURS_O
1900: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1901: ,P_NOTICE_PERIOD_O
1902: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1896: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1897: ,P_MANAGER_FLAG_O
1898: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1899: ,P_NORMAL_HOURS_O
1900: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1901: ,P_NOTICE_PERIOD_O
1902: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1903: ,P_NOTICE_PERIOD_UOM_O
1904: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1898: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1899: ,P_NORMAL_HOURS_O
1900: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1901: ,P_NOTICE_PERIOD_O
1902: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1903: ,P_NOTICE_PERIOD_UOM_O
1904: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1905: ,P_OBJECT_VERSION_NUMBER_O
1906: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1900: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1901: ,P_NOTICE_PERIOD_O
1902: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1903: ,P_NOTICE_PERIOD_UOM_O
1904: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1905: ,P_OBJECT_VERSION_NUMBER_O
1906: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1907: ,P_ORGANIZATION_ID_O
1908: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1902: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1903: ,P_NOTICE_PERIOD_UOM_O
1904: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1905: ,P_OBJECT_VERSION_NUMBER_O
1906: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1907: ,P_ORGANIZATION_ID_O
1908: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1909: ,P_PAYROLL_ID_O
1910: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1904: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1905: ,P_OBJECT_VERSION_NUMBER_O
1906: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1907: ,P_ORGANIZATION_ID_O
1908: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1909: ,P_PAYROLL_ID_O
1910: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1911: ,P_PAY_BASIS_ID_O
1912: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1906: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1907: ,P_ORGANIZATION_ID_O
1908: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1909: ,P_PAYROLL_ID_O
1910: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1911: ,P_PAY_BASIS_ID_O
1912: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1913: ,P_PEOPLE_GROUP_ID_O
1914: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1908: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1909: ,P_PAYROLL_ID_O
1910: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1911: ,P_PAY_BASIS_ID_O
1912: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1913: ,P_PEOPLE_GROUP_ID_O
1914: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1915: ,P_PERF_REVIEW_PERIOD_O
1916: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1910: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1911: ,P_PAY_BASIS_ID_O
1912: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1913: ,P_PEOPLE_GROUP_ID_O
1914: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1915: ,P_PERF_REVIEW_PERIOD_O
1916: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1917: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1918: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1912: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1913: ,P_PEOPLE_GROUP_ID_O
1914: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1915: ,P_PERF_REVIEW_PERIOD_O
1916: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1917: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1918: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1919: ,P_PERIOD_OF_SERVICE_ID_O
1920: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1914: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1915: ,P_PERF_REVIEW_PERIOD_O
1916: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1917: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1918: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1919: ,P_PERIOD_OF_SERVICE_ID_O
1920: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1921: ,P_PERSON_ID_O
1922: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1916: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1917: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1918: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1919: ,P_PERIOD_OF_SERVICE_ID_O
1920: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1921: ,P_PERSON_ID_O
1922: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1923: ,P_PERSON_REFERRED_BY_ID_O
1924: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1918: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1919: ,P_PERIOD_OF_SERVICE_ID_O
1920: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1921: ,P_PERSON_ID_O
1922: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1923: ,P_PERSON_REFERRED_BY_ID_O
1924: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1925: ,P_PLACEMENT_DATE_START_O
1926: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1920: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1921: ,P_PERSON_ID_O
1922: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1923: ,P_PERSON_REFERRED_BY_ID_O
1924: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1925: ,P_PLACEMENT_DATE_START_O
1926: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1927: ,P_POSITION_ID_O
1928: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1922: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1923: ,P_PERSON_REFERRED_BY_ID_O
1924: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1925: ,P_PLACEMENT_DATE_START_O
1926: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1927: ,P_POSITION_ID_O
1928: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1929: ,P_POSTING_CONTENT_ID_O
1930: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1924: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1925: ,P_PLACEMENT_DATE_START_O
1926: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1927: ,P_POSITION_ID_O
1928: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1929: ,P_POSTING_CONTENT_ID_O
1930: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1931: ,P_PRIMARY_FLAG_O
1932: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1926: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1927: ,P_POSITION_ID_O
1928: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1929: ,P_POSTING_CONTENT_ID_O
1930: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1931: ,P_PRIMARY_FLAG_O
1932: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1933: ,P_PROBATION_PERIOD_O
1934: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1928: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1929: ,P_POSTING_CONTENT_ID_O
1930: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1931: ,P_PRIMARY_FLAG_O
1932: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1933: ,P_PROBATION_PERIOD_O
1934: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1935: ,P_PROBATION_UNIT_O
1936: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1930: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1931: ,P_PRIMARY_FLAG_O
1932: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1933: ,P_PROBATION_PERIOD_O
1934: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1935: ,P_PROBATION_UNIT_O
1936: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1937: ,P_PROGRAM_APPLICATION_ID_O
1938: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1932: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1933: ,P_PROBATION_PERIOD_O
1934: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1935: ,P_PROBATION_UNIT_O
1936: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1937: ,P_PROGRAM_APPLICATION_ID_O
1938: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1939: ,P_PROGRAM_ID_O
1940: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1934: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1935: ,P_PROBATION_UNIT_O
1936: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1937: ,P_PROGRAM_APPLICATION_ID_O
1938: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1939: ,P_PROGRAM_ID_O
1940: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1941: ,P_PROGRAM_UPDATE_DATE_O
1942: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1936: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1937: ,P_PROGRAM_APPLICATION_ID_O
1938: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1939: ,P_PROGRAM_ID_O
1940: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1941: ,P_PROGRAM_UPDATE_DATE_O
1942: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1943: ,P_PROJECT_TITLE_O
1944: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1938: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1939: ,P_PROGRAM_ID_O
1940: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1941: ,P_PROGRAM_UPDATE_DATE_O
1942: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1943: ,P_PROJECT_TITLE_O
1944: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1945: ,P_RECRUITER_ID_O
1946: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1940: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1941: ,P_PROGRAM_UPDATE_DATE_O
1942: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1943: ,P_PROJECT_TITLE_O
1944: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1945: ,P_RECRUITER_ID_O
1946: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1947: ,P_RECRUITMENT_ACTIVITY_ID_O
1948: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1942: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1943: ,P_PROJECT_TITLE_O
1944: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1945: ,P_RECRUITER_ID_O
1946: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1947: ,P_RECRUITMENT_ACTIVITY_ID_O
1948: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1949: ,P_REQUEST_ID_O
1950: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1944: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1945: ,P_RECRUITER_ID_O
1946: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1947: ,P_RECRUITMENT_ACTIVITY_ID_O
1948: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1949: ,P_REQUEST_ID_O
1950: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1951: ,P_SAL_REVIEW_PERIOD_O
1952: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1946: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1947: ,P_RECRUITMENT_ACTIVITY_ID_O
1948: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1949: ,P_REQUEST_ID_O
1950: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1951: ,P_SAL_REVIEW_PERIOD_O
1952: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1953: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1954: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1948: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1949: ,P_REQUEST_ID_O
1950: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1951: ,P_SAL_REVIEW_PERIOD_O
1952: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1953: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1954: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1955: ,P_SET_OF_BOOKS_ID_O
1956: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1950: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1951: ,P_SAL_REVIEW_PERIOD_O
1952: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1953: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1954: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1955: ,P_SET_OF_BOOKS_ID_O
1956: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1957: ,P_SOFT_CODING_KEYFLEX_ID_O
1958: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1952: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1953: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1954: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1955: ,P_SET_OF_BOOKS_ID_O
1956: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1957: ,P_SOFT_CODING_KEYFLEX_ID_O
1958: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1959: ,P_SOURCE_ORGANIZATION_ID_O
1960: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1954: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1955: ,P_SET_OF_BOOKS_ID_O
1956: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1957: ,P_SOFT_CODING_KEYFLEX_ID_O
1958: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1959: ,P_SOURCE_ORGANIZATION_ID_O
1960: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1961: ,P_SOURCE_TYPE_O
1962: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1956: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1957: ,P_SOFT_CODING_KEYFLEX_ID_O
1958: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1959: ,P_SOURCE_ORGANIZATION_ID_O
1960: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1961: ,P_SOURCE_TYPE_O
1962: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1963: ,P_SPECIAL_CEILING_STEP_ID_O
1964: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1958: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1959: ,P_SOURCE_ORGANIZATION_ID_O
1960: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1961: ,P_SOURCE_TYPE_O
1962: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1963: ,P_SPECIAL_CEILING_STEP_ID_O
1964: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1965: ,P_SUPERVISOR_ID_O
1966: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1960: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1961: ,P_SOURCE_TYPE_O
1962: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1963: ,P_SPECIAL_CEILING_STEP_ID_O
1964: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1965: ,P_SUPERVISOR_ID_O
1966: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1967: ,P_TIME_NORMAL_FINISH_O
1968: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1962: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1963: ,P_SPECIAL_CEILING_STEP_ID_O
1964: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1965: ,P_SUPERVISOR_ID_O
1966: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1967: ,P_TIME_NORMAL_FINISH_O
1968: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1969: ,P_TIME_NORMAL_START_O
1970: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1964: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1965: ,P_SUPERVISOR_ID_O
1966: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1967: ,P_TIME_NORMAL_FINISH_O
1968: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1969: ,P_TIME_NORMAL_START_O
1970: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1971: ,P_TITLE_O
1972: => per_assignments_f2_pkg.g_old_asg_rec.title
1966: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1967: ,P_TIME_NORMAL_FINISH_O
1968: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1969: ,P_TIME_NORMAL_START_O
1970: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1971: ,P_TITLE_O
1972: => per_assignments_f2_pkg.g_old_asg_rec.title
1973: ,P_VACANCY_ID_O
1974: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1968: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1969: ,P_TIME_NORMAL_START_O
1970: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1971: ,P_TITLE_O
1972: => per_assignments_f2_pkg.g_old_asg_rec.title
1973: ,P_VACANCY_ID_O
1974: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1975: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1976: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1970: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1971: ,P_TITLE_O
1972: => per_assignments_f2_pkg.g_old_asg_rec.title
1973: ,P_VACANCY_ID_O
1974: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1975: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1976: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1977: ,P_VENDOR_EMPLOYEE_NUMBER_O
1978: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1972: => per_assignments_f2_pkg.g_old_asg_rec.title
1973: ,P_VACANCY_ID_O
1974: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1975: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1976: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1977: ,P_VENDOR_EMPLOYEE_NUMBER_O
1978: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1979: ,P_VENDOR_ID_O
1980: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1974: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1975: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1976: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1977: ,P_VENDOR_EMPLOYEE_NUMBER_O
1978: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1979: ,P_VENDOR_ID_O
1980: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1981: ,P_WORK_AT_HOME_O
1982: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1976: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1977: ,P_VENDOR_EMPLOYEE_NUMBER_O
1978: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1979: ,P_VENDOR_ID_O
1980: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1981: ,P_WORK_AT_HOME_O
1982: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1983: ,P_GRADE_LADDER_PGM_ID_O
1984: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1978: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1979: ,P_VENDOR_ID_O
1980: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1981: ,P_WORK_AT_HOME_O
1982: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1983: ,P_GRADE_LADDER_PGM_ID_O
1984: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1985: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1986: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1980: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1981: ,P_WORK_AT_HOME_O
1982: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1983: ,P_GRADE_LADDER_PGM_ID_O
1984: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1985: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1986: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1987: ,P_VENDOR_SITE_ID_O
1988: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1982: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1983: ,P_GRADE_LADDER_PGM_ID_O
1984: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1985: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1986: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1987: ,P_VENDOR_SITE_ID_O
1988: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1989: ,P_PO_HEADER_ID_O
1990: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1984: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1985: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1986: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1987: ,P_VENDOR_SITE_ID_O
1988: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1989: ,P_PO_HEADER_ID_O
1990: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1991: ,P_PO_LINE_ID_O
1992: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1986: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1987: ,P_VENDOR_SITE_ID_O
1988: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1989: ,P_PO_HEADER_ID_O
1990: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1991: ,P_PO_LINE_ID_O
1992: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1993: ,P_PROJECTED_ASSIGNMENT_END_O
1994: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1988: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1989: ,P_PO_HEADER_ID_O
1990: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1991: ,P_PO_LINE_ID_O
1992: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1993: ,P_PROJECTED_ASSIGNMENT_END_O
1994: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1995: );
1996: --
1990: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1991: ,P_PO_LINE_ID_O
1992: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1993: ,P_PROJECTED_ASSIGNMENT_END_O
1994: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1995: );
1996: --
1997: hr_utility.set_location('Leaving : '||l_proc,999);
1998: --
2695: --
2696: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2697: --
2698: IF p_del_mode = 'ZAP' THEN
2699: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2700: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2701: ELSE
2702: hr_utility.trace('Not zap - error');
2703: END IF;
2696: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2697: --
2698: IF p_del_mode = 'ZAP' THEN
2699: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2700: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2701: ELSE
2702: hr_utility.trace('Not zap - error');
2703: END IF;
2704: ELSE
2718: ,P_EFFECTIVE_START_DATE => l_esd
2719: ,P_OBJECT_VERSION_NUMBER => l_ovn
2720: ,P_ORG_NOW_NO_MANAGER_WARNING => null
2721: ,P_APPLICANT_RANK_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2723: ,P_APPLICATION_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2725: ,P_ASSIGNMENT_CATEGORY_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2720: ,P_ORG_NOW_NO_MANAGER_WARNING => null
2721: ,P_APPLICANT_RANK_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2723: ,P_APPLICATION_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2725: ,P_ASSIGNMENT_CATEGORY_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2727: ,P_ASSIGNMENT_NUMBER_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2722: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2723: ,P_APPLICATION_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2725: ,P_ASSIGNMENT_CATEGORY_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2727: ,P_ASSIGNMENT_NUMBER_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2729: ,P_ASSIGNMENT_SEQUENCE_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2724: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2725: ,P_ASSIGNMENT_CATEGORY_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2727: ,P_ASSIGNMENT_NUMBER_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2729: ,P_ASSIGNMENT_SEQUENCE_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2731: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2726: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2727: ,P_ASSIGNMENT_NUMBER_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2729: ,P_ASSIGNMENT_SEQUENCE_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2731: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2733: ,P_ASSIGNMENT_TYPE_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2728: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2729: ,P_ASSIGNMENT_SEQUENCE_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2731: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2733: ,P_ASSIGNMENT_TYPE_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2735: ,P_ASS_ATTRIBUTE1_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2730: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2731: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2733: ,P_ASSIGNMENT_TYPE_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2735: ,P_ASS_ATTRIBUTE1_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2737: ,P_ASS_ATTRIBUTE10_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2732: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2733: ,P_ASSIGNMENT_TYPE_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2735: ,P_ASS_ATTRIBUTE1_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2737: ,P_ASS_ATTRIBUTE10_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2739: ,P_ASS_ATTRIBUTE11_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2734: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2735: ,P_ASS_ATTRIBUTE1_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2737: ,P_ASS_ATTRIBUTE10_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2739: ,P_ASS_ATTRIBUTE11_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2741: ,P_ASS_ATTRIBUTE12_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2736: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2737: ,P_ASS_ATTRIBUTE10_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2739: ,P_ASS_ATTRIBUTE11_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2741: ,P_ASS_ATTRIBUTE12_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2743: ,P_ASS_ATTRIBUTE13_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2738: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2739: ,P_ASS_ATTRIBUTE11_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2741: ,P_ASS_ATTRIBUTE12_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2743: ,P_ASS_ATTRIBUTE13_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2745: ,P_ASS_ATTRIBUTE14_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2740: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2741: ,P_ASS_ATTRIBUTE12_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2743: ,P_ASS_ATTRIBUTE13_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2745: ,P_ASS_ATTRIBUTE14_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2747: ,P_ASS_ATTRIBUTE15_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2742: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2743: ,P_ASS_ATTRIBUTE13_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2745: ,P_ASS_ATTRIBUTE14_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2747: ,P_ASS_ATTRIBUTE15_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2749: ,P_ASS_ATTRIBUTE16_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2744: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2745: ,P_ASS_ATTRIBUTE14_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2747: ,P_ASS_ATTRIBUTE15_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2749: ,P_ASS_ATTRIBUTE16_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2751: ,P_ASS_ATTRIBUTE17_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2746: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2747: ,P_ASS_ATTRIBUTE15_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2749: ,P_ASS_ATTRIBUTE16_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2751: ,P_ASS_ATTRIBUTE17_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2753: ,P_ASS_ATTRIBUTE18_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2748: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2749: ,P_ASS_ATTRIBUTE16_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2751: ,P_ASS_ATTRIBUTE17_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2753: ,P_ASS_ATTRIBUTE18_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2755: ,P_ASS_ATTRIBUTE19_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2750: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2751: ,P_ASS_ATTRIBUTE17_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2753: ,P_ASS_ATTRIBUTE18_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2755: ,P_ASS_ATTRIBUTE19_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2757: ,P_ASS_ATTRIBUTE2_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2752: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2753: ,P_ASS_ATTRIBUTE18_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2755: ,P_ASS_ATTRIBUTE19_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2757: ,P_ASS_ATTRIBUTE2_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2759: ,P_ASS_ATTRIBUTE20_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2754: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2755: ,P_ASS_ATTRIBUTE19_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2757: ,P_ASS_ATTRIBUTE2_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2759: ,P_ASS_ATTRIBUTE20_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2761: ,P_ASS_ATTRIBUTE21_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2756: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2757: ,P_ASS_ATTRIBUTE2_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2759: ,P_ASS_ATTRIBUTE20_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2761: ,P_ASS_ATTRIBUTE21_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2763: ,P_ASS_ATTRIBUTE22_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2758: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2759: ,P_ASS_ATTRIBUTE20_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2761: ,P_ASS_ATTRIBUTE21_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2763: ,P_ASS_ATTRIBUTE22_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2765: ,P_ASS_ATTRIBUTE23_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2760: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2761: ,P_ASS_ATTRIBUTE21_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2763: ,P_ASS_ATTRIBUTE22_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2765: ,P_ASS_ATTRIBUTE23_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2767: ,P_ASS_ATTRIBUTE24_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2762: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2763: ,P_ASS_ATTRIBUTE22_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2765: ,P_ASS_ATTRIBUTE23_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2767: ,P_ASS_ATTRIBUTE24_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2769: ,P_ASS_ATTRIBUTE25_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2764: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2765: ,P_ASS_ATTRIBUTE23_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2767: ,P_ASS_ATTRIBUTE24_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2769: ,P_ASS_ATTRIBUTE25_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2771: ,P_ASS_ATTRIBUTE26_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2766: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2767: ,P_ASS_ATTRIBUTE24_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2769: ,P_ASS_ATTRIBUTE25_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2771: ,P_ASS_ATTRIBUTE26_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2773: ,P_ASS_ATTRIBUTE27_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2768: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2769: ,P_ASS_ATTRIBUTE25_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2771: ,P_ASS_ATTRIBUTE26_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2773: ,P_ASS_ATTRIBUTE27_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2775: ,P_ASS_ATTRIBUTE28_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2770: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2771: ,P_ASS_ATTRIBUTE26_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2773: ,P_ASS_ATTRIBUTE27_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2775: ,P_ASS_ATTRIBUTE28_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2777: ,P_ASS_ATTRIBUTE29_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2772: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2773: ,P_ASS_ATTRIBUTE27_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2775: ,P_ASS_ATTRIBUTE28_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2777: ,P_ASS_ATTRIBUTE29_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2779: ,P_ASS_ATTRIBUTE3_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2774: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2775: ,P_ASS_ATTRIBUTE28_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2777: ,P_ASS_ATTRIBUTE29_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2779: ,P_ASS_ATTRIBUTE3_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2781: ,P_ASS_ATTRIBUTE30_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2776: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2777: ,P_ASS_ATTRIBUTE29_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2779: ,P_ASS_ATTRIBUTE3_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2781: ,P_ASS_ATTRIBUTE30_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2783: ,P_ASS_ATTRIBUTE4_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2778: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2779: ,P_ASS_ATTRIBUTE3_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2781: ,P_ASS_ATTRIBUTE30_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2783: ,P_ASS_ATTRIBUTE4_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2785: ,P_ASS_ATTRIBUTE5_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2780: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2781: ,P_ASS_ATTRIBUTE30_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2783: ,P_ASS_ATTRIBUTE4_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2785: ,P_ASS_ATTRIBUTE5_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2787: ,P_ASS_ATTRIBUTE6_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2782: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2783: ,P_ASS_ATTRIBUTE4_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2785: ,P_ASS_ATTRIBUTE5_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2787: ,P_ASS_ATTRIBUTE6_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2789: ,P_ASS_ATTRIBUTE7_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2784: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2785: ,P_ASS_ATTRIBUTE5_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2787: ,P_ASS_ATTRIBUTE6_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2789: ,P_ASS_ATTRIBUTE7_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2791: ,P_ASS_ATTRIBUTE8_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2786: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2787: ,P_ASS_ATTRIBUTE6_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2789: ,P_ASS_ATTRIBUTE7_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2791: ,P_ASS_ATTRIBUTE8_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2793: ,P_ASS_ATTRIBUTE9_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2788: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2789: ,P_ASS_ATTRIBUTE7_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2791: ,P_ASS_ATTRIBUTE8_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2793: ,P_ASS_ATTRIBUTE9_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2795: ,P_ASS_ATTRIBUTE_CATEGORY_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2790: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2791: ,P_ASS_ATTRIBUTE8_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2793: ,P_ASS_ATTRIBUTE9_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2795: ,P_ASS_ATTRIBUTE_CATEGORY_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2797: ,P_BARGAINING_UNIT_CODE_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2792: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2793: ,P_ASS_ATTRIBUTE9_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2795: ,P_ASS_ATTRIBUTE_CATEGORY_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2797: ,P_BARGAINING_UNIT_CODE_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2799: ,P_BUSINESS_GROUP_ID_O
2800: => p_bg_id
2794: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2795: ,P_ASS_ATTRIBUTE_CATEGORY_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2797: ,P_BARGAINING_UNIT_CODE_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2799: ,P_BUSINESS_GROUP_ID_O
2800: => p_bg_id
2801: ,P_CAGR_GRADE_DEF_ID_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2798: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2799: ,P_BUSINESS_GROUP_ID_O
2800: => p_bg_id
2801: ,P_CAGR_GRADE_DEF_ID_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2803: ,P_CAGR_ID_FLEX_NUM_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2805: ,P_CHANGE_REASON_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2800: => p_bg_id
2801: ,P_CAGR_GRADE_DEF_ID_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2803: ,P_CAGR_ID_FLEX_NUM_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2805: ,P_CHANGE_REASON_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2807: ,P_COLLECTIVE_AGREEMENT_ID_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2802: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2803: ,P_CAGR_ID_FLEX_NUM_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2805: ,P_CHANGE_REASON_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2807: ,P_COLLECTIVE_AGREEMENT_ID_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2809: ,P_COMMENT_ID_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2804: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2805: ,P_CHANGE_REASON_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2807: ,P_COLLECTIVE_AGREEMENT_ID_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2809: ,P_COMMENT_ID_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2811: ,P_CONTRACT_ID_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2806: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2807: ,P_COLLECTIVE_AGREEMENT_ID_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2809: ,P_COMMENT_ID_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2811: ,P_CONTRACT_ID_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2813: ,P_DATE_PROBATION_END_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2808: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2809: ,P_COMMENT_ID_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2811: ,P_CONTRACT_ID_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2813: ,P_DATE_PROBATION_END_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2815: ,P_DEFAULT_CODE_COMB_ID_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2810: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2811: ,P_CONTRACT_ID_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2813: ,P_DATE_PROBATION_END_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2815: ,P_DEFAULT_CODE_COMB_ID_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2817: ,P_EFFECTIVE_END_DATE_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2812: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2813: ,P_DATE_PROBATION_END_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2815: ,P_DEFAULT_CODE_COMB_ID_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2817: ,P_EFFECTIVE_END_DATE_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2819: ,P_EFFECTIVE_START_DATE_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2814: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2815: ,P_DEFAULT_CODE_COMB_ID_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2817: ,P_EFFECTIVE_END_DATE_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2819: ,P_EFFECTIVE_START_DATE_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2821: ,P_EMPLOYEE_CATEGORY_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2816: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2817: ,P_EFFECTIVE_END_DATE_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2819: ,P_EFFECTIVE_START_DATE_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2821: ,P_EMPLOYEE_CATEGORY_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2823: ,P_EMPLOYMENT_CATEGORY_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2818: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2819: ,P_EFFECTIVE_START_DATE_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2821: ,P_EMPLOYEE_CATEGORY_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2823: ,P_EMPLOYMENT_CATEGORY_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2825: ,P_ESTABLISHMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2820: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2821: ,P_EMPLOYEE_CATEGORY_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2823: ,P_EMPLOYMENT_CATEGORY_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2825: ,P_ESTABLISHMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2827: ,P_FREQUENCY_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2822: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2823: ,P_EMPLOYMENT_CATEGORY_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2825: ,P_ESTABLISHMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2827: ,P_FREQUENCY_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2829: ,P_GRADE_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2824: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2825: ,P_ESTABLISHMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2827: ,P_FREQUENCY_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2829: ,P_GRADE_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2831: ,P_HOURLY_SALARIED_CODE_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2826: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2827: ,P_FREQUENCY_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2829: ,P_GRADE_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2831: ,P_HOURLY_SALARIED_CODE_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2833: ,P_INTERNAL_ADDRESS_LINE_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2828: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2829: ,P_GRADE_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2831: ,P_HOURLY_SALARIED_CODE_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2833: ,P_INTERNAL_ADDRESS_LINE_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2835: ,P_JOB_ID_O
2836: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2830: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2831: ,P_HOURLY_SALARIED_CODE_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2833: ,P_INTERNAL_ADDRESS_LINE_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2835: ,P_JOB_ID_O
2836: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2837: ,P_JOB_POST_SOURCE_NAME_O
2838: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2832: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2833: ,P_INTERNAL_ADDRESS_LINE_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2835: ,P_JOB_ID_O
2836: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2837: ,P_JOB_POST_SOURCE_NAME_O
2838: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2839: ,P_LABOUR_UNION_MEMBER_FLAG_O
2840: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2834: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2835: ,P_JOB_ID_O
2836: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2837: ,P_JOB_POST_SOURCE_NAME_O
2838: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2839: ,P_LABOUR_UNION_MEMBER_FLAG_O
2840: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2841: ,P_LOCATION_ID_O
2842: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2836: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2837: ,P_JOB_POST_SOURCE_NAME_O
2838: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2839: ,P_LABOUR_UNION_MEMBER_FLAG_O
2840: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2841: ,P_LOCATION_ID_O
2842: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2843: ,P_MANAGER_FLAG_O
2844: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2838: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2839: ,P_LABOUR_UNION_MEMBER_FLAG_O
2840: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2841: ,P_LOCATION_ID_O
2842: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2843: ,P_MANAGER_FLAG_O
2844: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2845: ,P_NORMAL_HOURS_O
2846: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2840: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2841: ,P_LOCATION_ID_O
2842: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2843: ,P_MANAGER_FLAG_O
2844: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2845: ,P_NORMAL_HOURS_O
2846: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2847: ,P_NOTICE_PERIOD_O
2848: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2842: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2843: ,P_MANAGER_FLAG_O
2844: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2845: ,P_NORMAL_HOURS_O
2846: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2847: ,P_NOTICE_PERIOD_O
2848: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2849: ,P_NOTICE_PERIOD_UOM_O
2850: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2844: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2845: ,P_NORMAL_HOURS_O
2846: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2847: ,P_NOTICE_PERIOD_O
2848: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2849: ,P_NOTICE_PERIOD_UOM_O
2850: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2851: ,P_OBJECT_VERSION_NUMBER_O
2852: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2846: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2847: ,P_NOTICE_PERIOD_O
2848: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2849: ,P_NOTICE_PERIOD_UOM_O
2850: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2851: ,P_OBJECT_VERSION_NUMBER_O
2852: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2853: ,P_ORGANIZATION_ID_O
2854: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2848: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2849: ,P_NOTICE_PERIOD_UOM_O
2850: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2851: ,P_OBJECT_VERSION_NUMBER_O
2852: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2853: ,P_ORGANIZATION_ID_O
2854: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2855: ,P_PAYROLL_ID_O
2856: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2850: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2851: ,P_OBJECT_VERSION_NUMBER_O
2852: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2853: ,P_ORGANIZATION_ID_O
2854: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2855: ,P_PAYROLL_ID_O
2856: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2857: ,P_PAY_BASIS_ID_O
2858: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2852: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2853: ,P_ORGANIZATION_ID_O
2854: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2855: ,P_PAYROLL_ID_O
2856: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2857: ,P_PAY_BASIS_ID_O
2858: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2859: ,P_PEOPLE_GROUP_ID_O
2860: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2854: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2855: ,P_PAYROLL_ID_O
2856: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2857: ,P_PAY_BASIS_ID_O
2858: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2859: ,P_PEOPLE_GROUP_ID_O
2860: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2861: ,P_PERF_REVIEW_PERIOD_O
2862: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2856: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2857: ,P_PAY_BASIS_ID_O
2858: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2859: ,P_PEOPLE_GROUP_ID_O
2860: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2861: ,P_PERF_REVIEW_PERIOD_O
2862: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2863: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2864: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2858: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2859: ,P_PEOPLE_GROUP_ID_O
2860: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2861: ,P_PERF_REVIEW_PERIOD_O
2862: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2863: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2864: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2865: ,P_PERIOD_OF_SERVICE_ID_O
2866: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2860: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2861: ,P_PERF_REVIEW_PERIOD_O
2862: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2863: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2864: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2865: ,P_PERIOD_OF_SERVICE_ID_O
2866: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2867: ,P_PERSON_ID_O
2868: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2862: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2863: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2864: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2865: ,P_PERIOD_OF_SERVICE_ID_O
2866: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2867: ,P_PERSON_ID_O
2868: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2869: ,P_PERSON_REFERRED_BY_ID_O
2870: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2864: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2865: ,P_PERIOD_OF_SERVICE_ID_O
2866: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2867: ,P_PERSON_ID_O
2868: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2869: ,P_PERSON_REFERRED_BY_ID_O
2870: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2871: ,P_PLACEMENT_DATE_START_O
2872: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2866: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2867: ,P_PERSON_ID_O
2868: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2869: ,P_PERSON_REFERRED_BY_ID_O
2870: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2871: ,P_PLACEMENT_DATE_START_O
2872: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2873: ,P_POSITION_ID_O
2874: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2868: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2869: ,P_PERSON_REFERRED_BY_ID_O
2870: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2871: ,P_PLACEMENT_DATE_START_O
2872: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2873: ,P_POSITION_ID_O
2874: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2875: ,P_POSTING_CONTENT_ID_O
2876: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2870: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2871: ,P_PLACEMENT_DATE_START_O
2872: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2873: ,P_POSITION_ID_O
2874: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2875: ,P_POSTING_CONTENT_ID_O
2876: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2877: ,P_PRIMARY_FLAG_O
2878: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2872: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2873: ,P_POSITION_ID_O
2874: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2875: ,P_POSTING_CONTENT_ID_O
2876: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2877: ,P_PRIMARY_FLAG_O
2878: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2879: ,P_PROBATION_PERIOD_O
2880: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2874: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2875: ,P_POSTING_CONTENT_ID_O
2876: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2877: ,P_PRIMARY_FLAG_O
2878: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2879: ,P_PROBATION_PERIOD_O
2880: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2881: ,P_PROBATION_UNIT_O
2882: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2876: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2877: ,P_PRIMARY_FLAG_O
2878: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2879: ,P_PROBATION_PERIOD_O
2880: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2881: ,P_PROBATION_UNIT_O
2882: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2883: ,P_PROGRAM_APPLICATION_ID_O
2884: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2878: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2879: ,P_PROBATION_PERIOD_O
2880: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2881: ,P_PROBATION_UNIT_O
2882: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2883: ,P_PROGRAM_APPLICATION_ID_O
2884: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2885: ,P_PROGRAM_ID_O
2886: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2880: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2881: ,P_PROBATION_UNIT_O
2882: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2883: ,P_PROGRAM_APPLICATION_ID_O
2884: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2885: ,P_PROGRAM_ID_O
2886: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2887: ,P_PROGRAM_UPDATE_DATE_O
2888: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2882: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2883: ,P_PROGRAM_APPLICATION_ID_O
2884: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2885: ,P_PROGRAM_ID_O
2886: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2887: ,P_PROGRAM_UPDATE_DATE_O
2888: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2889: ,P_PROJECT_TITLE_O
2890: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2884: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2885: ,P_PROGRAM_ID_O
2886: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2887: ,P_PROGRAM_UPDATE_DATE_O
2888: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2889: ,P_PROJECT_TITLE_O
2890: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2891: ,P_RECRUITER_ID_O
2892: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2886: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2887: ,P_PROGRAM_UPDATE_DATE_O
2888: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2889: ,P_PROJECT_TITLE_O
2890: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2891: ,P_RECRUITER_ID_O
2892: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2893: ,P_RECRUITMENT_ACTIVITY_ID_O
2894: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2888: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2889: ,P_PROJECT_TITLE_O
2890: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2891: ,P_RECRUITER_ID_O
2892: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2893: ,P_RECRUITMENT_ACTIVITY_ID_O
2894: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2895: ,P_REQUEST_ID_O
2896: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2890: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2891: ,P_RECRUITER_ID_O
2892: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2893: ,P_RECRUITMENT_ACTIVITY_ID_O
2894: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2895: ,P_REQUEST_ID_O
2896: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2897: ,P_SAL_REVIEW_PERIOD_O
2898: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2892: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2893: ,P_RECRUITMENT_ACTIVITY_ID_O
2894: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2895: ,P_REQUEST_ID_O
2896: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2897: ,P_SAL_REVIEW_PERIOD_O
2898: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2899: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2900: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2894: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2895: ,P_REQUEST_ID_O
2896: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2897: ,P_SAL_REVIEW_PERIOD_O
2898: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2899: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2900: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2901: ,P_SET_OF_BOOKS_ID_O
2902: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2896: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2897: ,P_SAL_REVIEW_PERIOD_O
2898: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2899: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2900: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2901: ,P_SET_OF_BOOKS_ID_O
2902: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2903: ,P_SOFT_CODING_KEYFLEX_ID_O
2904: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2898: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2899: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2900: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2901: ,P_SET_OF_BOOKS_ID_O
2902: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2903: ,P_SOFT_CODING_KEYFLEX_ID_O
2904: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2905: ,P_SOURCE_ORGANIZATION_ID_O
2906: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2900: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2901: ,P_SET_OF_BOOKS_ID_O
2902: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2903: ,P_SOFT_CODING_KEYFLEX_ID_O
2904: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2905: ,P_SOURCE_ORGANIZATION_ID_O
2906: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2907: ,P_SOURCE_TYPE_O
2908: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2902: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2903: ,P_SOFT_CODING_KEYFLEX_ID_O
2904: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2905: ,P_SOURCE_ORGANIZATION_ID_O
2906: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2907: ,P_SOURCE_TYPE_O
2908: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2909: ,P_SPECIAL_CEILING_STEP_ID_O
2910: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2904: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2905: ,P_SOURCE_ORGANIZATION_ID_O
2906: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2907: ,P_SOURCE_TYPE_O
2908: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2909: ,P_SPECIAL_CEILING_STEP_ID_O
2910: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2911: ,P_SUPERVISOR_ID_O
2912: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2906: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2907: ,P_SOURCE_TYPE_O
2908: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2909: ,P_SPECIAL_CEILING_STEP_ID_O
2910: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2911: ,P_SUPERVISOR_ID_O
2912: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2913: ,P_TIME_NORMAL_FINISH_O
2914: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2908: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2909: ,P_SPECIAL_CEILING_STEP_ID_O
2910: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2911: ,P_SUPERVISOR_ID_O
2912: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2913: ,P_TIME_NORMAL_FINISH_O
2914: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2915: ,P_TIME_NORMAL_START_O
2916: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2910: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2911: ,P_SUPERVISOR_ID_O
2912: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2913: ,P_TIME_NORMAL_FINISH_O
2914: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2915: ,P_TIME_NORMAL_START_O
2916: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2917: ,P_TITLE_O
2918: => per_assignments_f2_pkg.g_old_asg_rec.title
2912: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2913: ,P_TIME_NORMAL_FINISH_O
2914: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2915: ,P_TIME_NORMAL_START_O
2916: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2917: ,P_TITLE_O
2918: => per_assignments_f2_pkg.g_old_asg_rec.title
2919: ,P_VACANCY_ID_O
2920: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2914: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2915: ,P_TIME_NORMAL_START_O
2916: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2917: ,P_TITLE_O
2918: => per_assignments_f2_pkg.g_old_asg_rec.title
2919: ,P_VACANCY_ID_O
2920: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2921: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2922: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2916: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2917: ,P_TITLE_O
2918: => per_assignments_f2_pkg.g_old_asg_rec.title
2919: ,P_VACANCY_ID_O
2920: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2921: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2922: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2923: ,P_VENDOR_EMPLOYEE_NUMBER_O
2924: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2918: => per_assignments_f2_pkg.g_old_asg_rec.title
2919: ,P_VACANCY_ID_O
2920: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2921: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2922: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2923: ,P_VENDOR_EMPLOYEE_NUMBER_O
2924: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2925: ,P_VENDOR_ID_O
2926: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2920: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2921: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2922: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2923: ,P_VENDOR_EMPLOYEE_NUMBER_O
2924: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2925: ,P_VENDOR_ID_O
2926: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2927: ,P_WORK_AT_HOME_O
2928: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2922: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2923: ,P_VENDOR_EMPLOYEE_NUMBER_O
2924: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2925: ,P_VENDOR_ID_O
2926: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2927: ,P_WORK_AT_HOME_O
2928: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2929: ,P_GRADE_LADDER_PGM_ID_O
2930: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2924: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2925: ,P_VENDOR_ID_O
2926: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2927: ,P_WORK_AT_HOME_O
2928: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2929: ,P_GRADE_LADDER_PGM_ID_O
2930: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2931: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2932: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2926: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2927: ,P_WORK_AT_HOME_O
2928: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2929: ,P_GRADE_LADDER_PGM_ID_O
2930: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2931: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2932: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2933: ,P_VENDOR_SITE_ID_O
2934: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2928: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2929: ,P_GRADE_LADDER_PGM_ID_O
2930: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2931: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2932: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2933: ,P_VENDOR_SITE_ID_O
2934: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2935: ,P_PO_HEADER_ID_O
2936: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2930: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2931: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2932: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2933: ,P_VENDOR_SITE_ID_O
2934: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2935: ,P_PO_HEADER_ID_O
2936: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2937: ,P_PO_LINE_ID_O
2938: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2932: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2933: ,P_VENDOR_SITE_ID_O
2934: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2935: ,P_PO_HEADER_ID_O
2936: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2937: ,P_PO_LINE_ID_O
2938: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2939: ,P_PROJECTED_ASSIGNMENT_END_O
2940: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2934: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2935: ,P_PO_HEADER_ID_O
2936: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2937: ,P_PO_LINE_ID_O
2938: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2939: ,P_PROJECTED_ASSIGNMENT_END_O
2940: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2941: );
2942: --
2936: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2937: ,P_PO_LINE_ID_O
2938: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2939: ,P_PROJECTED_ASSIGNMENT_END_O
2940: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2941: );
2942: --
2943: hr_utility.set_location('Leaving : '||l_proc,999);
2944: --
2943: hr_utility.set_location('Leaving : '||l_proc,999);
2944: --
2945: end post_delete;
2946: -----------------------------------------------------------------------------
2947: END PER_ASSIGNMENTS_F1_PKG;