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

Line 462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);

458: ( p_get_ou_cursor_id IN NUMBER
459: ) IS
460: l_ou_rec csi_datastructures_pub.org_units_header_rec;
461: BEGIN
462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);

Line 463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);

459: ) IS
460: l_ou_rec csi_datastructures_pub.org_units_header_rec;
461: BEGIN
462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);

Line 464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);

460: l_ou_rec csi_datastructures_pub.org_units_header_rec;
461: BEGIN
462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);

Line 465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);

461: BEGIN
462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);

Line 466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);

462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);

Line 467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);

463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);

Line 468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);

464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);
465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);

Line 469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);

465: dbms_sql.define_column(p_get_ou_cursor_id, 4, l_ou_rec.relationship_type_code,30);
466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);

Line 470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);

466: dbms_sql.define_column(p_get_ou_cursor_id, 5, l_ou_rec.active_start_date);
467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);

Line 471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);

467: dbms_sql.define_column(p_get_ou_cursor_id, 6, l_ou_rec.active_end_date);
468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);

Line 472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);

468: dbms_sql.define_column(p_get_ou_cursor_id, 7, l_ou_rec.context,30);
469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);

Line 473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);

469: dbms_sql.define_column(p_get_ou_cursor_id, 8, l_ou_rec.attribute1,150);
470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);

Line 474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);

470: dbms_sql.define_column(p_get_ou_cursor_id, 9, l_ou_rec.attribute2,150);
471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);

Line 475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);

471: dbms_sql.define_column(p_get_ou_cursor_id, 10, l_ou_rec.attribute3,150);
472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);

Line 476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);

472: dbms_sql.define_column(p_get_ou_cursor_id, 11, l_ou_rec.attribute4,150);
473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);

Line 477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);

473: dbms_sql.define_column(p_get_ou_cursor_id, 12, l_ou_rec.attribute5,150);
474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);

Line 478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);

474: dbms_sql.define_column(p_get_ou_cursor_id, 13, l_ou_rec.attribute6,150);
475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);

Line 479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);

475: dbms_sql.define_column(p_get_ou_cursor_id, 14, l_ou_rec.attribute7,150);
476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);

Line 480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);

476: dbms_sql.define_column(p_get_ou_cursor_id, 15, l_ou_rec.attribute8,150);
477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);
484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);

Line 481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);

477: dbms_sql.define_column(p_get_ou_cursor_id, 16, l_ou_rec.attribute9,150);
478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);
484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);
485: END Define_ou_Columns;

Line 482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);

478: dbms_sql.define_column(p_get_ou_cursor_id, 17, l_ou_rec.attribute10,150);
479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);
484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);
485: END Define_ou_Columns;
486:

Line 483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);

479: dbms_sql.define_column(p_get_ou_cursor_id, 18, l_ou_rec.attribute11,150);
480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);
484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);
485: END Define_ou_Columns;
486:
487:

Line 484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);

480: dbms_sql.define_column(p_get_ou_cursor_id, 19, l_ou_rec.attribute12,150);
481: dbms_sql.define_column(p_get_ou_cursor_id, 20, l_ou_rec.attribute13,150);
482: dbms_sql.define_column(p_get_ou_cursor_id, 21, l_ou_rec.attribute14,150);
483: dbms_sql.define_column(p_get_ou_cursor_id, 22, l_ou_rec.attribute15,150);
484: dbms_sql.define_column(p_get_ou_cursor_id, 28, l_ou_rec.object_version_number);
485: END Define_ou_Columns;
486:
487:
488: /*----------------------------------------------------------*/

Line 500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);

496: x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec
497: ) IS
498:
499: BEGIN
500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);
501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);

Line 501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);

497: ) IS
498:
499: BEGIN
500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);
501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);

Line 502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);

498:
499: BEGIN
500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);
501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);

Line 503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);

499: BEGIN
500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);
501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);

Line 504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);

500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);
501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);

Line 505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);

501: dbms_sql.column_value(p_get_ou_cursor_id, 2, x_ou_rec.instance_id);
502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);

Line 506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);

502: dbms_sql.column_value(p_get_ou_cursor_id, 3, x_ou_rec.operating_unit_id);
503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);

Line 507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);

503: dbms_sql.column_value(p_get_ou_cursor_id, 4, x_ou_rec.relationship_type_code);
504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);

Line 508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);

504: dbms_sql.column_value(p_get_ou_cursor_id, 5, x_ou_rec.active_start_date);
505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);

Line 509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);

