632:
633: TYPE c_batch_attachment IS REF CURSOR;
634: c_batch_attm c_batch_attachment;
635:
636: l_batch_ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
637: l_batch_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE;
638:
639: -- Bug 9756187 end
640:
633: TYPE c_batch_attachment IS REF CURSOR;
634: c_batch_attm c_batch_attachment;
635:
636: l_batch_ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE;
637: l_batch_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE;
638:
639: -- Bug 9756187 end
640:
641: icx_language VARCHAR2(100);
641: icx_language VARCHAR2(100);
642:
643: TYPE c_trx_attachment_rec_type IS RECORD
644: (ROWID VARCHAR2(4000),
645: ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
642:
643: TYPE c_trx_attachment_rec_type IS RECORD
644: (ROWID VARCHAR2(4000),
645: ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
643: TYPE c_trx_attachment_rec_type IS RECORD
644: (ROWID VARCHAR2(4000),
645: ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
644: (ROWID VARCHAR2(4000),
645: ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
645: ATTACHED_DOCUMENT_ID FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
646: DOCUMENT_ID FND_ATTACHED_DOCUMENTS.DOCUMENT_ID%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
647: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
648: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
649: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
650: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
651: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
652: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
653: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
654: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
655: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
656: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
657: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
658: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
659: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
660: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
661: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
662: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
663: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
664: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
665: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
666: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
667: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
675: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
668: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
675: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
676: -------------------------------------
669: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
675: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
676: -------------------------------------
677: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
670: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
675: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
676: -------------------------------------
677: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
678: CATEGORY_ID FND_DOCUMENTS.CATEGORY_ID%TYPE,
671: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
672: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
673: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
674: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
675: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
676: -------------------------------------
677: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
678: CATEGORY_ID FND_DOCUMENTS.CATEGORY_ID%TYPE,
679: SECURITY_TYPE FND_DOCUMENTS.SECURITY_TYPE%TYPE,
712: -- Bug 9756187 Start
713:
714: TYPE c_batch_attachment_rec_type IS RECORD
715: (ROWID VARCHAR2(4000),
716: creation_date FND_ATTACHED_DOCUMENTS.creation_date%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
713:
714: TYPE c_batch_attachment_rec_type IS RECORD
715: (ROWID VARCHAR2(4000),
716: creation_date FND_ATTACHED_DOCUMENTS.creation_date%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
714: TYPE c_batch_attachment_rec_type IS RECORD
715: (ROWID VARCHAR2(4000),
716: creation_date FND_ATTACHED_DOCUMENTS.creation_date%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
715: (ROWID VARCHAR2(4000),
716: creation_date FND_ATTACHED_DOCUMENTS.creation_date%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
716: creation_date FND_ATTACHED_DOCUMENTS.creation_date%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
717: created_by FND_ATTACHED_DOCUMENTS.created_by%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
718: SEQ_NUM FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
719: ENTITY_NAME FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
720: COLUMN1 FND_ATTACHED_DOCUMENTS.COLUMN1%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
721: PK1_VALUE FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
722: PK2_VALUE FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
723: PK3_VALUE FND_ATTACHED_DOCUMENTS.PK3_VALUE%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
724: PK4_VALUE FND_ATTACHED_DOCUMENTS.PK4_VALUE%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
725: PK5_VALUE FND_ATTACHED_DOCUMENTS.PK5_VALUE%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
726: AUTOMATICALLY_ADDED_FLAG FND_ATTACHED_DOCUMENTS.AUTOMATICALLY_ADDED_FLAG%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
727: REQUEST_ID FND_ATTACHED_DOCUMENTS.REQUEST_ID%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
728: PROGRAM_APPLICATION_ID FND_ATTACHED_DOCUMENTS.PROGRAM_APPLICATION_ID%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
729: PROGRAM_ID FND_ATTACHED_DOCUMENTS.PROGRAM_ID%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
730: PROGRAM_UPDATE_DATE FND_ATTACHED_DOCUMENTS.PROGRAM_UPDATE_DATE%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
731: ATTRIBUTE_CATEGORY FND_ATTACHED_DOCUMENTS.ATTRIBUTE_CATEGORY%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
732: ATTRIBUTE1 FND_ATTACHED_DOCUMENTS.ATTRIBUTE1%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
733: ATTRIBUTE2 FND_ATTACHED_DOCUMENTS.ATTRIBUTE2%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
734: ATTRIBUTE3 FND_ATTACHED_DOCUMENTS.ATTRIBUTE3%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
735: ATTRIBUTE4 FND_ATTACHED_DOCUMENTS.ATTRIBUTE4%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
736: ATTRIBUTE5 FND_ATTACHED_DOCUMENTS.ATTRIBUTE5%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
737: ATTRIBUTE6 FND_ATTACHED_DOCUMENTS.ATTRIBUTE6%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
738: ATTRIBUTE7 FND_ATTACHED_DOCUMENTS.ATTRIBUTE7%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
746: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
739: ATTRIBUTE8 FND_ATTACHED_DOCUMENTS.ATTRIBUTE8%TYPE,
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
746: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
747: -------------------------------------
740: ATTRIBUTE9 FND_ATTACHED_DOCUMENTS.ATTRIBUTE9%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
746: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
747: -------------------------------------
748: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
741: ATTRIBUTE10 FND_ATTACHED_DOCUMENTS.ATTRIBUTE10%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
746: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
747: -------------------------------------
748: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
749: CATEGORY_ID FND_DOCUMENTS.CATEGORY_ID%TYPE,
742: ATTRIBUTE11 FND_ATTACHED_DOCUMENTS.ATTRIBUTE11%TYPE,
743: ATTRIBUTE12 FND_ATTACHED_DOCUMENTS.ATTRIBUTE12%TYPE,
744: ATTRIBUTE13 FND_ATTACHED_DOCUMENTS.ATTRIBUTE13%TYPE,
745: ATTRIBUTE14 FND_ATTACHED_DOCUMENTS.ATTRIBUTE14%TYPE,
746: ATTRIBUTE15 FND_ATTACHED_DOCUMENTS.ATTRIBUTE15%TYPE,
747: -------------------------------------
748: DATATYPE_ID FND_DOCUMENTS.DATATYPE_ID%TYPE,
749: CATEGORY_ID FND_DOCUMENTS.CATEGORY_ID%TYPE,
750: SECURITY_TYPE FND_DOCUMENTS.SECURITY_TYPE%TYPE,
1161: docs.URL,
1162: tl.TITLE
1163:
1164: from fnd_documents docs,
1165: FND_ATTACHED_DOCUMENTS atth,
1166: fnd_documents_tl tl
1167:
1168: where entity_name = ''FUN_TRX_HEADERS''
1169: and tl.LANGUAGE=''' || icx_language || '''
1176: LOOP
1177: FETCH c_trx_attm INTO l_attchmt_rec_type;
1178: EXIT WHEN c_trx_attm%NOTFOUND;
1179:
1180: fnd_attached_documents_pkg.Update_Row(
1181: X_Rowid => l_attchmt_rec_type.ROWID,
1182: X_attached_document_id => l_attchmt_rec_type.ATTACHED_DOCUMENT_ID,
1183: X_document_id => l_attchmt_rec_type.DOCUMENT_ID,
1184: X_last_update_date => sysdate,
1433: docs.URL,
1434: tl.TITLE
1435:
1436: from fnd_documents docs,
1437: FND_ATTACHED_DOCUMENTS atth,
1438: fnd_documents_tl tl
1439:
1440: where entity_name = ''FUN_TRX_BATCHES''
1441: and tl.LANGUAGE=''' || icx_language || '''
1448: LOOP
1449: FETCH c_batch_attm INTO l_batch_attchmt_rec_type;
1450: EXIT WHEN c_batch_attm%NOTFOUND;
1451:
1452: select FND_ATTACHED_DOCUMENTS_S.nextval into l_batch_ATTACHED_DOCUMENT_ID from dual;
1453: l_batch_DOCUMENT_ID := NULL;
1454:
1455: fnd_attached_documents_pkg.Insert_Row(
1456: X_Rowid => l_batch_attchmt_rec_type.ROWID,
1451:
1452: select FND_ATTACHED_DOCUMENTS_S.nextval into l_batch_ATTACHED_DOCUMENT_ID from dual;
1453: l_batch_DOCUMENT_ID := NULL;
1454:
1455: fnd_attached_documents_pkg.Insert_Row(
1456: X_Rowid => l_batch_attchmt_rec_type.ROWID,
1457: X_attached_document_id => l_batch_ATTACHED_DOCUMENT_ID,
1458: X_document_id => l_batch_DOCUMENT_ID,
1459: X_creation_date => l_batch_attchmt_rec_type.creation_date,