APPS.CSI_T_TXN_OUS_PVT dependencies on DBMS_SQL

Line 735: l_oa_cur_id := dbms_sql.open_cursor;

731: ' attribute11, attribute12, attribute13, attribute14, attribute15, object_version_number '||
732: 'from csi_t_org_assignments '||
733: 'where txn_line_detail_id = :line_dtl_id';
734:
735: l_oa_cur_id := dbms_sql.open_cursor;
736:
737: dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);
738:
739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);

Line 737: dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);

733: 'where txn_line_detail_id = :line_dtl_id';
734:
735: l_oa_cur_id := dbms_sql.open_cursor;
736:
737: dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);
738:
739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);
740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);

Line 739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);

735: l_oa_cur_id := dbms_sql.open_cursor;
736:
737: dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);
738:
739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);
740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);

Line 741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);

737: dbms_sql.parse(l_oa_cur_id, l_select_stmt , dbms_sql.native);
738:
739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);
740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);

Line 742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);

738:
739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);
740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);

Line 743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);

739: dbms_sql.bind_variable(l_oa_cur_id, 'line_dtl_id', p_line_dtl_id);
740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);

Line 744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);

740:
741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);

Line 745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);

741: dbms_sql.define_column(l_oa_cur_id,1,l_oa_rec.txn_operating_unit_id);
742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);

Line 746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);

742: dbms_sql.define_column(l_oa_cur_id,2,l_oa_rec.txn_line_detail_id);
743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);

Line 747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);

743: dbms_sql.define_column(l_oa_cur_id,3,l_oa_rec.instance_ou_id);
744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);

Line 748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);

744: dbms_sql.define_column(l_oa_cur_id,4,l_oa_rec.operating_unit_id);
745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);

Line 749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);

745: dbms_sql.define_column(l_oa_cur_id,5,l_oa_rec.relationship_type_code,30);
746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);

Line 750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);

746: dbms_sql.define_column(l_oa_cur_id,6,l_oa_rec.active_start_date);
747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);

Line 751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);

747: dbms_sql.define_column(l_oa_cur_id,7,l_oa_rec.active_end_date);
748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);

Line 752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);

748: dbms_sql.define_column(l_oa_cur_id,8,l_oa_rec.preserve_detail_flag,1);
749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);

Line 753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);

749: dbms_sql.define_column(l_oa_cur_id,9,l_oa_rec.context,30);
750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);

Line 754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);

750: dbms_sql.define_column(l_oa_cur_id,10,l_oa_rec.attribute1,150);
751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);

Line 755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);

751: dbms_sql.define_column(l_oa_cur_id,11,l_oa_rec.attribute2,150);
752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);

Line 756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);

752: dbms_sql.define_column(l_oa_cur_id,12,l_oa_rec.attribute3,150);
753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);

Line 757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);

753: dbms_sql.define_column(l_oa_cur_id,13,l_oa_rec.attribute4,150);
754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);

Line 758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);

754: dbms_sql.define_column(l_oa_cur_id,14,l_oa_rec.attribute5,150);
755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);

Line 759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);

755: dbms_sql.define_column(l_oa_cur_id,15,l_oa_rec.attribute6,150);
756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);

Line 760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);

756: dbms_sql.define_column(l_oa_cur_id,16,l_oa_rec.attribute7,150);
757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);

Line 761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);

757: dbms_sql.define_column(l_oa_cur_id,17,l_oa_rec.attribute8,150);
758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);

Line 762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);

758: dbms_sql.define_column(l_oa_cur_id,18,l_oa_rec.attribute9,150);
759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);
766: l_ind := 0;

Line 763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);

759: dbms_sql.define_column(l_oa_cur_id,19,l_oa_rec.attribute10,150);
760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);
766: l_ind := 0;
767:

Line 764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);

760: dbms_sql.define_column(l_oa_cur_id,20,l_oa_rec.attribute11,150);
761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);
766: l_ind := 0;
767:
768: l_processed_rows := dbms_sql.execute(l_oa_cur_id);

Line 765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);

761: dbms_sql.define_column(l_oa_cur_id,21,l_oa_rec.attribute12,150);
762: dbms_sql.define_column(l_oa_cur_id,22,l_oa_rec.attribute13,150);
763: dbms_sql.define_column(l_oa_cur_id,23,l_oa_rec.attribute14,150);
764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);
766: l_ind := 0;
767:
768: l_processed_rows := dbms_sql.execute(l_oa_cur_id);
769: LOOP

Line 768: l_processed_rows := dbms_sql.execute(l_oa_cur_id);

764: dbms_sql.define_column(l_oa_cur_id,24,l_oa_rec.attribute15,150);
765: dbms_sql.define_column(l_oa_cur_id,25,l_oa_rec.object_version_number);
766: l_ind := 0;
767:
768: l_processed_rows := dbms_sql.execute(l_oa_cur_id);
769: LOOP
770: exit when dbms_sql.fetch_rows(l_oa_cur_id) = 0;
771:
772: l_ind := l_ind + 1;

Line 770: exit when dbms_sql.fetch_rows(l_oa_cur_id) = 0;

766: l_ind := 0;
767:
768: l_processed_rows := dbms_sql.execute(l_oa_cur_id);
769: LOOP
770: exit when dbms_sql.fetch_rows(l_oa_cur_id) = 0;
771:
772: l_ind := l_ind + 1;
773:
774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);

