eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_MAINTAIN_UPDATE dependencies on HR_SOFT_CODING_KEYFLEX

Line 214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

210: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
211: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
212: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
213: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

Line 215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

211: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
212: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
213: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

Line 216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

212: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
213: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

Line 217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

213: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

Line 218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

214: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

Line 219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

215: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

Line 220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

216: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

Line 221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

217: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

Line 222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

218: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

Line 223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

219: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

Line 224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

220: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

Line 225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

221: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

Line 226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

222: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

Line 227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

223: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

Line 228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

224: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

Line 229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

225: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

Line 230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

226: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

Line 231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

227: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

Line 232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

228: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

Line 233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

229: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

Line 234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

230: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

Line 235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

231: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

Line 236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

232: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

Line 237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

233: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

Line 238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

234: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

Line 239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

235: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

Line 240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

236: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
244: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

237: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
244: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
245: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

Line 242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

238: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
244: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
245: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
246: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

Line 243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

239: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
240: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
241: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
242: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
243: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
244: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
245: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
246: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
247: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE

Line 765: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

761: l_tax_district_changed_warning BOOLEAN;
762: l_cagr_grade_def_id NUMBER;
763: l_cagr_concatenated_segments VARCHAR2(240);
764: --
765: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
766: l_soft_coding_keyflex_id NUMBER;
767: l_no_managers_warning BOOLEAN;
768: l_other_manager_warning2 BOOLEAN;
769: --

Line 771: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;

767: l_no_managers_warning BOOLEAN;
768: l_other_manager_warning2 BOOLEAN;
769: --
770: l_pgp_rec pay_people_groups%ROWTYPE;
771: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
772: --
773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;
775: --

Line 2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

Line 2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

Line 2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

Line 2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

Line 2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

Line 2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

Line 2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

Line 2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

Line 2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

2884: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

Line 2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

2885: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

Line 2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

2886: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

Line 2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

2887: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

Line 2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

2888: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

Line 2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

2889: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

Line 2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

2890: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

Line 2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

2891: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

Line 2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

2892: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

Line 2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

2893: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

Line 2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

2894: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

Line 2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

2895: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

Line 2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

2896: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

Line 2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

2897: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

Line 2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

2898: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

Line 2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

2899: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

Line 2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

2900: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

Line 2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

2901: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

Line 2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

2902: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

2903: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

Line 2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

2904: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

Line 2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

2905: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE

Line 3434: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

3430: l_cagr_id_flex_num NUMBER;
3431: l_cagr_grade_def_id NUMBER;
3432: l_cagr_concatenated_segments VARCHAR2(240);
3433: --
3434: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3435: l_soft_coding_keyflex_id NUMBER;
3436: l_no_managers_warning BOOLEAN;
3437: l_other_manager_warning2 BOOLEAN;
3438: --

Line 3440: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;

3436: l_no_managers_warning BOOLEAN;
3437: l_other_manager_warning2 BOOLEAN;
3438: --
3439: l_pgp_rec pay_people_groups%ROWTYPE;
3440: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3441: --
3442: l_app_object_version_number per_applications.object_version_number%TYPE;
3443: --
3444: l_address_id per_addresses.address_id%TYPE;

Line 3481: SELECT * FROM hr_soft_coding_keyflex

3477: WHERE people_group_id=p_people_group_id;
3478: --
3479: CURSOR csr_scl_rec
3480: (p_soft_coding_keyflex_id NUMBER) IS
3481: SELECT * FROM hr_soft_coding_keyflex
3482: WHERE soft_coding_keyflex_id=p_soft_coding_keyflex_id;
3483: --
3484:
3485: