APPS.HR_CWK_TERMINATION_SWI dependencies on PER_PERIODS_OF_PLACEMENT

Line 1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;

1008: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;
1009: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1010:
1011: -- In out params for terminate_placement
1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1014: l_last_standard_process_date
1015: per_periods_of_placement.last_standard_process_date%TYPE;
1016:

Line 1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;

1009: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1010:
1011: -- In out params for terminate_placement
1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1014: l_last_standard_process_date
1015: per_periods_of_placement.last_standard_process_date%TYPE;
1016:
1017: validate_exception EXCEPTION;

Line 1015: per_periods_of_placement.last_standard_process_date%TYPE;

1011: -- In out params for terminate_placement
1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1014: l_last_standard_process_date
1015: per_periods_of_placement.last_standard_process_date%TYPE;
1016:
1017: validate_exception EXCEPTION;
1018:
1019: BEGIN

Line 2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;

2076: l_final_process_date VARCHAR2(100);
2077: l_last_standard_process_date VARCHAR2(100);*/
2078: /*l_projected_termination_date VARCHAR2(100);*/
2079:
2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;

Line 2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;

2077: l_last_standard_process_date VARCHAR2(100);*/
2078: /*l_projected_termination_date VARCHAR2(100);*/
2079:
2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;

Line 2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;

2078: /*l_projected_termination_date VARCHAR2(100);*/
2079:
2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;

Line 2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;

2079:
2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;

Line 2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;

2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;

Line 2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;

2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;

Line 2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;

2082: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;

Line 2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;

2083: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;

Line 2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;

2084: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;

Line 2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;

2085: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;

Line 2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;

2086: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;

Line 2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;

2087: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;

Line 2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;

2088: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;

Line 2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;

2089: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;

Line 2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;

2090: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;

Line 2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;

2091: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;

Line 2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;

2092: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;

Line 2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;

2093: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;

Line 2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;

2094: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;

Line 2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;

2095: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;

Line 2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;

2096: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;

Line 2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;

2097: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;

Line 2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;

2098: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;

Line 2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;

2099: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;

Line 2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;

2100: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;

Line 2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;

2101: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;

Line 2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;

2102: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;

Line 2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;

2103: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:

Line 2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;

2104: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;

Line 2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;

2105: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;

Line 2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;

2106: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2107: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;

Line 2112: l_information_category per_periods_of_placement.information_category%TYPE;

2108: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;

Line 2113: l_information1 per_periods_of_placement.information1%TYPE;

2109: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;

Line 2114: l_information2 per_periods_of_placement.information2%TYPE;

2110: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;

Line 2115: l_information3 per_periods_of_placement.information3%TYPE;

2111:
2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;

Line 2116: l_information4 per_periods_of_placement.information4%TYPE;

2112: l_information_category per_periods_of_placement.information_category%TYPE;
2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;

Line 2117: l_information5 per_periods_of_placement.information5%TYPE;

2113: l_information1 per_periods_of_placement.information1%TYPE;
2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;

Line 2118: l_information6 per_periods_of_placement.information6%TYPE;

2114: l_information2 per_periods_of_placement.information2%TYPE;
2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;

Line 2119: l_information7 per_periods_of_placement.information7%TYPE;

2115: l_information3 per_periods_of_placement.information3%TYPE;
2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;

Line 2120: l_information8 per_periods_of_placement.information8%TYPE;

2116: l_information4 per_periods_of_placement.information4%TYPE;
2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;

Line 2121: l_information9 per_periods_of_placement.information9%TYPE;

2117: l_information5 per_periods_of_placement.information5%TYPE;
2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;

Line 2122: l_information10 per_periods_of_placement.information10%TYPE;

2118: l_information6 per_periods_of_placement.information6%TYPE;
2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;

Line 2123: l_information11 per_periods_of_placement.information11%TYPE;

2119: l_information7 per_periods_of_placement.information7%TYPE;
2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;

Line 2124: l_information12 per_periods_of_placement.information12%TYPE;

2120: l_information8 per_periods_of_placement.information8%TYPE;
2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;

Line 2125: l_information13 per_periods_of_placement.information13%TYPE;

2121: l_information9 per_periods_of_placement.information9%TYPE;
2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;

Line 2126: l_information14 per_periods_of_placement.information14%TYPE;

2122: l_information10 per_periods_of_placement.information10%TYPE;
2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;

Line 2127: l_information15 per_periods_of_placement.information15%TYPE;

2123: l_information11 per_periods_of_placement.information11%TYPE;
2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;

Line 2128: l_information16 per_periods_of_placement.information16%TYPE;

2124: l_information12 per_periods_of_placement.information12%TYPE;
2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;

Line 2129: l_information17 per_periods_of_placement.information17%TYPE;

2125: l_information13 per_periods_of_placement.information13%TYPE;
2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;

Line 2130: l_information18 per_periods_of_placement.information18%TYPE;

2126: l_information14 per_periods_of_placement.information14%TYPE;
2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;

Line 2131: l_information19 per_periods_of_placement.information19%TYPE;

2127: l_information15 per_periods_of_placement.information15%TYPE;
2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;

Line 2132: l_information20 per_periods_of_placement.information20%TYPE;

2128: l_information16 per_periods_of_placement.information16%TYPE;
2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;

Line 2133: l_information21 per_periods_of_placement.information21%TYPE;

2129: l_information17 per_periods_of_placement.information17%TYPE;
2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;

Line 2134: l_information22 per_periods_of_placement.information22%TYPE;

2130: l_information18 per_periods_of_placement.information18%TYPE;
2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;

Line 2135: l_information23 per_periods_of_placement.information23%TYPE;

2131: l_information19 per_periods_of_placement.information19%TYPE;
2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;

Line 2136: l_information24 per_periods_of_placement.information24%TYPE;

2132: l_information20 per_periods_of_placement.information20%TYPE;
2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;

Line 2137: l_information25 per_periods_of_placement.information25%TYPE;

2133: l_information21 per_periods_of_placement.information21%TYPE;
2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;

Line 2138: l_information26 per_periods_of_placement.information26%TYPE;

2134: l_information22 per_periods_of_placement.information22%TYPE;
2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;
2142: l_information30 per_periods_of_placement.information30%TYPE;

Line 2139: l_information27 per_periods_of_placement.information27%TYPE;

2135: l_information23 per_periods_of_placement.information23%TYPE;
2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;
2142: l_information30 per_periods_of_placement.information30%TYPE;
2143:

Line 2140: l_information28 per_periods_of_placement.information28%TYPE;

2136: l_information24 per_periods_of_placement.information24%TYPE;
2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;
2142: l_information30 per_periods_of_placement.information30%TYPE;
2143:
2144: l_entries_changed_warning VARCHAR2(30);

Line 2141: l_information29 per_periods_of_placement.information29%TYPE;

2137: l_information25 per_periods_of_placement.information25%TYPE;
2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;
2142: l_information30 per_periods_of_placement.information30%TYPE;
2143:
2144: l_entries_changed_warning VARCHAR2(30);
2145: l_return_status VARCHAR2(30);

Line 2142: l_information30 per_periods_of_placement.information30%TYPE;

2138: l_information26 per_periods_of_placement.information26%TYPE;
2139: l_information27 per_periods_of_placement.information27%TYPE;
2140: l_information28 per_periods_of_placement.information28%TYPE;
2141: l_information29 per_periods_of_placement.information29%TYPE;
2142: l_information30 per_periods_of_placement.information30%TYPE;
2143:
2144: l_entries_changed_warning VARCHAR2(30);
2145: l_return_status VARCHAR2(30);
2146:

Line 2147: l_person_id per_periods_of_placement.person_id%TYPE;

2143:
2144: l_entries_changed_warning VARCHAR2(30);
2145: l_return_status VARCHAR2(30);
2146:
2147: l_person_id per_periods_of_placement.person_id%TYPE;
2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;

Line 2148: l_date_start per_periods_of_placement.date_start%TYPE;

2144: l_entries_changed_warning VARCHAR2(30);
2145: l_return_status VARCHAR2(30);
2146:
2147: l_person_id per_periods_of_placement.person_id%TYPE;
2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;

Line 2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;

2145: l_return_status VARCHAR2(30);
2146:
2147: l_person_id per_periods_of_placement.person_id%TYPE;
2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

Line 2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;

2147: l_person_id per_periods_of_placement.person_id%TYPE;
2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;

Line 2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;

2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

Line 2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

Line 2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;

2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2158:

Line 2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;

2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2158:
2159: l_proc varchar2(72) := g_package ||'process_api';