346: -- Update record in backend
347: UPDATE ahl_mel_cdl_ata_sequences
348: SET OBJECT_VERSION_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = fnd_global.user_id,
351: LAST_UPDATE_LOGIN = fnd_global.login_id,
352: REPAIR_CATEGORY_ID = p_x_ata_sequences_tbl(l_rec_idx).repair_category_id,
353: INSTALLED_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).installed_number,
354: DISPATCH_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).dispatch_number,
347: UPDATE ahl_mel_cdl_ata_sequences
348: SET OBJECT_VERSION_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = fnd_global.user_id,
351: LAST_UPDATE_LOGIN = fnd_global.login_id,
352: REPAIR_CATEGORY_ID = p_x_ata_sequences_tbl(l_rec_idx).repair_category_id,
353: INSTALLED_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).installed_number,
354: DISPATCH_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).dispatch_number,
355: ATTRIBUTE_CATEGORY = p_x_ata_sequences_tbl(l_rec_idx).attribute_category,
399: x_return_status => l_return_status,
400: x_msg_count => l_msg_count,
401: x_msg_data => l_msg_data,
402: p_jtf_note_id => l_note_rec.jtf_note_id,
403: p_entered_by => fnd_global.user_id,
404: p_last_updated_by => fnd_global.user_id,
405: p_last_update_date => sysdate,
406: p_last_update_login => fnd_global.login_id,
407: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
400: x_msg_count => l_msg_count,
401: x_msg_data => l_msg_data,
402: p_jtf_note_id => l_note_rec.jtf_note_id,
403: p_entered_by => fnd_global.user_id,
404: p_last_updated_by => fnd_global.user_id,
405: p_last_update_date => sysdate,
406: p_last_update_login => fnd_global.login_id,
407: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
408: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
402: p_jtf_note_id => l_note_rec.jtf_note_id,
403: p_entered_by => fnd_global.user_id,
404: p_last_updated_by => fnd_global.user_id,
405: p_last_update_date => sysdate,
406: p_last_update_login => fnd_global.login_id,
407: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
408: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
409: p_append_flag => 'N',
410: p_note_status => l_note_rec.note_status,
457: p_source_object_code => 'AHL_MEL_CDL',
458: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
459: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
460: p_note_status => 'E',
461: p_entered_by => fnd_global.user_id,
462: p_entered_date => sysdate,
463: x_jtf_note_id => l_jtf_note_id,
464: p_last_updated_by => fnd_global.user_id,
465: p_last_update_date => sysdate,
460: p_note_status => 'E',
461: p_entered_by => fnd_global.user_id,
462: p_entered_date => sysdate,
463: x_jtf_note_id => l_jtf_note_id,
464: p_last_updated_by => fnd_global.user_id,
465: p_last_update_date => sysdate,
466: p_created_by => fnd_global.user_id,
467: p_creation_date => sysdate,
468: p_last_update_login => fnd_global.login_id,
462: p_entered_date => sysdate,
463: x_jtf_note_id => l_jtf_note_id,
464: p_last_updated_by => fnd_global.user_id,
465: p_last_update_date => sysdate,
466: p_created_by => fnd_global.user_id,
467: p_creation_date => sysdate,
468: p_last_update_login => fnd_global.login_id,
469: p_attribute1 => null,
470: p_attribute2 => null,
464: p_last_updated_by => fnd_global.user_id,
465: p_last_update_date => sysdate,
466: p_created_by => fnd_global.user_id,
467: p_creation_date => sysdate,
468: p_last_update_login => fnd_global.login_id,
469: p_attribute1 => null,
470: p_attribute2 => null,
471: p_attribute3 => null,
472: p_attribute4 => null,
647: (
648: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_ATA_SEQUENCE_ID,
649: p_x_ata_sequences_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
650: sysdate,
651: fnd_global.user_id,
652: sysdate,
653: fnd_global.user_id,
654: fnd_global.login_id,
655: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
649: p_x_ata_sequences_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
650: sysdate,
651: fnd_global.user_id,
652: sysdate,
653: fnd_global.user_id,
654: fnd_global.login_id,
655: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
656: p_x_ata_sequences_tbl(l_rec_idx).REPAIR_CATEGORY_ID,
657: p_x_ata_sequences_tbl(l_rec_idx).ATA_CODE,
650: sysdate,
651: fnd_global.user_id,
652: sysdate,
653: fnd_global.user_id,
654: fnd_global.login_id,
655: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
656: p_x_ata_sequences_tbl(l_rec_idx).REPAIR_CATEGORY_ID,
657: p_x_ata_sequences_tbl(l_rec_idx).ATA_CODE,
658: p_x_ata_sequences_tbl(l_rec_idx).INSTALLED_NUMBER,
706: p_source_object_code => 'AHL_MEL_CDL',
707: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
708: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
709: p_note_status => 'E',
710: p_entered_by => fnd_global.user_id,
711: p_entered_date => sysdate,
712: x_jtf_note_id => l_jtf_note_id,
713: p_last_updated_by => fnd_global.user_id,
714: p_last_update_date => sysdate,
709: p_note_status => 'E',
710: p_entered_by => fnd_global.user_id,
711: p_entered_date => sysdate,
712: x_jtf_note_id => l_jtf_note_id,
713: p_last_updated_by => fnd_global.user_id,
714: p_last_update_date => sysdate,
715: p_created_by => fnd_global.user_id,
716: p_creation_date => sysdate,
717: p_last_update_login => fnd_global.login_id,
711: p_entered_date => sysdate,
712: x_jtf_note_id => l_jtf_note_id,
713: p_last_updated_by => fnd_global.user_id,
714: p_last_update_date => sysdate,
715: p_created_by => fnd_global.user_id,
716: p_creation_date => sysdate,
717: p_last_update_login => fnd_global.login_id,
718: p_attribute1 => null,
719: p_attribute2 => null,
713: p_last_updated_by => fnd_global.user_id,
714: p_last_update_date => sysdate,
715: p_created_by => fnd_global.user_id,
716: p_creation_date => sysdate,
717: p_last_update_login => fnd_global.login_id,
718: p_attribute1 => null,
719: p_attribute2 => null,
720: p_attribute3 => null,
721: p_attribute4 => null,
1126: (
1127: p_x_mo_procedures_tbl(l_rec_idx).MEL_CDL_MO_PROCEDURE_ID,
1128: p_x_mo_procedures_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1129: sysdate,
1130: fnd_global.user_id,
1131: sysdate,
1132: fnd_global.user_id,
1133: fnd_global.login_id,
1134: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1128: p_x_mo_procedures_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1129: sysdate,
1130: fnd_global.user_id,
1131: sysdate,
1132: fnd_global.user_id,
1133: fnd_global.login_id,
1134: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1135: p_x_mo_procedures_tbl(l_rec_idx).MR_HEADER_ID,
1136: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1129: sysdate,
1130: fnd_global.user_id,
1131: sysdate,
1132: fnd_global.user_id,
1133: fnd_global.login_id,
1134: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1135: p_x_mo_procedures_tbl(l_rec_idx).MR_HEADER_ID,
1136: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1137: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE1,
1554: (
1555: p_x_ata_relations_tbl(l_rec_idx).MEL_CDL_RELATIONSHIP_ID,
1556: p_x_ata_relations_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1557: sysdate,
1558: fnd_global.user_id,
1559: sysdate,
1560: fnd_global.user_id,
1561: fnd_global.login_id,
1562: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1556: p_x_ata_relations_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1557: sysdate,
1558: fnd_global.user_id,
1559: sysdate,
1560: fnd_global.user_id,
1561: fnd_global.login_id,
1562: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1563: p_x_ata_relations_tbl(l_rec_idx).RELATED_ATA_SEQUENCE_ID,
1564: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1557: sysdate,
1558: fnd_global.user_id,
1559: sysdate,
1560: fnd_global.user_id,
1561: fnd_global.login_id,
1562: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1563: p_x_ata_relations_tbl(l_rec_idx).RELATED_ATA_SEQUENCE_ID,
1564: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1565: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE1,
1779: (
1780: ahl_mel_cdl_mo_procedures_s.nextval,
1781: 1,
1782: sysdate,
1783: fnd_global.user_id,
1784: sysdate,
1785: fnd_global.user_id,
1786: fnd_global.login_id,
1787: l_ata_seq_id,
1781: 1,
1782: sysdate,
1783: fnd_global.user_id,
1784: sysdate,
1785: fnd_global.user_id,
1786: fnd_global.login_id,
1787: l_ata_seq_id,
1788: p_new_mr_header_id,
1789: null,
1782: sysdate,
1783: fnd_global.user_id,
1784: sysdate,
1785: fnd_global.user_id,
1786: fnd_global.login_id,
1787: l_ata_seq_id,
1788: p_new_mr_header_id,
1789: null,
1790: null,