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.JTF_TASK_TEMP_GROUP_PVT dependencies on DBMS_SQL

Line 458: v_cursor_id := DBMS_SQL.open_cursor;

454: THEN
455: v_tbl.DELETE;
456: create_sql_statement;
457: dump_long_line ('v_sel:', v_select);
458: v_cursor_id := DBMS_SQL.open_cursor;
459: DBMS_SQL.parse (v_cursor_id, v_select, DBMS_SQL.v7);
460:
461: -- bind variables only if they added to the sql statement
462: IF (p_task_template_group_id IS NOT NULL)

Line 459: DBMS_SQL.parse (v_cursor_id, v_select, DBMS_SQL.v7);

455: v_tbl.DELETE;
456: create_sql_statement;
457: dump_long_line ('v_sel:', v_select);
458: v_cursor_id := DBMS_SQL.open_cursor;
459: DBMS_SQL.parse (v_cursor_id, v_select, DBMS_SQL.v7);
460:
461: -- bind variables only if they added to the sql statement
462: IF (p_task_template_group_id IS NOT NULL)
463: THEN

Line 464: DBMS_SQL.bind_variable (

460:
461: -- bind variables only if they added to the sql statement
462: IF (p_task_template_group_id IS NOT NULL)
463: THEN
464: DBMS_SQL.bind_variable (
465: v_cursor_id,
466: ':b1',
467: p_task_template_group_id
468: );

Line 473: DBMS_SQL.bind_variable (v_cursor_id, ':b2', p_template_group_name);

469: END IF;
470:
471: IF (p_template_group_name IS NOT NULL)
472: THEN
473: DBMS_SQL.bind_variable (v_cursor_id, ':b2', p_template_group_name);
474: END IF;
475:
476: IF (p_source_object_type_code IS NOT NULL)
477: THEN

Line 478: DBMS_SQL.bind_variable (

474: END IF;
475:
476: IF (p_source_object_type_code IS NOT NULL)
477: THEN
478: DBMS_SQL.bind_variable (
479: v_cursor_id,
480: ':b3',
481: p_source_object_type_code
482: );

Line 487: DBMS_SQL.bind_variable (v_cursor_id, ':b4', p_start_date_active);

483: END IF;
484:
485: IF (p_start_date_active IS NOT NULL)
486: THEN
487: DBMS_SQL.bind_variable (v_cursor_id, ':b4', p_start_date_active);
488: END IF;
489:
490: IF (p_end_date_active IS NOT NULL)
491: THEN

Line 492: DBMS_SQL.bind_variable (v_cursor_id, ':b5', p_end_date_active);

488: END IF;
489:
490: IF (p_end_date_active IS NOT NULL)
491: THEN
492: DBMS_SQL.bind_variable (v_cursor_id, ':b5', p_end_date_active);
493: END IF;
494:
495: IF (p_application_id IS NOT NULL)
496: THEN

Line 497: DBMS_SQL.bind_variable (v_cursor_id, ':b6', p_application_id);

493: END IF;
494:
495: IF (p_application_id IS NOT NULL)
496: THEN
497: DBMS_SQL.bind_variable (v_cursor_id, ':b6', p_application_id);
498: END IF;
499:
500: -- define the output columns
501: DBMS_SQL.define_column (

Line 501: DBMS_SQL.define_column (

497: DBMS_SQL.bind_variable (v_cursor_id, ':b6', p_application_id);
498: END IF;
499:
500: -- define the output columns
501: DBMS_SQL.define_column (
502: v_cursor_id,
503: 1,
504: v_type.task_template_group_id
505: );

Line 506: DBMS_SQL.define_column (

502: v_cursor_id,
503: 1,
504: v_type.task_template_group_id
505: );
506: DBMS_SQL.define_column (
507: v_cursor_id,
508: 2,
509: v_type.template_group_name,
510: 80

Line 512: DBMS_SQL.define_column (

508: 2,
509: v_type.template_group_name,
510: 80
511: );
512: DBMS_SQL.define_column (
513: v_cursor_id,
514: 3,
515: v_type.source_object_type_code,
516: 80

Line 518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);

514: 3,
515: v_type.source_object_type_code,
516: 80
517: );
518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);
519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);

Line 519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);

515: v_type.source_object_type_code,
516: 80
517: );
518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);
519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);

Line 520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);

516: 80
517: );
518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);
519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);

Line 521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);

517: );
518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);
519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);

Line 522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);

518: DBMS_SQL.define_column (v_cursor_id, 4, v_type.start_date_active);
519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);

Line 523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);

519: DBMS_SQL.define_column (v_cursor_id, 5, v_type.end_date_active);
520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);

Line 524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);

520: DBMS_SQL.define_column (v_cursor_id, 6, v_type.description, 4000);
521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);

Line 525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);

521: DBMS_SQL.define_column (v_cursor_id, 7, v_type.attribute1, 240);
522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);

Line 526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);

522: DBMS_SQL.define_column (v_cursor_id, 8, v_type.attribute2, 150);
523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);

Line 527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);

523: DBMS_SQL.define_column (v_cursor_id, 9, v_type.attribute3, 150);
524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);

Line 528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);

524: DBMS_SQL.define_column (v_cursor_id, 10, v_type.attribute4, 150);
525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);

Line 529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);

525: DBMS_SQL.define_column (v_cursor_id, 11, v_type.attribute5, 150);
526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);

Line 530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);

526: DBMS_SQL.define_column (v_cursor_id, 12, v_type.attribute6, 150);
527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);

Line 531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);

527: DBMS_SQL.define_column (v_cursor_id, 13, v_type.attribute7, 150);
528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);

Line 532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);

528: DBMS_SQL.define_column (v_cursor_id, 14, v_type.attribute8, 150);
529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);
536: DBMS_SQL.define_column (

Line 533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);

529: DBMS_SQL.define_column (v_cursor_id, 15, v_type.attribute9, 150);
530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);
536: DBMS_SQL.define_column (
537: v_cursor_id,

Line 534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);

530: DBMS_SQL.define_column (v_cursor_id, 16, v_type.attribute10, 150);
531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);
536: DBMS_SQL.define_column (
537: v_cursor_id,
538: 22,

Line 535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);

531: DBMS_SQL.define_column (v_cursor_id, 17, v_type.attribute11, 150);
532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);
536: DBMS_SQL.define_column (
537: v_cursor_id,
538: 22,
539: v_type.attribute_category,

Line 536: DBMS_SQL.define_column (

532: DBMS_SQL.define_column (v_cursor_id, 18, v_type.attribute12, 150);
533: DBMS_SQL.define_column (v_cursor_id, 19, v_type.attribute13, 150);
534: DBMS_SQL.define_column (v_cursor_id, 20, v_type.attribute14, 150);
535: DBMS_SQL.define_column (v_cursor_id, 21, v_type.attribute15, 150);
536: DBMS_SQL.define_column (
537: v_cursor_id,
538: 22,
539: v_type.attribute_category,
540: 30

Line 542: DBMS_SQL.define_column (

538: 22,
539: v_type.attribute_category,
540: 30
541: );
542: DBMS_SQL.define_column (
543: v_cursor_id,
544: 23,
545: v_type.object_version_number
546: );

Line 547: DBMS_SQL.define_column (v_cursor_id, 24, v_type.application_id);

543: v_cursor_id,
544: 23,
545: v_type.object_version_number
546: );
547: DBMS_SQL.define_column (v_cursor_id, 24, v_type.application_id);
548: v_dummy := DBMS_SQL.execute (v_cursor_id);
549: v_cnt := 0;
550:
551: LOOP

Line 548: v_dummy := DBMS_SQL.execute (v_cursor_id);

544: 23,
545: v_type.object_version_number
546: );
547: DBMS_SQL.define_column (v_cursor_id, 24, v_type.application_id);
548: v_dummy := DBMS_SQL.execute (v_cursor_id);
549: v_cnt := 0;
550:
551: LOOP
552: EXIT WHEN (DBMS_SQL.fetch_rows (v_cursor_id) = 0);

Line 552: EXIT WHEN (DBMS_SQL.fetch_rows (v_cursor_id) = 0);

548: v_dummy := DBMS_SQL.execute (v_cursor_id);
549: v_cnt := 0;
550:
551: LOOP
552: EXIT WHEN (DBMS_SQL.fetch_rows (v_cursor_id) = 0);
553: v_cnt := v_cnt + 1;
554: -- retrieve the rows from the buffer
555: DBMS_SQL.column_value (
556: v_cursor_id,

Line 555: DBMS_SQL.column_value (

551: LOOP
552: EXIT WHEN (DBMS_SQL.fetch_rows (v_cursor_id) = 0);
553: v_cnt := v_cnt + 1;
554: -- retrieve the rows from the buffer
555: DBMS_SQL.column_value (
556: v_cursor_id,
557: 1,
558: v_type.task_template_group_id
559: );

Line 560: DBMS_SQL.column_value (v_cursor_id, 2, v_type.template_group_name);

556: v_cursor_id,
557: 1,
558: v_type.task_template_group_id
559: );
560: DBMS_SQL.column_value (v_cursor_id, 2, v_type.template_group_name);
561: DBMS_SQL.column_value (
562: v_cursor_id,
563: 3,
564: v_type.source_object_type_code

Line 561: DBMS_SQL.column_value (

557: 1,
558: v_type.task_template_group_id
559: );
560: DBMS_SQL.column_value (v_cursor_id, 2, v_type.template_group_name);
561: DBMS_SQL.column_value (
562: v_cursor_id,
563: 3,
564: v_type.source_object_type_code
565: );

Line 566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);

562: v_cursor_id,
563: 3,
564: v_type.source_object_type_code
565: );
566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);
567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);

Line 567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);

563: 3,
564: v_type.source_object_type_code
565: );
566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);
567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);

Line 568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);

564: v_type.source_object_type_code
565: );
566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);
567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);

Line 569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);

565: );
566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);
567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);

Line 570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);

566: DBMS_SQL.column_value (v_cursor_id, 4, v_type.start_date_active);
567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);

Line 571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);

567: DBMS_SQL.column_value (v_cursor_id, 5, v_type.end_date_active);
568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);

Line 572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);

568: DBMS_SQL.column_value (v_cursor_id, 6, v_type.description);
569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);

Line 573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);

569: DBMS_SQL.column_value (v_cursor_id, 7, v_type.attribute1);
570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);

Line 574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);

570: DBMS_SQL.column_value (v_cursor_id, 8, v_type.attribute2);
571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);

Line 575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);

571: DBMS_SQL.column_value (v_cursor_id, 9, v_type.attribute3);
572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);

Line 576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);

572: DBMS_SQL.column_value (v_cursor_id, 10, v_type.attribute4);
573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);

Line 577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);

573: DBMS_SQL.column_value (v_cursor_id, 11, v_type.attribute5);
574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);

Line 578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);

574: DBMS_SQL.column_value (v_cursor_id, 12, v_type.attribute6);
575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);

Line 579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);

575: DBMS_SQL.column_value (v_cursor_id, 13, v_type.attribute7);
576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);

Line 580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);

576: DBMS_SQL.column_value (v_cursor_id, 14, v_type.attribute8);
577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);

Line 581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);

577: DBMS_SQL.column_value (v_cursor_id, 15, v_type.attribute9);
578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);
585: DBMS_SQL.column_value (

Line 582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);

578: DBMS_SQL.column_value (v_cursor_id, 16, v_type.attribute10);
579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);
585: DBMS_SQL.column_value (
586: v_cursor_id,

Line 583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);

579: DBMS_SQL.column_value (v_cursor_id, 17, v_type.attribute11);
580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);
585: DBMS_SQL.column_value (
586: v_cursor_id,
587: 23,

Line 584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);

580: DBMS_SQL.column_value (v_cursor_id, 18, v_type.attribute12);
581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);
585: DBMS_SQL.column_value (
586: v_cursor_id,
587: 23,
588: v_type.object_version_number

Line 585: DBMS_SQL.column_value (

581: DBMS_SQL.column_value (v_cursor_id, 19, v_type.attribute13);
582: DBMS_SQL.column_value (v_cursor_id, 20, v_type.attribute14);
583: DBMS_SQL.column_value (v_cursor_id, 21, v_type.attribute15);
584: DBMS_SQL.column_value (v_cursor_id, 22, v_type.attribute_category);
585: DBMS_SQL.column_value (
586: v_cursor_id,
587: 23,
588: v_type.object_version_number
589: );

Line 590: DBMS_SQL.column_value (v_cursor_id, 24, v_type.application_id);

586: v_cursor_id,
587: 23,
588: v_type.object_version_number
589: );
590: DBMS_SQL.column_value (v_cursor_id, 24, v_type.application_id);
591: -- 'v_type.task_template_group_id:'||
592: -- to_char(v_type.task_template_group_id));
593: v_tbl (v_cnt) := v_type;
594: END LOOP;

Line 596: DBMS_SQL.close_cursor (v_cursor_id);

592: -- to_char(v_type.task_template_group_id));
593: v_tbl (v_cnt) := v_type;
594: END LOOP;
595:
596: DBMS_SQL.close_cursor (v_cursor_id);
597: END IF; --p_query_or_next_code;
598:
599: -- copy records to be returned back
600: x_total_retrieved := v_tbl.COUNT;