Line 774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);

770: exit when dbms_sql.fetch_rows(l_oa_cur_id) = 0;
771:
772: l_ind := l_ind + 1;
773:
774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);
775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);

Line 775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);

771:
772: l_ind := l_ind + 1;
773:
774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);
775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);

Line 776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);

772: l_ind := l_ind + 1;
773:
774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);
775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);

Line 777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);

773:
774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);
775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);

Line 778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);

774: dbms_sql.column_value(l_oa_cur_id,1,x_org_assgn_tbl(l_ind).txn_operating_unit_id);
775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);

Line 779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);

775: dbms_sql.column_value(l_oa_cur_id,2,x_org_assgn_tbl(l_ind).txn_line_detail_id);
776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);

Line 780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);

776: dbms_sql.column_value(l_oa_cur_id,3,x_org_assgn_tbl(l_ind).instance_ou_id);
777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);

Line 781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);

777: dbms_sql.column_value(l_oa_cur_id,4,x_org_assgn_tbl(l_ind).operating_unit_id);
778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);

Line 782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);

778: dbms_sql.column_value(l_oa_cur_id,5,x_org_assgn_tbl(l_ind).relationship_type_code);
779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);

Line 783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);

779: dbms_sql.column_value(l_oa_cur_id,6,x_org_assgn_tbl(l_ind).active_start_date);
780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);

Line 784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);

780: dbms_sql.column_value(l_oa_cur_id,7,x_org_assgn_tbl(l_ind).active_end_date);
781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);

Line 785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);

781: dbms_sql.column_value(l_oa_cur_id,8,x_org_assgn_tbl(l_ind).preserve_detail_flag);
782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);

Line 786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);

782: dbms_sql.column_value(l_oa_cur_id,9,x_org_assgn_tbl(l_ind).context);
783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);

Line 787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);

783: dbms_sql.column_value(l_oa_cur_id,10,x_org_assgn_tbl(l_ind).attribute1);
784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);

Line 788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);

784: dbms_sql.column_value(l_oa_cur_id,11,x_org_assgn_tbl(l_ind).attribute2);
785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);

Line 789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);

785: dbms_sql.column_value(l_oa_cur_id,12,x_org_assgn_tbl(l_ind).attribute3);
786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);

Line 790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);

786: dbms_sql.column_value(l_oa_cur_id,13,x_org_assgn_tbl(l_ind).attribute4);
787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);

Line 791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);

787: dbms_sql.column_value(l_oa_cur_id,14,x_org_assgn_tbl(l_ind).attribute5);
788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);

Line 792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);

788: dbms_sql.column_value(l_oa_cur_id,15,x_org_assgn_tbl(l_ind).attribute6);
789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);

Line 793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);

789: dbms_sql.column_value(l_oa_cur_id,16,x_org_assgn_tbl(l_ind).attribute7);
790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);

Line 794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);

790: dbms_sql.column_value(l_oa_cur_id,17,x_org_assgn_tbl(l_ind).attribute8);
791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);
798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);

Line 795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);

791: dbms_sql.column_value(l_oa_cur_id,18,x_org_assgn_tbl(l_ind).attribute9);
792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);
798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);
799:

Line 796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);

792: dbms_sql.column_value(l_oa_cur_id,19,x_org_assgn_tbl(l_ind).attribute10);
793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);
798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);
799:
800: END LOOP;

Line 797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);

793: dbms_sql.column_value(l_oa_cur_id,20,x_org_assgn_tbl(l_ind).attribute11);
794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);
798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);
799:
800: END LOOP;
801:

Line 798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);

794: dbms_sql.column_value(l_oa_cur_id,21,x_org_assgn_tbl(l_ind).attribute12);
795: dbms_sql.column_value(l_oa_cur_id,22,x_org_assgn_tbl(l_ind).attribute13);
796: dbms_sql.column_value(l_oa_cur_id,23,x_org_assgn_tbl(l_ind).attribute14);
797: dbms_sql.column_value(l_oa_cur_id,24,x_org_assgn_tbl(l_ind).attribute15);
798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);
799:
800: END LOOP;
801:
802: dbms_sql.close_cursor(l_oa_cur_id);

Line 802: dbms_sql.close_cursor(l_oa_cur_id);

798: dbms_sql.column_value(l_oa_cur_id,25,x_org_assgn_tbl(l_ind).object_version_number);
799:
800: END LOOP;
801:
802: dbms_sql.close_cursor(l_oa_cur_id);
803:
804: EXCEPTION
805: WHEN others THEN
806:

Line 807: IF dbms_sql.is_open(l_oa_cur_id) THEN

803:
804: EXCEPTION
805: WHEN others THEN
806:
807: IF dbms_sql.is_open(l_oa_cur_id) THEN
808: dbms_sql.close_cursor(l_oa_cur_id);
809: END IF;
810: END get_org_assgn_dtls;
811:

Line 808: dbms_sql.close_cursor(l_oa_cur_id);

804: EXCEPTION
805: WHEN others THEN
806:
807: IF dbms_sql.is_open(l_oa_cur_id) THEN
808: dbms_sql.close_cursor(l_oa_cur_id);
809: END IF;
810: END get_org_assgn_dtls;
811:
812: PROCEDURE get_all_org_assgn_dtls(