APPS.HR_CWK_TERMINATION_SWI dependencies on PER_PERIODS_OF_PLACEMENT

Line 1009: l_object_version_number per_periods_of_placement.object_version_number%TYPE;

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

Line 1010: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;

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

Line 1012: per_periods_of_placement.last_standard_process_date%TYPE;

1008: -- In out params for terminate_placement
1009: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1010: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1011: l_last_standard_process_date
1012: per_periods_of_placement.last_standard_process_date%TYPE;
1013:
1014: validate_exception EXCEPTION;
1015:
1016: ItemType varchar2(200);

Line 2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;

2143: l_final_process_date VARCHAR2(100);
2144: l_last_standard_process_date VARCHAR2(100);*/
2145: /*l_projected_termination_date VARCHAR2(100);*/
2146:
2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;

Line 2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;

2144: l_last_standard_process_date VARCHAR2(100);*/
2145: /*l_projected_termination_date VARCHAR2(100);*/
2146:
2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;

Line 2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;

2145: /*l_projected_termination_date VARCHAR2(100);*/
2146:
2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;

Line 2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;

2146:
2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;

Line 2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;

2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;

Line 2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;

2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;
2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;

Line 2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;

2149: l_attribute2 per_periods_of_placement.attribute2%TYPE;
2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;

Line 2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;

2150: l_attribute3 per_periods_of_placement.attribute3%TYPE;
2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;

Line 2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;

2151: l_attribute4 per_periods_of_placement.attribute4%TYPE;
2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;

Line 2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;

2152: l_attribute5 per_periods_of_placement.attribute5%TYPE;
2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;

Line 2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;

2153: l_attribute6 per_periods_of_placement.attribute6%TYPE;
2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;

Line 2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;

2154: l_attribute7 per_periods_of_placement.attribute7%TYPE;
2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;

Line 2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;

2155: l_attribute8 per_periods_of_placement.attribute8%TYPE;
2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;

Line 2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;

2156: l_attribute9 per_periods_of_placement.attribute9%TYPE;
2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;

Line 2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;

2157: l_attribute10 per_periods_of_placement.attribute10%TYPE;
2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;

Line 2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;

2158: l_attribute11 per_periods_of_placement.attribute11%TYPE;
2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;

Line 2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;

2159: l_attribute12 per_periods_of_placement.attribute12%TYPE;
2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;

Line 2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;

2160: l_attribute13 per_periods_of_placement.attribute13%TYPE;
2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;

Line 2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;

2161: l_attribute14 per_periods_of_placement.attribute14%TYPE;
2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;

Line 2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;

2162: l_attribute15 per_periods_of_placement.attribute15%TYPE;
2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;

Line 2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;

2163: l_attribute16 per_periods_of_placement.attribute16%TYPE;
2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;

Line 2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;

2164: l_attribute17 per_periods_of_placement.attribute17%TYPE;
2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;

Line 2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;

2165: l_attribute18 per_periods_of_placement.attribute18%TYPE;
2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;

Line 2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;

2166: l_attribute19 per_periods_of_placement.attribute19%TYPE;
2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;

Line 2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;

2167: l_attribute20 per_periods_of_placement.attribute20%TYPE;
2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;

Line 2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;

2168: l_attribute21 per_periods_of_placement.attribute21%TYPE;
2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;

Line 2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;

2169: l_attribute22 per_periods_of_placement.attribute22%TYPE;
2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;

Line 2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;

2170: l_attribute23 per_periods_of_placement.attribute23%TYPE;
2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:

Line 2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;

2171: l_attribute24 per_periods_of_placement.attribute24%TYPE;
2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;

Line 2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;

2172: l_attribute25 per_periods_of_placement.attribute25%TYPE;
2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;

Line 2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;

2173: l_attribute26 per_periods_of_placement.attribute26%TYPE;
2174: l_attribute27 per_periods_of_placement.attribute27%TYPE;
2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;

Line 2179: l_information_category per_periods_of_placement.information_category%TYPE;

2175: l_attribute28 per_periods_of_placement.attribute28%TYPE;
2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;

Line 2180: l_information1 per_periods_of_placement.information1%TYPE;

2176: l_attribute29 per_periods_of_placement.attribute29%TYPE;
2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;

Line 2181: l_information2 per_periods_of_placement.information2%TYPE;

2177: l_attribute30 per_periods_of_placement.attribute30%TYPE;
2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;

Line 2182: l_information3 per_periods_of_placement.information3%TYPE;

2178:
2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;

Line 2183: l_information4 per_periods_of_placement.information4%TYPE;

2179: l_information_category per_periods_of_placement.information_category%TYPE;
2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;

Line 2184: l_information5 per_periods_of_placement.information5%TYPE;

2180: l_information1 per_periods_of_placement.information1%TYPE;
2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;

Line 2185: l_information6 per_periods_of_placement.information6%TYPE;

2181: l_information2 per_periods_of_placement.information2%TYPE;
2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;

Line 2186: l_information7 per_periods_of_placement.information7%TYPE;

2182: l_information3 per_periods_of_placement.information3%TYPE;
2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;

Line 2187: l_information8 per_periods_of_placement.information8%TYPE;

2183: l_information4 per_periods_of_placement.information4%TYPE;
2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;

Line 2188: l_information9 per_periods_of_placement.information9%TYPE;

2184: l_information5 per_periods_of_placement.information5%TYPE;
2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;

Line 2189: l_information10 per_periods_of_placement.information10%TYPE;

2185: l_information6 per_periods_of_placement.information6%TYPE;
2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;

Line 2190: l_information11 per_periods_of_placement.information11%TYPE;

2186: l_information7 per_periods_of_placement.information7%TYPE;
2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;

Line 2191: l_information12 per_periods_of_placement.information12%TYPE;

2187: l_information8 per_periods_of_placement.information8%TYPE;
2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;

Line 2192: l_information13 per_periods_of_placement.information13%TYPE;

2188: l_information9 per_periods_of_placement.information9%TYPE;
2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;

Line 2193: l_information14 per_periods_of_placement.information14%TYPE;

2189: l_information10 per_periods_of_placement.information10%TYPE;
2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;

Line 2194: l_information15 per_periods_of_placement.information15%TYPE;

2190: l_information11 per_periods_of_placement.information11%TYPE;
2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;

Line 2195: l_information16 per_periods_of_placement.information16%TYPE;

2191: l_information12 per_periods_of_placement.information12%TYPE;
2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;

Line 2196: l_information17 per_periods_of_placement.information17%TYPE;

2192: l_information13 per_periods_of_placement.information13%TYPE;
2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;

Line 2197: l_information18 per_periods_of_placement.information18%TYPE;

2193: l_information14 per_periods_of_placement.information14%TYPE;
2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;

Line 2198: l_information19 per_periods_of_placement.information19%TYPE;

2194: l_information15 per_periods_of_placement.information15%TYPE;
2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;

Line 2199: l_information20 per_periods_of_placement.information20%TYPE;

2195: l_information16 per_periods_of_placement.information16%TYPE;
2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;

Line 2200: l_information21 per_periods_of_placement.information21%TYPE;

2196: l_information17 per_periods_of_placement.information17%TYPE;
2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;

Line 2201: l_information22 per_periods_of_placement.information22%TYPE;

2197: l_information18 per_periods_of_placement.information18%TYPE;
2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;

Line 2202: l_information23 per_periods_of_placement.information23%TYPE;

2198: l_information19 per_periods_of_placement.information19%TYPE;
2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;

Line 2203: l_information24 per_periods_of_placement.information24%TYPE;

2199: l_information20 per_periods_of_placement.information20%TYPE;
2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;

Line 2204: l_information25 per_periods_of_placement.information25%TYPE;

2200: l_information21 per_periods_of_placement.information21%TYPE;
2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;

Line 2205: l_information26 per_periods_of_placement.information26%TYPE;

2201: l_information22 per_periods_of_placement.information22%TYPE;
2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;
2209: l_information30 per_periods_of_placement.information30%TYPE;

Line 2206: l_information27 per_periods_of_placement.information27%TYPE;

2202: l_information23 per_periods_of_placement.information23%TYPE;
2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;
2209: l_information30 per_periods_of_placement.information30%TYPE;
2210:

Line 2207: l_information28 per_periods_of_placement.information28%TYPE;

2203: l_information24 per_periods_of_placement.information24%TYPE;
2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;
2209: l_information30 per_periods_of_placement.information30%TYPE;
2210:
2211: l_entries_changed_warning VARCHAR2(30);

Line 2208: l_information29 per_periods_of_placement.information29%TYPE;

2204: l_information25 per_periods_of_placement.information25%TYPE;
2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;
2209: l_information30 per_periods_of_placement.information30%TYPE;
2210:
2211: l_entries_changed_warning VARCHAR2(30);
2212: l_return_status VARCHAR2(30);

Line 2209: l_information30 per_periods_of_placement.information30%TYPE;

2205: l_information26 per_periods_of_placement.information26%TYPE;
2206: l_information27 per_periods_of_placement.information27%TYPE;
2207: l_information28 per_periods_of_placement.information28%TYPE;
2208: l_information29 per_periods_of_placement.information29%TYPE;
2209: l_information30 per_periods_of_placement.information30%TYPE;
2210:
2211: l_entries_changed_warning VARCHAR2(30);
2212: l_return_status VARCHAR2(30);
2213:

Line 2214: l_person_id per_periods_of_placement.person_id%TYPE;

2210:
2211: l_entries_changed_warning VARCHAR2(30);
2212: l_return_status VARCHAR2(30);
2213:
2214: l_person_id per_periods_of_placement.person_id%TYPE;
2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;

Line 2215: l_date_start per_periods_of_placement.date_start%TYPE;

2211: l_entries_changed_warning VARCHAR2(30);
2212: l_return_status VARCHAR2(30);
2213:
2214: l_person_id per_periods_of_placement.person_id%TYPE;
2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;

Line 2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;

2212: l_return_status VARCHAR2(30);
2213:
2214: l_person_id per_periods_of_placement.person_id%TYPE;
2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

Line 2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;

2214: l_person_id per_periods_of_placement.person_id%TYPE;
2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;

Line 2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;

2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

Line 2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

Line 2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;

2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2225:

Line 2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;

2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2225:
2226: l_proc varchar2(72) := g_package ||'process_api';