505: dbms_sql.column_value(p_get_ou_cursor_id, 6, x_ou_rec.active_end_date);
506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);

Line 510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);

506: dbms_sql.column_value(p_get_ou_cursor_id, 7, x_ou_rec.context);
507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);

Line 511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);

507: dbms_sql.column_value(p_get_ou_cursor_id, 8, x_ou_rec.attribute1);
508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);

Line 512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);

508: dbms_sql.column_value(p_get_ou_cursor_id, 9, x_ou_rec.attribute2);
509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);

Line 513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);

509: dbms_sql.column_value(p_get_ou_cursor_id, 10, x_ou_rec.attribute3);
510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);

Line 514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);

510: dbms_sql.column_value(p_get_ou_cursor_id, 11, x_ou_rec.attribute4);
511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);

Line 515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);

511: dbms_sql.column_value(p_get_ou_cursor_id, 12, x_ou_rec.attribute5);
512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);

Line 516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);

512: dbms_sql.column_value(p_get_ou_cursor_id, 13, x_ou_rec.attribute6);
513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);

Line 517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);

513: dbms_sql.column_value(p_get_ou_cursor_id, 14, x_ou_rec.attribute7);
514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);

Line 518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);

514: dbms_sql.column_value(p_get_ou_cursor_id, 15, x_ou_rec.attribute8);
515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);
522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);

Line 519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);

515: dbms_sql.column_value(p_get_ou_cursor_id, 16, x_ou_rec.attribute9);
516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);
522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);
523:

Line 520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);

516: dbms_sql.column_value(p_get_ou_cursor_id, 17, x_ou_rec.attribute10);
517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);
522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);
523:
524: END Get_ou_Column_Values;

Line 521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);

517: dbms_sql.column_value(p_get_ou_cursor_id, 18, x_ou_rec.attribute11);
518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);
522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);
523:
524: END Get_ou_Column_Values;
525:

Line 522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);

518: dbms_sql.column_value(p_get_ou_cursor_id, 19, x_ou_rec.attribute12);
519: dbms_sql.column_value(p_get_ou_cursor_id, 20, x_ou_rec.attribute13);
520: dbms_sql.column_value(p_get_ou_cursor_id, 21, x_ou_rec.attribute14);
521: dbms_sql.column_value(p_get_ou_cursor_id, 22, x_ou_rec.attribute15);
522: dbms_sql.column_value(p_get_ou_cursor_id, 28, x_ou_rec.object_version_number);
523:
524: END Get_ou_Column_Values;
525:
526:

Line 535: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':instance_ou_id', p_ou_query_rec.instance_ou_id);

531: IS
532: BEGIN
533: IF( (p_ou_query_rec.instance_ou_id IS NOT NULL)
534: AND (p_ou_query_rec.instance_ou_id <> FND_API.G_MISS_NUM)) THEN
535: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':instance_ou_id', p_ou_query_rec.instance_ou_id);
536: END IF;
537:
538: IF( (p_ou_query_rec.instance_id IS NOT NULL)
539: AND (p_ou_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN

Line 540: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':instance_id', p_ou_query_rec.instance_id);

536: END IF;
537:
538: IF( (p_ou_query_rec.instance_id IS NOT NULL)
539: AND (p_ou_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
540: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':instance_id', p_ou_query_rec.instance_id);
541: END IF;
542:
543: IF( (p_ou_query_rec.operating_unit_id IS NOT NULL)
544: AND (p_ou_query_rec.operating_unit_id<> FND_API.G_MISS_NUM)) THEN

Line 545: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':operating_unit_id', p_ou_query_rec.operating_unit_id);

541: END IF;
542:
543: IF( (p_ou_query_rec.operating_unit_id IS NOT NULL)
544: AND (p_ou_query_rec.operating_unit_id<> FND_API.G_MISS_NUM)) THEN
545: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':operating_unit_id', p_ou_query_rec.operating_unit_id);
546: END IF;
547:
548: IF( (p_ou_query_rec.relationship_type_code IS NOT NULL)
549: AND (p_ou_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN

Line 550: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':relationship_type_code', p_ou_query_rec.relationship_type_code);

546: END IF;
547:
548: IF( (p_ou_query_rec.relationship_type_code IS NOT NULL)
549: AND (p_ou_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN
550: DBMS_SQL.BIND_VARIABLE(p_cur_get_ou, ':relationship_type_code', p_ou_query_rec.relationship_type_code);
551: END IF;
552:
553: END Bind_ou_variable;
554: