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 2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

Line 2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

Line 2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

Line 2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

Line 2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE

2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

Line 2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE

2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

Line 2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE

2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

Line 2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE

2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

Line 2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE

2918: ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

Line 2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE

2919: ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

Line 2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE

2920: ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

Line 2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE

2921: ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

Line 2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE

2922: ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

Line 2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE

2923: ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

Line 2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE

2924: ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

Line 2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE

2925: ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

Line 2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE

2926: ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

Line 2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE

2927: ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

Line 2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE

2928: ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

Line 2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE

2929: ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

Line 2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE

2930: ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

Line 2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE

2931: ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

Line 2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE

2932: ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

Line 2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE

2933: ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

Line 2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE

2934: ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

Line 2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE

2935: ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

Line 2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE

2936: ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE

2937: ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

Line 2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE

2938: ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

Line 2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE

2939: ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE

Line 3468: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

3464: l_cagr_id_flex_num NUMBER;
3465: l_cagr_grade_def_id NUMBER;
3466: l_cagr_concatenated_segments VARCHAR2(240);
3467: --
3468: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3469: l_soft_coding_keyflex_id NUMBER;
3470: l_no_managers_warning BOOLEAN;
3471: l_other_manager_warning2 BOOLEAN;
3472: --

Line 3474: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;

3470: l_no_managers_warning BOOLEAN;
3471: l_other_manager_warning2 BOOLEAN;
3472: --
3473: l_pgp_rec pay_people_groups%ROWTYPE;
3474: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3475: --
3476: l_app_object_version_number per_applications.object_version_number%TYPE;
3477: --
3478: l_address_id per_addresses.address_id%TYPE;

Line 3515: SELECT * FROM hr_soft_coding_keyflex

3511: WHERE people_group_id=p_people_group_id;
3512: --
3513: CURSOR csr_scl_rec
3514: (p_soft_coding_keyflex_id NUMBER) IS
3515: SELECT * FROM hr_soft_coding_keyflex
3516: WHERE soft_coding_keyflex_id=p_soft_coding_keyflex_id;
3517: --
3518:
3519: