APPS.PN_CC_SYNC_PKG dependencies on DBMS_SQL

Line 33: | dbms_sql.

29: | MODIFICATION HISTORY
30: |
31: | 13-NOV-03 Vikas Mehta Created
32: | 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using
33: | dbms_sql.
34: | 04-APR-06 Hareesha o Bug 5119241 Modified call to
35: | PN_SPACE_ASSIGN_EMP_PKG.Update_Row to pass
36: | new CC.
37: | 30-JUN-06 Hareesha o Bug #5262982 Select org_id too in the query

Line 141: l_cursor := dbms_sql.open_cursor;

137: l_column_name := pnp_util_func.get_segment_column_name(pn_mo_cache_utils.get_current_org_id);
138:
139: l_log_context := ' Defining sub-query for location ';
140:
141: l_cursor := dbms_sql.open_cursor;
142: x_as_of_date := l_as_of_date;
143:
144: l_where_clause_loc := ' WHERE :x_as_of_date between trunc(active_start_date) and trunc(active_end_date) ';
145:

Line 261: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);

257:
258: /* uncomment for debugging purposes */
259: /*pnp_debug_pkg.log('l_query is : '|| l_query);*/
260:
261: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
262:
263: dbms_sql.bind_variable
264: (l_cursor,'x_as_of_date',x_as_of_date );
265:

Line 263: dbms_sql.bind_variable

259: /*pnp_debug_pkg.log('l_query is : '|| l_query);*/
260:
261: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
262:
263: dbms_sql.bind_variable
264: (l_cursor,'x_as_of_date',x_as_of_date );
265:
266: dbms_sql.bind_variable
267: (l_cursor,'x_last_person_processed',x_last_person_processed );

Line 266: dbms_sql.bind_variable

262:
263: dbms_sql.bind_variable
264: (l_cursor,'x_as_of_date',x_as_of_date );
265:
266: dbms_sql.bind_variable
267: (l_cursor,'x_last_person_processed',x_last_person_processed );
268:
269: IF p_emp_cost_center IS NOT NULL THEN
270: dbms_sql.bind_variable

Line 270: dbms_sql.bind_variable

266: dbms_sql.bind_variable
267: (l_cursor,'x_last_person_processed',x_last_person_processed );
268:
269: IF p_emp_cost_center IS NOT NULL THEN
270: dbms_sql.bind_variable
271: (l_cursor,'l_emp_cost_center',l_emp_cost_center );
272: END IF;
273:
274: IF p_locn_type IS NULL THEN

Line 276: dbms_sql.bind_variable

272: END IF;
273:
274: IF p_locn_type IS NULL THEN
275: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
276: dbms_sql.bind_variable
277: (l_cursor,'l_locn_code_from',l_locn_code_from );
278: dbms_sql.bind_variable
279: (l_cursor,'l_locn_code_to',l_locn_code_to );
280: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN

Line 278: dbms_sql.bind_variable

274: IF p_locn_type IS NULL THEN
275: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
276: dbms_sql.bind_variable
277: (l_cursor,'l_locn_code_from',l_locn_code_from );
278: dbms_sql.bind_variable
279: (l_cursor,'l_locn_code_to',l_locn_code_to );
280: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
281: dbms_sql.bind_variable
282: (l_cursor,'l_locn_code_from',l_locn_code_from );

Line 281: dbms_sql.bind_variable

277: (l_cursor,'l_locn_code_from',l_locn_code_from );
278: dbms_sql.bind_variable
279: (l_cursor,'l_locn_code_to',l_locn_code_to );
280: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
281: dbms_sql.bind_variable
282: (l_cursor,'l_locn_code_from',l_locn_code_from );
283: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
284: dbms_sql.bind_variable
285: (l_cursor,'l_locn_code_to',l_locn_code_to );

Line 284: dbms_sql.bind_variable

280: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
281: dbms_sql.bind_variable
282: (l_cursor,'l_locn_code_from',l_locn_code_from );
283: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
284: dbms_sql.bind_variable
285: (l_cursor,'l_locn_code_to',l_locn_code_to );
286: END IF;
287: ELSE
288: dbms_sql.bind_variable

Line 288: dbms_sql.bind_variable

284: dbms_sql.bind_variable
285: (l_cursor,'l_locn_code_to',l_locn_code_to );
286: END IF;
287: ELSE
288: dbms_sql.bind_variable
289: (l_cursor,'l_locn_type',l_locn_type );
290: dbms_sql.bind_variable
291: (l_cursor,'x_as_of_date',x_as_of_date );
292:

Line 290: dbms_sql.bind_variable

286: END IF;
287: ELSE
288: dbms_sql.bind_variable
289: (l_cursor,'l_locn_type',l_locn_type );
290: dbms_sql.bind_variable
291: (l_cursor,'x_as_of_date',x_as_of_date );
292:
293: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
294: dbms_sql.bind_variable

Line 294: dbms_sql.bind_variable

290: dbms_sql.bind_variable
291: (l_cursor,'x_as_of_date',x_as_of_date );
292:
293: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
294: dbms_sql.bind_variable
295: (l_cursor,'l_locn_code_from',l_locn_code_from );
296: dbms_sql.bind_variable
297: (l_cursor,'l_locn_code_to',l_locn_code_to );
298: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN

Line 296: dbms_sql.bind_variable

292:
293: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
294: dbms_sql.bind_variable
295: (l_cursor,'l_locn_code_from',l_locn_code_from );
296: dbms_sql.bind_variable
297: (l_cursor,'l_locn_code_to',l_locn_code_to );
298: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
299: dbms_sql.bind_variable
300: (l_cursor,'l_locn_code_from',l_locn_code_from );

Line 299: dbms_sql.bind_variable

295: (l_cursor,'l_locn_code_from',l_locn_code_from );
296: dbms_sql.bind_variable
297: (l_cursor,'l_locn_code_to',l_locn_code_to );
298: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
299: dbms_sql.bind_variable
300: (l_cursor,'l_locn_code_from',l_locn_code_from );
301: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
302: dbms_sql.bind_variable
303: (l_cursor,'l_locn_code_to',l_locn_code_to );

Line 302: dbms_sql.bind_variable

298: ELSIF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NULL THEN
299: dbms_sql.bind_variable
300: (l_cursor,'l_locn_code_from',l_locn_code_from );
301: ELSIF p_locn_code_from IS NULL AND p_locn_code_to IS NOT NULL THEN
302: dbms_sql.bind_variable
303: (l_cursor,'l_locn_code_to',l_locn_code_to );
304: END IF;
305: END IF;
306:

Line 307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);

303: (l_cursor,'l_locn_code_to',l_locn_code_to );
304: END IF;
305: END IF;
306:
307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);

Line 308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);

304: END IF;
305: END IF;
306:
307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);

Line 309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);

305: END IF;
306:
307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);

Line 310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);

306:
307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);

Line 311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);

307: dbms_sql.define_column (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);

Line 312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);

308: dbms_sql.define_column (l_cursor, 2,asg_rec.LOCATION_ID);
309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);

Line 313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);

309: dbms_sql.define_column (l_cursor, 3,asg_rec.PERSON_ID);
310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);

Line 314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);

310: dbms_sql.define_column (l_cursor, 4,asg_rec.PROJECT_ID);
311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);

Line 315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);

311: dbms_sql.define_column (l_cursor, 5,asg_rec.TASK_ID);
312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);

Line 316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);

312: dbms_sql.define_column (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);

Line 317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);

313: dbms_sql.define_column (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);

Line 318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);

314: dbms_sql.define_column (l_cursor, 8,asg_rec.COST_CENTER_CODE,30);
315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);

Line 319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);

315: dbms_sql.define_column (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);

Line 320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);

316: dbms_sql.define_column (l_cursor, 10,asg_rec.ALLOCATED_AREA);
317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);

Line 321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);

317: dbms_sql.define_column (l_cursor, 11,asg_rec.UTILIZED_AREA);
318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);

Line 322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);

318: dbms_sql.define_column (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS,2000);
319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);

Line 323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);

319: dbms_sql.define_column (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);

Line 324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);

320: dbms_sql.define_column (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);

Line 325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);

321: dbms_sql.define_column (l_cursor, 15,asg_rec.CREATION_DATE);
322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);

Line 326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);

322: dbms_sql.define_column (l_cursor, 16,asg_rec.CREATED_BY);
323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);

Line 327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);

323: dbms_sql.define_column (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);

Line 328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);

324: dbms_sql.define_column (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY,30);
325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);

Line 329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);

325: dbms_sql.define_column (l_cursor, 19,asg_rec.ATTRIBUTE1,150);
326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);

Line 330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);

326: dbms_sql.define_column (l_cursor, 20,asg_rec.ATTRIBUTE2,150);
327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);

Line 331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);

327: dbms_sql.define_column (l_cursor, 21,asg_rec.ATTRIBUTE3,150);
328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);

Line 332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);

328: dbms_sql.define_column (l_cursor, 22,asg_rec.ATTRIBUTE4,150);
329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);

Line 333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);

329: dbms_sql.define_column (l_cursor, 23,asg_rec.ATTRIBUTE5,150);
330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);

Line 334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);

330: dbms_sql.define_column (l_cursor, 24,asg_rec.ATTRIBUTE6,150);
331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);

Line 335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);

331: dbms_sql.define_column (l_cursor, 25,asg_rec.ATTRIBUTE7,150);
332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);

Line 336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);

332: dbms_sql.define_column (l_cursor, 26,asg_rec.ATTRIBUTE8,150);
333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);

Line 337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);

333: dbms_sql.define_column (l_cursor, 27,asg_rec.ATTRIBUTE9,150);
334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);
341:

Line 338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);

334: dbms_sql.define_column (l_cursor, 28,asg_rec.ATTRIBUTE10,150);
335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);
341:
342: l_rows := dbms_sql.execute(l_cursor);

Line 339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);

335: dbms_sql.define_column (l_cursor, 29,asg_rec.ATTRIBUTE11,150);
336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);
341:
342: l_rows := dbms_sql.execute(l_cursor);
343:

Line 340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);

336: dbms_sql.define_column (l_cursor, 30,asg_rec.ATTRIBUTE12,150);
337: dbms_sql.define_column (l_cursor, 31,asg_rec.ATTRIBUTE13,150);
338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);
341:
342: l_rows := dbms_sql.execute(l_cursor);
343:
344: LOOP

Line 342: l_rows := dbms_sql.execute(l_cursor);

338: dbms_sql.define_column (l_cursor, 32,asg_rec.ATTRIBUTE14,150);
339: dbms_sql.define_column (l_cursor, 33,asg_rec.ATTRIBUTE15,150);
340: dbms_sql.define_column (l_cursor, 34,asg_rec.ORG_ID);
341:
342: l_rows := dbms_sql.execute(l_cursor);
343:
344: LOOP
345:
346: l_count := dbms_sql.fetch_rows( l_cursor );

Line 346: l_count := dbms_sql.fetch_rows( l_cursor );

342: l_rows := dbms_sql.execute(l_cursor);
343:
344: LOOP
345:
346: l_count := dbms_sql.fetch_rows( l_cursor );
347:
348: EXIT WHEN l_count <> 1;
349:
350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);

Line 350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);

346: l_count := dbms_sql.fetch_rows( l_cursor );
347:
348: EXIT WHEN l_count <> 1;
349:
350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);

Line 351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);

347:
348: EXIT WHEN l_count <> 1;
349:
350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);

Line 352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);

348: EXIT WHEN l_count <> 1;
349:
350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);

Line 353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);

349:
350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);

Line 354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);

350: dbms_sql.column_value (l_cursor, 1,asg_rec.EMP_SPACE_ASSIGN_ID);
351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);

Line 355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);

351: dbms_sql.column_value (l_cursor, 2,asg_rec.LOCATION_ID);
352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);

Line 356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);

352: dbms_sql.column_value (l_cursor, 3,asg_rec.PERSON_ID);
353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);

Line 357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);

353: dbms_sql.column_value (l_cursor, 4,asg_rec.PROJECT_ID);
354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);

Line 358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);

354: dbms_sql.column_value (l_cursor, 5,asg_rec.TASK_ID);
355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);

Line 359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);

355: dbms_sql.column_value (l_cursor, 6,asg_rec.EMP_ASSIGN_START_DATE);
356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);

Line 360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);

356: dbms_sql.column_value (l_cursor, 7,asg_rec.EMP_ASSIGN_END_DATE);
357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);

Line 361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);

357: dbms_sql.column_value (l_cursor, 8,asg_rec.COST_CENTER_CODE);
358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);

Line 362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);

358: dbms_sql.column_value (l_cursor, 9,asg_rec.ALLOCATED_AREA_PCT);
359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);

Line 363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);

359: dbms_sql.column_value (l_cursor, 10,asg_rec.ALLOCATED_AREA);
360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);

Line 364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);

360: dbms_sql.column_value (l_cursor, 11,asg_rec.UTILIZED_AREA);
361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);

Line 365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);

361: dbms_sql.column_value (l_cursor, 12,asg_rec.EMP_SPACE_COMMENTS);
362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);

Line 366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);

362: dbms_sql.column_value (l_cursor, 13,asg_rec.LAST_UPDATE_DATE);
363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);

Line 367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);

363: dbms_sql.column_value (l_cursor, 14,asg_rec.LAST_UPDATED_BY);
364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);

Line 368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);

364: dbms_sql.column_value (l_cursor, 15,asg_rec.CREATION_DATE);
365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);

Line 369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);

365: dbms_sql.column_value (l_cursor, 16,asg_rec.CREATED_BY);
366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);

Line 370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);

366: dbms_sql.column_value (l_cursor, 17,asg_rec.LAST_UPDATE_LOGIN);
367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);

Line 371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);

367: dbms_sql.column_value (l_cursor, 18,asg_rec.ATTRIBUTE_CATEGORY);
368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);

Line 372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);

368: dbms_sql.column_value (l_cursor, 19,asg_rec.ATTRIBUTE1);
369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);

Line 373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);

369: dbms_sql.column_value (l_cursor, 20,asg_rec.ATTRIBUTE2);
370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);

Line 374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);

370: dbms_sql.column_value (l_cursor, 21,asg_rec.ATTRIBUTE3);
371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);

Line 375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);

371: dbms_sql.column_value (l_cursor, 22,asg_rec.ATTRIBUTE4);
372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);

Line 376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);

372: dbms_sql.column_value (l_cursor, 23,asg_rec.ATTRIBUTE5);
373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);

Line 377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);

373: dbms_sql.column_value (l_cursor, 24,asg_rec.ATTRIBUTE6);
374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);

Line 378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);

374: dbms_sql.column_value (l_cursor, 25,asg_rec.ATTRIBUTE7);
375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);

Line 379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);

375: dbms_sql.column_value (l_cursor, 26,asg_rec.ATTRIBUTE8);
376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);

Line 380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);

376: dbms_sql.column_value (l_cursor, 27,asg_rec.ATTRIBUTE9);
377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';

Line 381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);

377: dbms_sql.column_value (l_cursor, 28,asg_rec.ATTRIBUTE10);
378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';
385:

Line 382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);

378: dbms_sql.column_value (l_cursor, 29,asg_rec.ATTRIBUTE11);
379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';
385:
386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;

Line 383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);

379: dbms_sql.column_value (l_cursor, 30,asg_rec.ATTRIBUTE12);
380: dbms_sql.column_value (l_cursor, 31,asg_rec.ATTRIBUTE13);
381: dbms_sql.column_value (l_cursor, 32,asg_rec.ATTRIBUTE14);
382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';
385:
386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;
387:

Line 728: | using dbms_sql.

724: | MODIFICATION HISTORY
725: |
726: | 13-NOV-03 Vikas Mehta Created
727: | 26-OCT-05 Hareesha o ATG mandated changes for SQL literals
728: | using dbms_sql.
729: | 22-NOV-05 Hareesha o Replaced _all with secured synonyms/
730: | base views.
731: | 04-APR-06 Hareesha o Bug 5119241 Use SQL literal for l_column_name
732: | instead of bind variable since usage of

Line 791: l_cursor := dbms_sql.open_cursor;

787: END LOOP;
788:
789: IF l_column_name IS NOT NULL THEN
790:
791: l_cursor := dbms_sql.open_cursor;
792:
793: l_statement :=
794: ' SELECT '|| l_column_name ||
795: ' FROM gl_code_combinations

Line 798: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

794: ' SELECT '|| l_column_name ||
795: ' FROM gl_code_combinations
796: WHERE code_combination_id = :x_code_comb_id ';
797:
798: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
799:
800: /* uncomment for debugging purposes */
801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);
802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);

Line 805: dbms_sql.bind_variable

801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);
802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);
803: pnp_debug_pkg.log(' l_column_name:'||l_column_name);*/
804:
805: dbms_sql.bind_variable
806: (l_cursor,'x_code_comb_id',l_code_comb_id );
807:
808: dbms_sql.define_column (l_cursor, 1,p_cost_center,30);
809:

Line 808: dbms_sql.define_column (l_cursor, 1,p_cost_center,30);

804:
805: dbms_sql.bind_variable
806: (l_cursor,'x_code_comb_id',l_code_comb_id );
807:
808: dbms_sql.define_column (l_cursor, 1,p_cost_center,30);
809:
810: l_rows := dbms_sql.execute(l_cursor);
811:
812: LOOP

Line 810: l_rows := dbms_sql.execute(l_cursor);

806: (l_cursor,'x_code_comb_id',l_code_comb_id );
807:
808: dbms_sql.define_column (l_cursor, 1,p_cost_center,30);
809:
810: l_rows := dbms_sql.execute(l_cursor);
811:
812: LOOP
813:
814: l_count := dbms_sql.fetch_rows( l_cursor );

Line 814: l_count := dbms_sql.fetch_rows( l_cursor );

810: l_rows := dbms_sql.execute(l_cursor);
811:
812: LOOP
813:
814: l_count := dbms_sql.fetch_rows( l_cursor );
815: EXIT WHEN l_count <> 1;
816: dbms_sql.column_value (l_cursor, 1,p_cost_center);
817:
818: END LOOP;

Line 816: dbms_sql.column_value (l_cursor, 1,p_cost_center);

812: LOOP
813:
814: l_count := dbms_sql.fetch_rows( l_cursor );
815: EXIT WHEN l_count <> 1;
816: dbms_sql.column_value (l_cursor, 1,p_cost_center);
817:
818: END LOOP;
819:
820: IF dbms_sql.is_open (l_cursor) THEN

Line 820: IF dbms_sql.is_open (l_cursor) THEN

816: dbms_sql.column_value (l_cursor, 1,p_cost_center);
817:
818: END LOOP;
819:
820: IF dbms_sql.is_open (l_cursor) THEN
821: dbms_sql.close_cursor (l_cursor);
822: END IF;
823: END IF;
824:

Line 821: dbms_sql.close_cursor (l_cursor);

817:
818: END LOOP;
819:
820: IF dbms_sql.is_open (l_cursor) THEN
821: dbms_sql.close_cursor (l_cursor);
822: END IF;
823: END IF;
824:
825: