1: PACKAGE BODY PER_ASSIGNMENTS_F1_PKG AS
2: /* $Header: peasg01t.pkb 120.29.12010000.3 2008/09/29 05:42:27 ubhat 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.29.12010000.3 2008/09/29 05:42:27 ubhat ship $ */
3: --
4: g_package varchar2(33) := 'per_assignments_f1_pkg.'; -- Global package name
5: g_debug boolean; -- debug flag
6: --
7: -----------------------------------------------------------------------------
8: --
313: if sql%rowcount = 0 then
314: fnd_message.set_name('PAY',
315: 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE',
317: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
318: fnd_message.set_token('STEP', '1');
319: fnd_message.raise_error;
320: end if;
321: */
485: if sql%rowcount = 0 then
486: fnd_message.set_name('PAY',
487: 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE',
489: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
490: fnd_message.set_token('STEP', '1');
491: fnd_message.raise_error;
492: end if;
493: end if;
634: p_sess_date date,
635: p_val_st_date date) is
636: l_start_date date;
637: begin
638: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.terminate_entries' , 5);
639: if p_per_sys_st = 'END' then
640: l_start_date := p_sess_date;
641: else
642: l_start_date := p_val_st_date;
658: -- This is to ensure that assignments cannot be 'opened up' past the Period
659: -- of Service End Date.
660: --
661: begin
662: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
663:
664: update per_assignments_f a
665: set a.effective_end_date = P_NEW_END_DATE
666: where a.assignment_id = P_ASS_ID
660: --
661: begin
662: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
663:
664: update per_assignments_f a
665: set a.effective_end_date = P_NEW_END_DATE
666: where a.assignment_id = P_ASS_ID
667: and a.effective_end_date = (
668: select max(a2.effective_end_date)
665: set a.effective_end_date = P_NEW_END_DATE
666: where a.assignment_id = P_ASS_ID
667: and a.effective_end_date = (
668: select max(a2.effective_end_date)
669: from per_assignments_f a2
670: where a2.assignment_id = a.assignment_id);
671: end set_end_date;
672: -----------------------------------------------------------------------------
673: procedure maintain_entries(
693: -- Maintain element entries for insert/update/delete
694: --
695: begin
696: --
697: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
698: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
699: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
700:
701: if p_dt_upd_mode is null then
733: if l_mode = 'DELETE' then
734: l_val_start_date := l_val_start_date + 1;
735: end if;
736: --
737: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',2);
738: hrentmnt.maintain_entries_asg(
739: p_ass_id,
740: p_old_pay_id,
741: p_new_pay_id,
1681: ,P_PO_HEADER_ID => cur_asg_rec.po_header_id
1682: ,P_PO_LINE_ID => cur_asg_rec.po_line_id
1683: ,P_PROJECTED_ASSIGNMENT_END => cur_asg_rec.projected_assignment_end
1684: ,P_APPLICANT_RANK_O
1685: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1686: ,P_APPLICATION_ID_O
1687: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1688: ,P_ASSIGNMENT_CATEGORY_O
1689: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1683: ,P_PROJECTED_ASSIGNMENT_END => cur_asg_rec.projected_assignment_end
1684: ,P_APPLICANT_RANK_O
1685: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1686: ,P_APPLICATION_ID_O
1687: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1688: ,P_ASSIGNMENT_CATEGORY_O
1689: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1690: ,P_ASSIGNMENT_NUMBER_O
1691: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1685: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
1686: ,P_APPLICATION_ID_O
1687: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1688: ,P_ASSIGNMENT_CATEGORY_O
1689: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1690: ,P_ASSIGNMENT_NUMBER_O
1691: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1692: ,P_ASSIGNMENT_SEQUENCE_O
1693: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1687: => per_assignments_f2_pkg.g_old_asg_rec.application_id
1688: ,P_ASSIGNMENT_CATEGORY_O
1689: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1690: ,P_ASSIGNMENT_NUMBER_O
1691: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1692: ,P_ASSIGNMENT_SEQUENCE_O
1693: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1694: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1695: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1689: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
1690: ,P_ASSIGNMENT_NUMBER_O
1691: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1692: ,P_ASSIGNMENT_SEQUENCE_O
1693: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1694: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1695: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1696: ,P_ASSIGNMENT_TYPE_O
1697: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1691: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
1692: ,P_ASSIGNMENT_SEQUENCE_O
1693: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1694: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1695: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1696: ,P_ASSIGNMENT_TYPE_O
1697: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1698: ,P_ASS_ATTRIBUTE1_O
1699: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1693: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
1694: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
1695: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1696: ,P_ASSIGNMENT_TYPE_O
1697: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1698: ,P_ASS_ATTRIBUTE1_O
1699: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1700: ,P_ASS_ATTRIBUTE10_O
1701: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1695: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
1696: ,P_ASSIGNMENT_TYPE_O
1697: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1698: ,P_ASS_ATTRIBUTE1_O
1699: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1700: ,P_ASS_ATTRIBUTE10_O
1701: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1702: ,P_ASS_ATTRIBUTE11_O
1703: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1697: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
1698: ,P_ASS_ATTRIBUTE1_O
1699: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1700: ,P_ASS_ATTRIBUTE10_O
1701: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1702: ,P_ASS_ATTRIBUTE11_O
1703: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1704: ,P_ASS_ATTRIBUTE12_O
1705: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1699: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
1700: ,P_ASS_ATTRIBUTE10_O
1701: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1702: ,P_ASS_ATTRIBUTE11_O
1703: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1704: ,P_ASS_ATTRIBUTE12_O
1705: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1706: ,P_ASS_ATTRIBUTE13_O
1707: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1701: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
1702: ,P_ASS_ATTRIBUTE11_O
1703: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1704: ,P_ASS_ATTRIBUTE12_O
1705: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1706: ,P_ASS_ATTRIBUTE13_O
1707: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1708: ,P_ASS_ATTRIBUTE14_O
1709: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1703: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
1704: ,P_ASS_ATTRIBUTE12_O
1705: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1706: ,P_ASS_ATTRIBUTE13_O
1707: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1708: ,P_ASS_ATTRIBUTE14_O
1709: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1710: ,P_ASS_ATTRIBUTE15_O
1711: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1705: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
1706: ,P_ASS_ATTRIBUTE13_O
1707: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1708: ,P_ASS_ATTRIBUTE14_O
1709: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1710: ,P_ASS_ATTRIBUTE15_O
1711: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1712: ,P_ASS_ATTRIBUTE16_O
1713: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1707: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
1708: ,P_ASS_ATTRIBUTE14_O
1709: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1710: ,P_ASS_ATTRIBUTE15_O
1711: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1712: ,P_ASS_ATTRIBUTE16_O
1713: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1714: ,P_ASS_ATTRIBUTE17_O
1715: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1709: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
1710: ,P_ASS_ATTRIBUTE15_O
1711: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1712: ,P_ASS_ATTRIBUTE16_O
1713: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1714: ,P_ASS_ATTRIBUTE17_O
1715: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1716: ,P_ASS_ATTRIBUTE18_O
1717: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1711: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
1712: ,P_ASS_ATTRIBUTE16_O
1713: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1714: ,P_ASS_ATTRIBUTE17_O
1715: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1716: ,P_ASS_ATTRIBUTE18_O
1717: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1718: ,P_ASS_ATTRIBUTE19_O
1719: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1713: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
1714: ,P_ASS_ATTRIBUTE17_O
1715: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1716: ,P_ASS_ATTRIBUTE18_O
1717: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1718: ,P_ASS_ATTRIBUTE19_O
1719: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1720: ,P_ASS_ATTRIBUTE2_O
1721: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1715: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
1716: ,P_ASS_ATTRIBUTE18_O
1717: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1718: ,P_ASS_ATTRIBUTE19_O
1719: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1720: ,P_ASS_ATTRIBUTE2_O
1721: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1722: ,P_ASS_ATTRIBUTE20_O
1723: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1717: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
1718: ,P_ASS_ATTRIBUTE19_O
1719: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1720: ,P_ASS_ATTRIBUTE2_O
1721: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1722: ,P_ASS_ATTRIBUTE20_O
1723: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1724: ,P_ASS_ATTRIBUTE21_O
1725: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1719: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
1720: ,P_ASS_ATTRIBUTE2_O
1721: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1722: ,P_ASS_ATTRIBUTE20_O
1723: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1724: ,P_ASS_ATTRIBUTE21_O
1725: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1726: ,P_ASS_ATTRIBUTE22_O
1727: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1721: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
1722: ,P_ASS_ATTRIBUTE20_O
1723: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1724: ,P_ASS_ATTRIBUTE21_O
1725: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1726: ,P_ASS_ATTRIBUTE22_O
1727: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1728: ,P_ASS_ATTRIBUTE23_O
1729: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1723: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
1724: ,P_ASS_ATTRIBUTE21_O
1725: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1726: ,P_ASS_ATTRIBUTE22_O
1727: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1728: ,P_ASS_ATTRIBUTE23_O
1729: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1730: ,P_ASS_ATTRIBUTE24_O
1731: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1725: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
1726: ,P_ASS_ATTRIBUTE22_O
1727: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1728: ,P_ASS_ATTRIBUTE23_O
1729: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1730: ,P_ASS_ATTRIBUTE24_O
1731: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1732: ,P_ASS_ATTRIBUTE25_O
1733: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1727: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
1728: ,P_ASS_ATTRIBUTE23_O
1729: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1730: ,P_ASS_ATTRIBUTE24_O
1731: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1732: ,P_ASS_ATTRIBUTE25_O
1733: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1734: ,P_ASS_ATTRIBUTE26_O
1735: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1729: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
1730: ,P_ASS_ATTRIBUTE24_O
1731: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1732: ,P_ASS_ATTRIBUTE25_O
1733: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1734: ,P_ASS_ATTRIBUTE26_O
1735: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1736: ,P_ASS_ATTRIBUTE27_O
1737: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1731: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
1732: ,P_ASS_ATTRIBUTE25_O
1733: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1734: ,P_ASS_ATTRIBUTE26_O
1735: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1736: ,P_ASS_ATTRIBUTE27_O
1737: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1738: ,P_ASS_ATTRIBUTE28_O
1739: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1733: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
1734: ,P_ASS_ATTRIBUTE26_O
1735: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1736: ,P_ASS_ATTRIBUTE27_O
1737: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1738: ,P_ASS_ATTRIBUTE28_O
1739: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1740: ,P_ASS_ATTRIBUTE29_O
1741: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1735: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
1736: ,P_ASS_ATTRIBUTE27_O
1737: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1738: ,P_ASS_ATTRIBUTE28_O
1739: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1740: ,P_ASS_ATTRIBUTE29_O
1741: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1742: ,P_ASS_ATTRIBUTE3_O
1743: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1737: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
1738: ,P_ASS_ATTRIBUTE28_O
1739: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1740: ,P_ASS_ATTRIBUTE29_O
1741: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1742: ,P_ASS_ATTRIBUTE3_O
1743: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1744: ,P_ASS_ATTRIBUTE30_O
1745: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1739: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
1740: ,P_ASS_ATTRIBUTE29_O
1741: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1742: ,P_ASS_ATTRIBUTE3_O
1743: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1744: ,P_ASS_ATTRIBUTE30_O
1745: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1746: ,P_ASS_ATTRIBUTE4_O
1747: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1741: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
1742: ,P_ASS_ATTRIBUTE3_O
1743: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1744: ,P_ASS_ATTRIBUTE30_O
1745: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1746: ,P_ASS_ATTRIBUTE4_O
1747: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1748: ,P_ASS_ATTRIBUTE5_O
1749: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1743: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
1744: ,P_ASS_ATTRIBUTE30_O
1745: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1746: ,P_ASS_ATTRIBUTE4_O
1747: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1748: ,P_ASS_ATTRIBUTE5_O
1749: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1750: ,P_ASS_ATTRIBUTE6_O
1751: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1745: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
1746: ,P_ASS_ATTRIBUTE4_O
1747: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1748: ,P_ASS_ATTRIBUTE5_O
1749: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1750: ,P_ASS_ATTRIBUTE6_O
1751: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1752: ,P_ASS_ATTRIBUTE7_O
1753: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1747: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
1748: ,P_ASS_ATTRIBUTE5_O
1749: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1750: ,P_ASS_ATTRIBUTE6_O
1751: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1752: ,P_ASS_ATTRIBUTE7_O
1753: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1754: ,P_ASS_ATTRIBUTE8_O
1755: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1749: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
1750: ,P_ASS_ATTRIBUTE6_O
1751: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1752: ,P_ASS_ATTRIBUTE7_O
1753: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1754: ,P_ASS_ATTRIBUTE8_O
1755: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1756: ,P_ASS_ATTRIBUTE9_O
1757: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1751: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
1752: ,P_ASS_ATTRIBUTE7_O
1753: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1754: ,P_ASS_ATTRIBUTE8_O
1755: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1756: ,P_ASS_ATTRIBUTE9_O
1757: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1758: ,P_ASS_ATTRIBUTE_CATEGORY_O
1759: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1753: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
1754: ,P_ASS_ATTRIBUTE8_O
1755: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1756: ,P_ASS_ATTRIBUTE9_O
1757: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1758: ,P_ASS_ATTRIBUTE_CATEGORY_O
1759: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1760: ,P_BARGAINING_UNIT_CODE_O
1761: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1755: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
1756: ,P_ASS_ATTRIBUTE9_O
1757: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1758: ,P_ASS_ATTRIBUTE_CATEGORY_O
1759: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1760: ,P_BARGAINING_UNIT_CODE_O
1761: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1762: ,P_BUSINESS_GROUP_ID_O
1763: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1757: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
1758: ,P_ASS_ATTRIBUTE_CATEGORY_O
1759: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1760: ,P_BARGAINING_UNIT_CODE_O
1761: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1762: ,P_BUSINESS_GROUP_ID_O
1763: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1764: ,P_CAGR_GRADE_DEF_ID_O
1765: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1759: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
1760: ,P_BARGAINING_UNIT_CODE_O
1761: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1762: ,P_BUSINESS_GROUP_ID_O
1763: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1764: ,P_CAGR_GRADE_DEF_ID_O
1765: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1766: ,P_CAGR_ID_FLEX_NUM_O
1767: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1761: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
1762: ,P_BUSINESS_GROUP_ID_O
1763: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1764: ,P_CAGR_GRADE_DEF_ID_O
1765: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1766: ,P_CAGR_ID_FLEX_NUM_O
1767: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1768: ,P_CHANGE_REASON_O
1769: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1763: => per_assignments_f2_pkg.g_old_asg_rec.business_group_id
1764: ,P_CAGR_GRADE_DEF_ID_O
1765: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1766: ,P_CAGR_ID_FLEX_NUM_O
1767: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1768: ,P_CHANGE_REASON_O
1769: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1770: ,P_COLLECTIVE_AGREEMENT_ID_O
1771: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1765: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
1766: ,P_CAGR_ID_FLEX_NUM_O
1767: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1768: ,P_CHANGE_REASON_O
1769: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1770: ,P_COLLECTIVE_AGREEMENT_ID_O
1771: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1772: ,P_COMMENT_ID_O
1773: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1767: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
1768: ,P_CHANGE_REASON_O
1769: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1770: ,P_COLLECTIVE_AGREEMENT_ID_O
1771: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1772: ,P_COMMENT_ID_O
1773: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1774: ,P_CONTRACT_ID_O
1775: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1769: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
1770: ,P_COLLECTIVE_AGREEMENT_ID_O
1771: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1772: ,P_COMMENT_ID_O
1773: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1774: ,P_CONTRACT_ID_O
1775: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1776: ,P_DATE_PROBATION_END_O
1777: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1771: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
1772: ,P_COMMENT_ID_O
1773: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1774: ,P_CONTRACT_ID_O
1775: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1776: ,P_DATE_PROBATION_END_O
1777: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1778: ,P_DEFAULT_CODE_COMB_ID_O
1779: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1773: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
1774: ,P_CONTRACT_ID_O
1775: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1776: ,P_DATE_PROBATION_END_O
1777: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1778: ,P_DEFAULT_CODE_COMB_ID_O
1779: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1780: ,P_EFFECTIVE_END_DATE_O
1781: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1775: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
1776: ,P_DATE_PROBATION_END_O
1777: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1778: ,P_DEFAULT_CODE_COMB_ID_O
1779: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1780: ,P_EFFECTIVE_END_DATE_O
1781: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1782: ,P_EFFECTIVE_START_DATE_O
1783: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1777: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
1778: ,P_DEFAULT_CODE_COMB_ID_O
1779: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1780: ,P_EFFECTIVE_END_DATE_O
1781: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1782: ,P_EFFECTIVE_START_DATE_O
1783: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1784: ,P_EMPLOYEE_CATEGORY_O
1785: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1779: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
1780: ,P_EFFECTIVE_END_DATE_O
1781: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1782: ,P_EFFECTIVE_START_DATE_O
1783: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1784: ,P_EMPLOYEE_CATEGORY_O
1785: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1786: ,P_EMPLOYMENT_CATEGORY_O
1787: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1781: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
1782: ,P_EFFECTIVE_START_DATE_O
1783: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1784: ,P_EMPLOYEE_CATEGORY_O
1785: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1786: ,P_EMPLOYMENT_CATEGORY_O
1787: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1788: ,P_ESTABLISHMENT_ID_O
1789: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1783: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
1784: ,P_EMPLOYEE_CATEGORY_O
1785: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1786: ,P_EMPLOYMENT_CATEGORY_O
1787: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1788: ,P_ESTABLISHMENT_ID_O
1789: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1790: ,P_FREQUENCY_O
1791: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1785: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
1786: ,P_EMPLOYMENT_CATEGORY_O
1787: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1788: ,P_ESTABLISHMENT_ID_O
1789: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1790: ,P_FREQUENCY_O
1791: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1792: ,P_GRADE_ID_O
1793: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1787: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
1788: ,P_ESTABLISHMENT_ID_O
1789: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1790: ,P_FREQUENCY_O
1791: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1792: ,P_GRADE_ID_O
1793: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1794: ,P_HOURLY_SALARIED_CODE_O
1795: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1789: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
1790: ,P_FREQUENCY_O
1791: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1792: ,P_GRADE_ID_O
1793: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1794: ,P_HOURLY_SALARIED_CODE_O
1795: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1796: ,P_INTERNAL_ADDRESS_LINE_O
1797: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1791: => per_assignments_f2_pkg.g_old_asg_rec.frequency
1792: ,P_GRADE_ID_O
1793: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1794: ,P_HOURLY_SALARIED_CODE_O
1795: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1796: ,P_INTERNAL_ADDRESS_LINE_O
1797: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1798: ,P_JOB_ID_O
1799: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1793: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
1794: ,P_HOURLY_SALARIED_CODE_O
1795: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1796: ,P_INTERNAL_ADDRESS_LINE_O
1797: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1798: ,P_JOB_ID_O
1799: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1800: ,P_JOB_POST_SOURCE_NAME_O
1801: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1795: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
1796: ,P_INTERNAL_ADDRESS_LINE_O
1797: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1798: ,P_JOB_ID_O
1799: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1800: ,P_JOB_POST_SOURCE_NAME_O
1801: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1802: ,P_LABOUR_UNION_MEMBER_FLAG_O
1803: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1797: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
1798: ,P_JOB_ID_O
1799: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1800: ,P_JOB_POST_SOURCE_NAME_O
1801: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1802: ,P_LABOUR_UNION_MEMBER_FLAG_O
1803: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1804: ,P_LOCATION_ID_O
1805: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1799: => per_assignments_f2_pkg.g_old_asg_rec.job_id
1800: ,P_JOB_POST_SOURCE_NAME_O
1801: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1802: ,P_LABOUR_UNION_MEMBER_FLAG_O
1803: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1804: ,P_LOCATION_ID_O
1805: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1806: ,P_MANAGER_FLAG_O
1807: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1801: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
1802: ,P_LABOUR_UNION_MEMBER_FLAG_O
1803: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1804: ,P_LOCATION_ID_O
1805: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1806: ,P_MANAGER_FLAG_O
1807: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1808: ,P_NORMAL_HOURS_O
1809: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1803: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
1804: ,P_LOCATION_ID_O
1805: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1806: ,P_MANAGER_FLAG_O
1807: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1808: ,P_NORMAL_HOURS_O
1809: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1810: ,P_NOTICE_PERIOD_O
1811: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1805: => per_assignments_f2_pkg.g_old_asg_rec.location_id
1806: ,P_MANAGER_FLAG_O
1807: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1808: ,P_NORMAL_HOURS_O
1809: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1810: ,P_NOTICE_PERIOD_O
1811: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1812: ,P_NOTICE_PERIOD_UOM_O
1813: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1807: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
1808: ,P_NORMAL_HOURS_O
1809: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1810: ,P_NOTICE_PERIOD_O
1811: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1812: ,P_NOTICE_PERIOD_UOM_O
1813: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1814: ,P_OBJECT_VERSION_NUMBER_O
1815: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1809: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
1810: ,P_NOTICE_PERIOD_O
1811: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1812: ,P_NOTICE_PERIOD_UOM_O
1813: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1814: ,P_OBJECT_VERSION_NUMBER_O
1815: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1816: ,P_ORGANIZATION_ID_O
1817: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1811: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
1812: ,P_NOTICE_PERIOD_UOM_O
1813: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1814: ,P_OBJECT_VERSION_NUMBER_O
1815: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1816: ,P_ORGANIZATION_ID_O
1817: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1818: ,P_PAYROLL_ID_O
1819: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1813: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
1814: ,P_OBJECT_VERSION_NUMBER_O
1815: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1816: ,P_ORGANIZATION_ID_O
1817: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1818: ,P_PAYROLL_ID_O
1819: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1820: ,P_PAY_BASIS_ID_O
1821: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1815: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
1816: ,P_ORGANIZATION_ID_O
1817: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1818: ,P_PAYROLL_ID_O
1819: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1820: ,P_PAY_BASIS_ID_O
1821: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1822: ,P_PEOPLE_GROUP_ID_O
1823: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1817: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
1818: ,P_PAYROLL_ID_O
1819: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1820: ,P_PAY_BASIS_ID_O
1821: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1822: ,P_PEOPLE_GROUP_ID_O
1823: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1824: ,P_PERF_REVIEW_PERIOD_O
1825: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1819: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
1820: ,P_PAY_BASIS_ID_O
1821: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1822: ,P_PEOPLE_GROUP_ID_O
1823: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1824: ,P_PERF_REVIEW_PERIOD_O
1825: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1826: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1827: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1821: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
1822: ,P_PEOPLE_GROUP_ID_O
1823: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1824: ,P_PERF_REVIEW_PERIOD_O
1825: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1826: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1827: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1828: ,P_PERIOD_OF_SERVICE_ID_O
1829: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1823: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
1824: ,P_PERF_REVIEW_PERIOD_O
1825: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1826: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1827: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1828: ,P_PERIOD_OF_SERVICE_ID_O
1829: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1830: ,P_PERSON_ID_O
1831: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1825: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
1826: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
1827: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1828: ,P_PERIOD_OF_SERVICE_ID_O
1829: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1830: ,P_PERSON_ID_O
1831: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1832: ,P_PERSON_REFERRED_BY_ID_O
1833: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1827: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
1828: ,P_PERIOD_OF_SERVICE_ID_O
1829: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1830: ,P_PERSON_ID_O
1831: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1832: ,P_PERSON_REFERRED_BY_ID_O
1833: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1834: ,P_PLACEMENT_DATE_START_O
1835: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1829: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
1830: ,P_PERSON_ID_O
1831: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1832: ,P_PERSON_REFERRED_BY_ID_O
1833: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1834: ,P_PLACEMENT_DATE_START_O
1835: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1836: ,P_POSITION_ID_O
1837: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1831: => per_assignments_f2_pkg.g_old_asg_rec.person_id
1832: ,P_PERSON_REFERRED_BY_ID_O
1833: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1834: ,P_PLACEMENT_DATE_START_O
1835: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1836: ,P_POSITION_ID_O
1837: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1838: ,P_POSTING_CONTENT_ID_O
1839: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1833: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
1834: ,P_PLACEMENT_DATE_START_O
1835: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1836: ,P_POSITION_ID_O
1837: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1838: ,P_POSTING_CONTENT_ID_O
1839: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1840: ,P_PRIMARY_FLAG_O
1841: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1835: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
1836: ,P_POSITION_ID_O
1837: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1838: ,P_POSTING_CONTENT_ID_O
1839: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1840: ,P_PRIMARY_FLAG_O
1841: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1842: ,P_PROBATION_PERIOD_O
1843: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1837: => per_assignments_f2_pkg.g_old_asg_rec.position_id
1838: ,P_POSTING_CONTENT_ID_O
1839: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1840: ,P_PRIMARY_FLAG_O
1841: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1842: ,P_PROBATION_PERIOD_O
1843: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1844: ,P_PROBATION_UNIT_O
1845: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1839: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
1840: ,P_PRIMARY_FLAG_O
1841: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1842: ,P_PROBATION_PERIOD_O
1843: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1844: ,P_PROBATION_UNIT_O
1845: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1846: ,P_PROGRAM_APPLICATION_ID_O
1847: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1841: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
1842: ,P_PROBATION_PERIOD_O
1843: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1844: ,P_PROBATION_UNIT_O
1845: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1846: ,P_PROGRAM_APPLICATION_ID_O
1847: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1848: ,P_PROGRAM_ID_O
1849: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1843: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
1844: ,P_PROBATION_UNIT_O
1845: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1846: ,P_PROGRAM_APPLICATION_ID_O
1847: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1848: ,P_PROGRAM_ID_O
1849: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1850: ,P_PROGRAM_UPDATE_DATE_O
1851: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1845: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
1846: ,P_PROGRAM_APPLICATION_ID_O
1847: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1848: ,P_PROGRAM_ID_O
1849: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1850: ,P_PROGRAM_UPDATE_DATE_O
1851: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1852: ,P_PROJECT_TITLE_O
1853: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1847: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
1848: ,P_PROGRAM_ID_O
1849: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1850: ,P_PROGRAM_UPDATE_DATE_O
1851: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1852: ,P_PROJECT_TITLE_O
1853: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1854: ,P_RECRUITER_ID_O
1855: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1849: => per_assignments_f2_pkg.g_old_asg_rec.program_id
1850: ,P_PROGRAM_UPDATE_DATE_O
1851: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1852: ,P_PROJECT_TITLE_O
1853: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1854: ,P_RECRUITER_ID_O
1855: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1856: ,P_RECRUITMENT_ACTIVITY_ID_O
1857: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1851: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
1852: ,P_PROJECT_TITLE_O
1853: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1854: ,P_RECRUITER_ID_O
1855: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1856: ,P_RECRUITMENT_ACTIVITY_ID_O
1857: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1858: ,P_REQUEST_ID_O
1859: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1853: => per_assignments_f2_pkg.g_old_asg_rec.project_title
1854: ,P_RECRUITER_ID_O
1855: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1856: ,P_RECRUITMENT_ACTIVITY_ID_O
1857: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1858: ,P_REQUEST_ID_O
1859: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1860: ,P_SAL_REVIEW_PERIOD_O
1861: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1855: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
1856: ,P_RECRUITMENT_ACTIVITY_ID_O
1857: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1858: ,P_REQUEST_ID_O
1859: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1860: ,P_SAL_REVIEW_PERIOD_O
1861: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1862: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1863: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1857: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
1858: ,P_REQUEST_ID_O
1859: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1860: ,P_SAL_REVIEW_PERIOD_O
1861: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1862: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1863: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1864: ,P_SET_OF_BOOKS_ID_O
1865: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1859: => per_assignments_f2_pkg.g_old_asg_rec.request_id
1860: ,P_SAL_REVIEW_PERIOD_O
1861: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1862: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1863: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1864: ,P_SET_OF_BOOKS_ID_O
1865: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1866: ,P_SOFT_CODING_KEYFLEX_ID_O
1867: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1861: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
1862: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
1863: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1864: ,P_SET_OF_BOOKS_ID_O
1865: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1866: ,P_SOFT_CODING_KEYFLEX_ID_O
1867: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1868: ,P_SOURCE_ORGANIZATION_ID_O
1869: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1863: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
1864: ,P_SET_OF_BOOKS_ID_O
1865: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1866: ,P_SOFT_CODING_KEYFLEX_ID_O
1867: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1868: ,P_SOURCE_ORGANIZATION_ID_O
1869: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1870: ,P_SOURCE_TYPE_O
1871: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1865: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
1866: ,P_SOFT_CODING_KEYFLEX_ID_O
1867: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1868: ,P_SOURCE_ORGANIZATION_ID_O
1869: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1870: ,P_SOURCE_TYPE_O
1871: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1872: ,P_SPECIAL_CEILING_STEP_ID_O
1873: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1867: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
1868: ,P_SOURCE_ORGANIZATION_ID_O
1869: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1870: ,P_SOURCE_TYPE_O
1871: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1872: ,P_SPECIAL_CEILING_STEP_ID_O
1873: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1874: ,P_SUPERVISOR_ID_O
1875: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1869: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
1870: ,P_SOURCE_TYPE_O
1871: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1872: ,P_SPECIAL_CEILING_STEP_ID_O
1873: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1874: ,P_SUPERVISOR_ID_O
1875: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1876: ,P_TIME_NORMAL_FINISH_O
1877: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1871: => per_assignments_f2_pkg.g_old_asg_rec.source_type
1872: ,P_SPECIAL_CEILING_STEP_ID_O
1873: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1874: ,P_SUPERVISOR_ID_O
1875: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1876: ,P_TIME_NORMAL_FINISH_O
1877: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1878: ,P_TIME_NORMAL_START_O
1879: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1873: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
1874: ,P_SUPERVISOR_ID_O
1875: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1876: ,P_TIME_NORMAL_FINISH_O
1877: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1878: ,P_TIME_NORMAL_START_O
1879: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1880: ,P_TITLE_O
1881: => per_assignments_f2_pkg.g_old_asg_rec.title
1875: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
1876: ,P_TIME_NORMAL_FINISH_O
1877: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1878: ,P_TIME_NORMAL_START_O
1879: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1880: ,P_TITLE_O
1881: => per_assignments_f2_pkg.g_old_asg_rec.title
1882: ,P_VACANCY_ID_O
1883: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1877: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
1878: ,P_TIME_NORMAL_START_O
1879: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1880: ,P_TITLE_O
1881: => per_assignments_f2_pkg.g_old_asg_rec.title
1882: ,P_VACANCY_ID_O
1883: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1884: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1885: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1879: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
1880: ,P_TITLE_O
1881: => per_assignments_f2_pkg.g_old_asg_rec.title
1882: ,P_VACANCY_ID_O
1883: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1884: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1885: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1886: ,P_VENDOR_EMPLOYEE_NUMBER_O
1887: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1881: => per_assignments_f2_pkg.g_old_asg_rec.title
1882: ,P_VACANCY_ID_O
1883: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1884: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1885: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1886: ,P_VENDOR_EMPLOYEE_NUMBER_O
1887: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1888: ,P_VENDOR_ID_O
1889: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1883: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
1884: ,P_VENDOR_ASSIGNMENT_NUMBER_O
1885: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1886: ,P_VENDOR_EMPLOYEE_NUMBER_O
1887: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1888: ,P_VENDOR_ID_O
1889: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1890: ,P_WORK_AT_HOME_O
1891: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1885: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
1886: ,P_VENDOR_EMPLOYEE_NUMBER_O
1887: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1888: ,P_VENDOR_ID_O
1889: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1890: ,P_WORK_AT_HOME_O
1891: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1892: ,P_GRADE_LADDER_PGM_ID_O
1893: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1887: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
1888: ,P_VENDOR_ID_O
1889: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1890: ,P_WORK_AT_HOME_O
1891: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1892: ,P_GRADE_LADDER_PGM_ID_O
1893: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1894: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1895: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1889: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
1890: ,P_WORK_AT_HOME_O
1891: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1892: ,P_GRADE_LADDER_PGM_ID_O
1893: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1894: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1895: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1896: ,P_VENDOR_SITE_ID_O
1897: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1891: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
1892: ,P_GRADE_LADDER_PGM_ID_O
1893: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1894: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1895: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1896: ,P_VENDOR_SITE_ID_O
1897: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1898: ,P_PO_HEADER_ID_O
1899: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1893: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
1894: ,P_SUPERVISOR_ASSIGNMENT_ID_O
1895: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1896: ,P_VENDOR_SITE_ID_O
1897: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1898: ,P_PO_HEADER_ID_O
1899: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1900: ,P_PO_LINE_ID_O
1901: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1895: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
1896: ,P_VENDOR_SITE_ID_O
1897: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1898: ,P_PO_HEADER_ID_O
1899: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1900: ,P_PO_LINE_ID_O
1901: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1902: ,P_PROJECTED_ASSIGNMENT_END_O
1903: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1897: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
1898: ,P_PO_HEADER_ID_O
1899: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1900: ,P_PO_LINE_ID_O
1901: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1902: ,P_PROJECTED_ASSIGNMENT_END_O
1903: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1904: );
1905: --
1899: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
1900: ,P_PO_LINE_ID_O
1901: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
1902: ,P_PROJECTED_ASSIGNMENT_END_O
1903: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1904: );
1905: --
1906: hr_utility.set_location('Leaving : '||l_proc,999);
1907: --
2589: --
2590: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2591: --
2592: IF p_del_mode = 'ZAP' THEN
2593: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2594: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2595: ELSE
2596: hr_utility.trace('Not zap - error');
2597: END IF;
2590: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2591: --
2592: IF p_del_mode = 'ZAP' THEN
2593: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2594: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2595: ELSE
2596: hr_utility.trace('Not zap - error');
2597: END IF;
2598: ELSE
2612: ,P_EFFECTIVE_START_DATE => l_esd
2613: ,P_OBJECT_VERSION_NUMBER => l_ovn
2614: ,P_ORG_NOW_NO_MANAGER_WARNING => null
2615: ,P_APPLICANT_RANK_O
2616: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2617: ,P_APPLICATION_ID_O
2618: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2619: ,P_ASSIGNMENT_CATEGORY_O
2620: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2614: ,P_ORG_NOW_NO_MANAGER_WARNING => null
2615: ,P_APPLICANT_RANK_O
2616: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2617: ,P_APPLICATION_ID_O
2618: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2619: ,P_ASSIGNMENT_CATEGORY_O
2620: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2621: ,P_ASSIGNMENT_NUMBER_O
2622: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2616: => per_assignments_f2_pkg.g_old_asg_rec.applicant_rank
2617: ,P_APPLICATION_ID_O
2618: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2619: ,P_ASSIGNMENT_CATEGORY_O
2620: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2621: ,P_ASSIGNMENT_NUMBER_O
2622: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2623: ,P_ASSIGNMENT_SEQUENCE_O
2624: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2618: => per_assignments_f2_pkg.g_old_asg_rec.application_id
2619: ,P_ASSIGNMENT_CATEGORY_O
2620: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2621: ,P_ASSIGNMENT_NUMBER_O
2622: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2623: ,P_ASSIGNMENT_SEQUENCE_O
2624: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2625: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2626: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2620: => per_assignments_f2_pkg.g_old_asg_rec.assignment_category
2621: ,P_ASSIGNMENT_NUMBER_O
2622: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2623: ,P_ASSIGNMENT_SEQUENCE_O
2624: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2625: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2626: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2627: ,P_ASSIGNMENT_TYPE_O
2628: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2622: => per_assignments_f2_pkg.g_old_asg_rec.assignment_number
2623: ,P_ASSIGNMENT_SEQUENCE_O
2624: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2625: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2626: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2627: ,P_ASSIGNMENT_TYPE_O
2628: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2629: ,P_ASS_ATTRIBUTE1_O
2630: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2624: => per_assignments_f2_pkg.g_old_asg_rec.assignment_sequence
2625: ,P_ASSIGNMENT_STATUS_TYPE_ID_O
2626: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2627: ,P_ASSIGNMENT_TYPE_O
2628: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2629: ,P_ASS_ATTRIBUTE1_O
2630: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2631: ,P_ASS_ATTRIBUTE10_O
2632: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2626: => per_assignments_f2_pkg.g_old_asg_rec.assignment_status_type_id
2627: ,P_ASSIGNMENT_TYPE_O
2628: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2629: ,P_ASS_ATTRIBUTE1_O
2630: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2631: ,P_ASS_ATTRIBUTE10_O
2632: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2633: ,P_ASS_ATTRIBUTE11_O
2634: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2628: => per_assignments_f2_pkg.g_old_asg_rec.assignment_type
2629: ,P_ASS_ATTRIBUTE1_O
2630: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2631: ,P_ASS_ATTRIBUTE10_O
2632: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2633: ,P_ASS_ATTRIBUTE11_O
2634: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2635: ,P_ASS_ATTRIBUTE12_O
2636: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2630: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute1
2631: ,P_ASS_ATTRIBUTE10_O
2632: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2633: ,P_ASS_ATTRIBUTE11_O
2634: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2635: ,P_ASS_ATTRIBUTE12_O
2636: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2637: ,P_ASS_ATTRIBUTE13_O
2638: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2632: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute10
2633: ,P_ASS_ATTRIBUTE11_O
2634: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2635: ,P_ASS_ATTRIBUTE12_O
2636: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2637: ,P_ASS_ATTRIBUTE13_O
2638: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2639: ,P_ASS_ATTRIBUTE14_O
2640: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2634: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute11
2635: ,P_ASS_ATTRIBUTE12_O
2636: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2637: ,P_ASS_ATTRIBUTE13_O
2638: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2639: ,P_ASS_ATTRIBUTE14_O
2640: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2641: ,P_ASS_ATTRIBUTE15_O
2642: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2636: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute12
2637: ,P_ASS_ATTRIBUTE13_O
2638: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2639: ,P_ASS_ATTRIBUTE14_O
2640: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2641: ,P_ASS_ATTRIBUTE15_O
2642: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2643: ,P_ASS_ATTRIBUTE16_O
2644: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2638: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute13
2639: ,P_ASS_ATTRIBUTE14_O
2640: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2641: ,P_ASS_ATTRIBUTE15_O
2642: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2643: ,P_ASS_ATTRIBUTE16_O
2644: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2645: ,P_ASS_ATTRIBUTE17_O
2646: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2640: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute14
2641: ,P_ASS_ATTRIBUTE15_O
2642: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2643: ,P_ASS_ATTRIBUTE16_O
2644: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2645: ,P_ASS_ATTRIBUTE17_O
2646: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2647: ,P_ASS_ATTRIBUTE18_O
2648: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2642: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute15
2643: ,P_ASS_ATTRIBUTE16_O
2644: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2645: ,P_ASS_ATTRIBUTE17_O
2646: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2647: ,P_ASS_ATTRIBUTE18_O
2648: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2649: ,P_ASS_ATTRIBUTE19_O
2650: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2644: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute16
2645: ,P_ASS_ATTRIBUTE17_O
2646: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2647: ,P_ASS_ATTRIBUTE18_O
2648: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2649: ,P_ASS_ATTRIBUTE19_O
2650: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2651: ,P_ASS_ATTRIBUTE2_O
2652: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2646: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute17
2647: ,P_ASS_ATTRIBUTE18_O
2648: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2649: ,P_ASS_ATTRIBUTE19_O
2650: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2651: ,P_ASS_ATTRIBUTE2_O
2652: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2653: ,P_ASS_ATTRIBUTE20_O
2654: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2648: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute18
2649: ,P_ASS_ATTRIBUTE19_O
2650: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2651: ,P_ASS_ATTRIBUTE2_O
2652: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2653: ,P_ASS_ATTRIBUTE20_O
2654: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2655: ,P_ASS_ATTRIBUTE21_O
2656: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2650: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute19
2651: ,P_ASS_ATTRIBUTE2_O
2652: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2653: ,P_ASS_ATTRIBUTE20_O
2654: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2655: ,P_ASS_ATTRIBUTE21_O
2656: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2657: ,P_ASS_ATTRIBUTE22_O
2658: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2652: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute2
2653: ,P_ASS_ATTRIBUTE20_O
2654: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2655: ,P_ASS_ATTRIBUTE21_O
2656: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2657: ,P_ASS_ATTRIBUTE22_O
2658: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2659: ,P_ASS_ATTRIBUTE23_O
2660: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2654: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute20
2655: ,P_ASS_ATTRIBUTE21_O
2656: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2657: ,P_ASS_ATTRIBUTE22_O
2658: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2659: ,P_ASS_ATTRIBUTE23_O
2660: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2661: ,P_ASS_ATTRIBUTE24_O
2662: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2656: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute21
2657: ,P_ASS_ATTRIBUTE22_O
2658: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2659: ,P_ASS_ATTRIBUTE23_O
2660: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2661: ,P_ASS_ATTRIBUTE24_O
2662: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2663: ,P_ASS_ATTRIBUTE25_O
2664: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2658: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute22
2659: ,P_ASS_ATTRIBUTE23_O
2660: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2661: ,P_ASS_ATTRIBUTE24_O
2662: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2663: ,P_ASS_ATTRIBUTE25_O
2664: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2665: ,P_ASS_ATTRIBUTE26_O
2666: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2660: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute23
2661: ,P_ASS_ATTRIBUTE24_O
2662: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2663: ,P_ASS_ATTRIBUTE25_O
2664: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2665: ,P_ASS_ATTRIBUTE26_O
2666: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2667: ,P_ASS_ATTRIBUTE27_O
2668: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2662: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute24
2663: ,P_ASS_ATTRIBUTE25_O
2664: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2665: ,P_ASS_ATTRIBUTE26_O
2666: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2667: ,P_ASS_ATTRIBUTE27_O
2668: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2669: ,P_ASS_ATTRIBUTE28_O
2670: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2664: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute25
2665: ,P_ASS_ATTRIBUTE26_O
2666: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2667: ,P_ASS_ATTRIBUTE27_O
2668: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2669: ,P_ASS_ATTRIBUTE28_O
2670: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2671: ,P_ASS_ATTRIBUTE29_O
2672: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2666: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute26
2667: ,P_ASS_ATTRIBUTE27_O
2668: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2669: ,P_ASS_ATTRIBUTE28_O
2670: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2671: ,P_ASS_ATTRIBUTE29_O
2672: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2673: ,P_ASS_ATTRIBUTE3_O
2674: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2668: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute27
2669: ,P_ASS_ATTRIBUTE28_O
2670: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2671: ,P_ASS_ATTRIBUTE29_O
2672: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2673: ,P_ASS_ATTRIBUTE3_O
2674: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2675: ,P_ASS_ATTRIBUTE30_O
2676: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2670: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute28
2671: ,P_ASS_ATTRIBUTE29_O
2672: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2673: ,P_ASS_ATTRIBUTE3_O
2674: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2675: ,P_ASS_ATTRIBUTE30_O
2676: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2677: ,P_ASS_ATTRIBUTE4_O
2678: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2672: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute29
2673: ,P_ASS_ATTRIBUTE3_O
2674: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2675: ,P_ASS_ATTRIBUTE30_O
2676: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2677: ,P_ASS_ATTRIBUTE4_O
2678: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2679: ,P_ASS_ATTRIBUTE5_O
2680: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2674: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute3
2675: ,P_ASS_ATTRIBUTE30_O
2676: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2677: ,P_ASS_ATTRIBUTE4_O
2678: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2679: ,P_ASS_ATTRIBUTE5_O
2680: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2681: ,P_ASS_ATTRIBUTE6_O
2682: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2676: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute30
2677: ,P_ASS_ATTRIBUTE4_O
2678: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2679: ,P_ASS_ATTRIBUTE5_O
2680: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2681: ,P_ASS_ATTRIBUTE6_O
2682: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2683: ,P_ASS_ATTRIBUTE7_O
2684: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2678: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute4
2679: ,P_ASS_ATTRIBUTE5_O
2680: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2681: ,P_ASS_ATTRIBUTE6_O
2682: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2683: ,P_ASS_ATTRIBUTE7_O
2684: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2685: ,P_ASS_ATTRIBUTE8_O
2686: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2680: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute5
2681: ,P_ASS_ATTRIBUTE6_O
2682: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2683: ,P_ASS_ATTRIBUTE7_O
2684: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2685: ,P_ASS_ATTRIBUTE8_O
2686: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2687: ,P_ASS_ATTRIBUTE9_O
2688: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2682: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute6
2683: ,P_ASS_ATTRIBUTE7_O
2684: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2685: ,P_ASS_ATTRIBUTE8_O
2686: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2687: ,P_ASS_ATTRIBUTE9_O
2688: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2689: ,P_ASS_ATTRIBUTE_CATEGORY_O
2690: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2684: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute7
2685: ,P_ASS_ATTRIBUTE8_O
2686: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2687: ,P_ASS_ATTRIBUTE9_O
2688: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2689: ,P_ASS_ATTRIBUTE_CATEGORY_O
2690: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2691: ,P_BARGAINING_UNIT_CODE_O
2692: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2686: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute8
2687: ,P_ASS_ATTRIBUTE9_O
2688: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2689: ,P_ASS_ATTRIBUTE_CATEGORY_O
2690: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2691: ,P_BARGAINING_UNIT_CODE_O
2692: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2693: ,P_BUSINESS_GROUP_ID_O
2694: => p_bg_id
2688: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute9
2689: ,P_ASS_ATTRIBUTE_CATEGORY_O
2690: => per_assignments_f2_pkg.g_old_asg_rec.ass_attribute_category
2691: ,P_BARGAINING_UNIT_CODE_O
2692: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2693: ,P_BUSINESS_GROUP_ID_O
2694: => p_bg_id
2695: ,P_CAGR_GRADE_DEF_ID_O
2696: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2692: => per_assignments_f2_pkg.g_old_asg_rec.bargaining_unit_code
2693: ,P_BUSINESS_GROUP_ID_O
2694: => p_bg_id
2695: ,P_CAGR_GRADE_DEF_ID_O
2696: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2697: ,P_CAGR_ID_FLEX_NUM_O
2698: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2699: ,P_CHANGE_REASON_O
2700: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2694: => p_bg_id
2695: ,P_CAGR_GRADE_DEF_ID_O
2696: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2697: ,P_CAGR_ID_FLEX_NUM_O
2698: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2699: ,P_CHANGE_REASON_O
2700: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2701: ,P_COLLECTIVE_AGREEMENT_ID_O
2702: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2696: => per_assignments_f2_pkg.g_old_asg_rec.cagr_grade_def_id
2697: ,P_CAGR_ID_FLEX_NUM_O
2698: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2699: ,P_CHANGE_REASON_O
2700: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2701: ,P_COLLECTIVE_AGREEMENT_ID_O
2702: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2703: ,P_COMMENT_ID_O
2704: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2698: => per_assignments_f2_pkg.g_old_asg_rec.cagr_id_flex_num
2699: ,P_CHANGE_REASON_O
2700: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2701: ,P_COLLECTIVE_AGREEMENT_ID_O
2702: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2703: ,P_COMMENT_ID_O
2704: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2705: ,P_CONTRACT_ID_O
2706: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2700: => per_assignments_f2_pkg.g_old_asg_rec.change_reason
2701: ,P_COLLECTIVE_AGREEMENT_ID_O
2702: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2703: ,P_COMMENT_ID_O
2704: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2705: ,P_CONTRACT_ID_O
2706: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2707: ,P_DATE_PROBATION_END_O
2708: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2702: => per_assignments_f2_pkg.g_old_asg_rec.collective_agreement_id
2703: ,P_COMMENT_ID_O
2704: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2705: ,P_CONTRACT_ID_O
2706: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2707: ,P_DATE_PROBATION_END_O
2708: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2709: ,P_DEFAULT_CODE_COMB_ID_O
2710: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2704: => per_assignments_f2_pkg.g_old_asg_rec.comment_id
2705: ,P_CONTRACT_ID_O
2706: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2707: ,P_DATE_PROBATION_END_O
2708: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2709: ,P_DEFAULT_CODE_COMB_ID_O
2710: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2711: ,P_EFFECTIVE_END_DATE_O
2712: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2706: => per_assignments_f2_pkg.g_old_asg_rec.contract_id
2707: ,P_DATE_PROBATION_END_O
2708: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2709: ,P_DEFAULT_CODE_COMB_ID_O
2710: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2711: ,P_EFFECTIVE_END_DATE_O
2712: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2713: ,P_EFFECTIVE_START_DATE_O
2714: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2708: => per_assignments_f2_pkg.g_old_asg_rec.date_probation_end
2709: ,P_DEFAULT_CODE_COMB_ID_O
2710: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2711: ,P_EFFECTIVE_END_DATE_O
2712: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2713: ,P_EFFECTIVE_START_DATE_O
2714: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2715: ,P_EMPLOYEE_CATEGORY_O
2716: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2710: => per_assignments_f2_pkg.g_old_asg_rec.default_code_comb_id
2711: ,P_EFFECTIVE_END_DATE_O
2712: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2713: ,P_EFFECTIVE_START_DATE_O
2714: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2715: ,P_EMPLOYEE_CATEGORY_O
2716: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2717: ,P_EMPLOYMENT_CATEGORY_O
2718: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2712: => per_assignments_f2_pkg.g_old_asg_rec.effective_end_date
2713: ,P_EFFECTIVE_START_DATE_O
2714: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2715: ,P_EMPLOYEE_CATEGORY_O
2716: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2717: ,P_EMPLOYMENT_CATEGORY_O
2718: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2719: ,P_ESTABLISHMENT_ID_O
2720: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2714: => per_assignments_f2_pkg.g_old_asg_rec.effective_start_date
2715: ,P_EMPLOYEE_CATEGORY_O
2716: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2717: ,P_EMPLOYMENT_CATEGORY_O
2718: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2719: ,P_ESTABLISHMENT_ID_O
2720: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2721: ,P_FREQUENCY_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2716: => per_assignments_f2_pkg.g_old_asg_rec.employee_category
2717: ,P_EMPLOYMENT_CATEGORY_O
2718: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2719: ,P_ESTABLISHMENT_ID_O
2720: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2721: ,P_FREQUENCY_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2723: ,P_GRADE_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2718: => per_assignments_f2_pkg.g_old_asg_rec.employment_category
2719: ,P_ESTABLISHMENT_ID_O
2720: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2721: ,P_FREQUENCY_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2723: ,P_GRADE_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2725: ,P_HOURLY_SALARIED_CODE_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2720: => per_assignments_f2_pkg.g_old_asg_rec.establishment_id
2721: ,P_FREQUENCY_O
2722: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2723: ,P_GRADE_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2725: ,P_HOURLY_SALARIED_CODE_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2727: ,P_INTERNAL_ADDRESS_LINE_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2722: => per_assignments_f2_pkg.g_old_asg_rec.frequency
2723: ,P_GRADE_ID_O
2724: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2725: ,P_HOURLY_SALARIED_CODE_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2727: ,P_INTERNAL_ADDRESS_LINE_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2729: ,P_JOB_ID_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2724: => per_assignments_f2_pkg.g_old_asg_rec.grade_id
2725: ,P_HOURLY_SALARIED_CODE_O
2726: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2727: ,P_INTERNAL_ADDRESS_LINE_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2729: ,P_JOB_ID_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2731: ,P_JOB_POST_SOURCE_NAME_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2726: => per_assignments_f2_pkg.g_old_asg_rec.hourly_salaried_code
2727: ,P_INTERNAL_ADDRESS_LINE_O
2728: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2729: ,P_JOB_ID_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2731: ,P_JOB_POST_SOURCE_NAME_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2733: ,P_LABOUR_UNION_MEMBER_FLAG_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2728: => per_assignments_f2_pkg.g_old_asg_rec.internal_address_line
2729: ,P_JOB_ID_O
2730: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2731: ,P_JOB_POST_SOURCE_NAME_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2733: ,P_LABOUR_UNION_MEMBER_FLAG_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2735: ,P_LOCATION_ID_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2730: => per_assignments_f2_pkg.g_old_asg_rec.job_id
2731: ,P_JOB_POST_SOURCE_NAME_O
2732: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2733: ,P_LABOUR_UNION_MEMBER_FLAG_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2735: ,P_LOCATION_ID_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2737: ,P_MANAGER_FLAG_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2732: => per_assignments_f2_pkg.g_old_asg_rec.job_post_source_name
2733: ,P_LABOUR_UNION_MEMBER_FLAG_O
2734: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2735: ,P_LOCATION_ID_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2737: ,P_MANAGER_FLAG_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2739: ,P_NORMAL_HOURS_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2734: => per_assignments_f2_pkg.g_old_asg_rec.labour_union_member_flag
2735: ,P_LOCATION_ID_O
2736: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2737: ,P_MANAGER_FLAG_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2739: ,P_NORMAL_HOURS_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2741: ,P_NOTICE_PERIOD_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2736: => per_assignments_f2_pkg.g_old_asg_rec.location_id
2737: ,P_MANAGER_FLAG_O
2738: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2739: ,P_NORMAL_HOURS_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2741: ,P_NOTICE_PERIOD_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2743: ,P_NOTICE_PERIOD_UOM_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2738: => per_assignments_f2_pkg.g_old_asg_rec.manager_flag
2739: ,P_NORMAL_HOURS_O
2740: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2741: ,P_NOTICE_PERIOD_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2743: ,P_NOTICE_PERIOD_UOM_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2745: ,P_OBJECT_VERSION_NUMBER_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2740: => per_assignments_f2_pkg.g_old_asg_rec.normal_hours
2741: ,P_NOTICE_PERIOD_O
2742: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2743: ,P_NOTICE_PERIOD_UOM_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2745: ,P_OBJECT_VERSION_NUMBER_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2747: ,P_ORGANIZATION_ID_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2742: => per_assignments_f2_pkg.g_old_asg_rec.notice_period
2743: ,P_NOTICE_PERIOD_UOM_O
2744: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2745: ,P_OBJECT_VERSION_NUMBER_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2747: ,P_ORGANIZATION_ID_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2749: ,P_PAYROLL_ID_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2744: => per_assignments_f2_pkg.g_old_asg_rec.notice_period_uom
2745: ,P_OBJECT_VERSION_NUMBER_O
2746: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2747: ,P_ORGANIZATION_ID_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2749: ,P_PAYROLL_ID_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2751: ,P_PAY_BASIS_ID_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2746: => per_assignments_f2_pkg.g_old_asg_rec.object_version_number
2747: ,P_ORGANIZATION_ID_O
2748: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2749: ,P_PAYROLL_ID_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2751: ,P_PAY_BASIS_ID_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2753: ,P_PEOPLE_GROUP_ID_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2748: => per_assignments_f2_pkg.g_old_asg_rec.organization_id
2749: ,P_PAYROLL_ID_O
2750: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2751: ,P_PAY_BASIS_ID_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2753: ,P_PEOPLE_GROUP_ID_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2755: ,P_PERF_REVIEW_PERIOD_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2750: => per_assignments_f2_pkg.g_old_asg_rec.payroll_id
2751: ,P_PAY_BASIS_ID_O
2752: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2753: ,P_PEOPLE_GROUP_ID_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2755: ,P_PERF_REVIEW_PERIOD_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2757: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2752: => per_assignments_f2_pkg.g_old_asg_rec.pay_basis_id
2753: ,P_PEOPLE_GROUP_ID_O
2754: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2755: ,P_PERF_REVIEW_PERIOD_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2757: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2759: ,P_PERIOD_OF_SERVICE_ID_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2754: => per_assignments_f2_pkg.g_old_asg_rec.people_group_id
2755: ,P_PERF_REVIEW_PERIOD_O
2756: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2757: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2759: ,P_PERIOD_OF_SERVICE_ID_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2761: ,P_PERSON_ID_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2756: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period
2757: ,P_PERF_REVIEW_PERIOD_FREQUEN_O
2758: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2759: ,P_PERIOD_OF_SERVICE_ID_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2761: ,P_PERSON_ID_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2763: ,P_PERSON_REFERRED_BY_ID_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2758: => per_assignments_f2_pkg.g_old_asg_rec.perf_review_period_frequency
2759: ,P_PERIOD_OF_SERVICE_ID_O
2760: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2761: ,P_PERSON_ID_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2763: ,P_PERSON_REFERRED_BY_ID_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2765: ,P_PLACEMENT_DATE_START_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2760: => per_assignments_f2_pkg.g_old_asg_rec.period_of_service_id
2761: ,P_PERSON_ID_O
2762: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2763: ,P_PERSON_REFERRED_BY_ID_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2765: ,P_PLACEMENT_DATE_START_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2767: ,P_POSITION_ID_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2762: => per_assignments_f2_pkg.g_old_asg_rec.person_id
2763: ,P_PERSON_REFERRED_BY_ID_O
2764: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2765: ,P_PLACEMENT_DATE_START_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2767: ,P_POSITION_ID_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2769: ,P_POSTING_CONTENT_ID_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2764: => per_assignments_f2_pkg.g_old_asg_rec.person_referred_by_id
2765: ,P_PLACEMENT_DATE_START_O
2766: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2767: ,P_POSITION_ID_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2769: ,P_POSTING_CONTENT_ID_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2771: ,P_PRIMARY_FLAG_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2766: => per_assignments_f2_pkg.g_old_asg_rec.period_of_placement_date_start
2767: ,P_POSITION_ID_O
2768: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2769: ,P_POSTING_CONTENT_ID_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2771: ,P_PRIMARY_FLAG_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2773: ,P_PROBATION_PERIOD_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2768: => per_assignments_f2_pkg.g_old_asg_rec.position_id
2769: ,P_POSTING_CONTENT_ID_O
2770: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2771: ,P_PRIMARY_FLAG_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2773: ,P_PROBATION_PERIOD_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2775: ,P_PROBATION_UNIT_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2770: => per_assignments_f2_pkg.g_old_asg_rec.posting_content_id
2771: ,P_PRIMARY_FLAG_O
2772: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2773: ,P_PROBATION_PERIOD_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2775: ,P_PROBATION_UNIT_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2777: ,P_PROGRAM_APPLICATION_ID_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2772: => per_assignments_f2_pkg.g_old_asg_rec.primary_flag
2773: ,P_PROBATION_PERIOD_O
2774: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2775: ,P_PROBATION_UNIT_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2777: ,P_PROGRAM_APPLICATION_ID_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2779: ,P_PROGRAM_ID_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2774: => per_assignments_f2_pkg.g_old_asg_rec.probation_period
2775: ,P_PROBATION_UNIT_O
2776: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2777: ,P_PROGRAM_APPLICATION_ID_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2779: ,P_PROGRAM_ID_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2781: ,P_PROGRAM_UPDATE_DATE_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2776: => per_assignments_f2_pkg.g_old_asg_rec.probation_unit
2777: ,P_PROGRAM_APPLICATION_ID_O
2778: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2779: ,P_PROGRAM_ID_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2781: ,P_PROGRAM_UPDATE_DATE_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2783: ,P_PROJECT_TITLE_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2778: => per_assignments_f2_pkg.g_old_asg_rec.program_application_id
2779: ,P_PROGRAM_ID_O
2780: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2781: ,P_PROGRAM_UPDATE_DATE_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2783: ,P_PROJECT_TITLE_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2785: ,P_RECRUITER_ID_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2780: => per_assignments_f2_pkg.g_old_asg_rec.program_id
2781: ,P_PROGRAM_UPDATE_DATE_O
2782: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2783: ,P_PROJECT_TITLE_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2785: ,P_RECRUITER_ID_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2787: ,P_RECRUITMENT_ACTIVITY_ID_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2782: => per_assignments_f2_pkg.g_old_asg_rec.program_update_date
2783: ,P_PROJECT_TITLE_O
2784: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2785: ,P_RECRUITER_ID_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2787: ,P_RECRUITMENT_ACTIVITY_ID_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2789: ,P_REQUEST_ID_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2784: => per_assignments_f2_pkg.g_old_asg_rec.project_title
2785: ,P_RECRUITER_ID_O
2786: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2787: ,P_RECRUITMENT_ACTIVITY_ID_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2789: ,P_REQUEST_ID_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2791: ,P_SAL_REVIEW_PERIOD_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2786: => per_assignments_f2_pkg.g_old_asg_rec.recruiter_id
2787: ,P_RECRUITMENT_ACTIVITY_ID_O
2788: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2789: ,P_REQUEST_ID_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2791: ,P_SAL_REVIEW_PERIOD_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2793: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2788: => per_assignments_f2_pkg.g_old_asg_rec.recruitment_activity_id
2789: ,P_REQUEST_ID_O
2790: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2791: ,P_SAL_REVIEW_PERIOD_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2793: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2795: ,P_SET_OF_BOOKS_ID_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2790: => per_assignments_f2_pkg.g_old_asg_rec.request_id
2791: ,P_SAL_REVIEW_PERIOD_O
2792: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2793: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2795: ,P_SET_OF_BOOKS_ID_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2797: ,P_SOFT_CODING_KEYFLEX_ID_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2792: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period
2793: ,P_SAL_REVIEW_PERIOD_FREQUEN_O
2794: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2795: ,P_SET_OF_BOOKS_ID_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2797: ,P_SOFT_CODING_KEYFLEX_ID_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2799: ,P_SOURCE_ORGANIZATION_ID_O
2800: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2794: => per_assignments_f2_pkg.g_old_asg_rec.sal_review_period_frequency
2795: ,P_SET_OF_BOOKS_ID_O
2796: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2797: ,P_SOFT_CODING_KEYFLEX_ID_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2799: ,P_SOURCE_ORGANIZATION_ID_O
2800: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2801: ,P_SOURCE_TYPE_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2796: => per_assignments_f2_pkg.g_old_asg_rec.set_of_books_id
2797: ,P_SOFT_CODING_KEYFLEX_ID_O
2798: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2799: ,P_SOURCE_ORGANIZATION_ID_O
2800: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2801: ,P_SOURCE_TYPE_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2803: ,P_SPECIAL_CEILING_STEP_ID_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2798: => per_assignments_f2_pkg.g_old_asg_rec.soft_coding_keyflex_id
2799: ,P_SOURCE_ORGANIZATION_ID_O
2800: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2801: ,P_SOURCE_TYPE_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2803: ,P_SPECIAL_CEILING_STEP_ID_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2805: ,P_SUPERVISOR_ID_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2800: => per_assignments_f2_pkg.g_old_asg_rec.source_organization_id
2801: ,P_SOURCE_TYPE_O
2802: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2803: ,P_SPECIAL_CEILING_STEP_ID_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2805: ,P_SUPERVISOR_ID_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2807: ,P_TIME_NORMAL_FINISH_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2802: => per_assignments_f2_pkg.g_old_asg_rec.source_type
2803: ,P_SPECIAL_CEILING_STEP_ID_O
2804: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2805: ,P_SUPERVISOR_ID_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2807: ,P_TIME_NORMAL_FINISH_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2809: ,P_TIME_NORMAL_START_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2804: => per_assignments_f2_pkg.g_old_asg_rec.special_ceiling_step_id
2805: ,P_SUPERVISOR_ID_O
2806: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2807: ,P_TIME_NORMAL_FINISH_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2809: ,P_TIME_NORMAL_START_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2811: ,P_TITLE_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.title
2806: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_id
2807: ,P_TIME_NORMAL_FINISH_O
2808: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2809: ,P_TIME_NORMAL_START_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2811: ,P_TITLE_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.title
2813: ,P_VACANCY_ID_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2808: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_finish
2809: ,P_TIME_NORMAL_START_O
2810: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2811: ,P_TITLE_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.title
2813: ,P_VACANCY_ID_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2815: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2810: => per_assignments_f2_pkg.g_old_asg_rec.time_normal_start
2811: ,P_TITLE_O
2812: => per_assignments_f2_pkg.g_old_asg_rec.title
2813: ,P_VACANCY_ID_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2815: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2817: ,P_VENDOR_EMPLOYEE_NUMBER_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2812: => per_assignments_f2_pkg.g_old_asg_rec.title
2813: ,P_VACANCY_ID_O
2814: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2815: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2817: ,P_VENDOR_EMPLOYEE_NUMBER_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2819: ,P_VENDOR_ID_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2814: => per_assignments_f2_pkg.g_old_asg_rec.vacancy_id
2815: ,P_VENDOR_ASSIGNMENT_NUMBER_O
2816: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2817: ,P_VENDOR_EMPLOYEE_NUMBER_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2819: ,P_VENDOR_ID_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2821: ,P_WORK_AT_HOME_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2816: => per_assignments_f2_pkg.g_old_asg_rec.vendor_assignment_number
2817: ,P_VENDOR_EMPLOYEE_NUMBER_O
2818: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2819: ,P_VENDOR_ID_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2821: ,P_WORK_AT_HOME_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2823: ,P_GRADE_LADDER_PGM_ID_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2818: => per_assignments_f2_pkg.g_old_asg_rec.vendor_employee_number
2819: ,P_VENDOR_ID_O
2820: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2821: ,P_WORK_AT_HOME_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2823: ,P_GRADE_LADDER_PGM_ID_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2825: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2820: => per_assignments_f2_pkg.g_old_asg_rec.vendor_id
2821: ,P_WORK_AT_HOME_O
2822: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2823: ,P_GRADE_LADDER_PGM_ID_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2825: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2827: ,P_VENDOR_SITE_ID_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2822: => per_assignments_f2_pkg.g_old_asg_rec.work_at_home
2823: ,P_GRADE_LADDER_PGM_ID_O
2824: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2825: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2827: ,P_VENDOR_SITE_ID_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2829: ,P_PO_HEADER_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2824: => per_assignments_f2_pkg.g_old_asg_rec.grade_ladder_pgm_id
2825: ,P_SUPERVISOR_ASSIGNMENT_ID_O
2826: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2827: ,P_VENDOR_SITE_ID_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2829: ,P_PO_HEADER_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2831: ,P_PO_LINE_ID_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2826: => per_assignments_f2_pkg.g_old_asg_rec.supervisor_assignment_id
2827: ,P_VENDOR_SITE_ID_O
2828: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2829: ,P_PO_HEADER_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2831: ,P_PO_LINE_ID_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2833: ,P_PROJECTED_ASSIGNMENT_END_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2828: => per_assignments_f2_pkg.g_old_asg_rec.vendor_site_id
2829: ,P_PO_HEADER_ID_O
2830: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2831: ,P_PO_LINE_ID_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2833: ,P_PROJECTED_ASSIGNMENT_END_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2835: );
2836: --
2830: => per_assignments_f2_pkg.g_old_asg_rec.po_header_id
2831: ,P_PO_LINE_ID_O
2832: => per_assignments_f2_pkg.g_old_asg_rec.po_line_id
2833: ,P_PROJECTED_ASSIGNMENT_END_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2835: );
2836: --
2837: hr_utility.set_location('Leaving : '||l_proc,999);
2838: --
2837: hr_utility.set_location('Leaving : '||l_proc,999);
2838: --
2839: end post_delete;
2840: -----------------------------------------------------------------------------
2841: END PER_ASSIGNMENTS_F1_PKG;