DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on FND_GLOBAL

Line 350: LAST_UPDATED_BY = fnd_global.user_id,

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,

Line 351: LAST_UPDATE_LOGIN = fnd_global.login_id,

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,

Line 403: p_entered_by => fnd_global.user_id,

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),

Line 404: p_last_updated_by => fnd_global.user_id,

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,

Line 406: p_last_update_login => fnd_global.login_id,

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,

Line 461: p_entered_by => fnd_global.user_id,

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,

Line 464: p_last_updated_by => fnd_global.user_id,

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,

Line 466: p_created_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,
469: p_attribute1 => null,
470: p_attribute2 => null,

Line 468: p_last_update_login => fnd_global.login_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,
471: p_attribute3 => null,
472: p_attribute4 => null,

Line 651: fnd_global.user_id,

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,

Line 653: fnd_global.user_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,

Line 654: fnd_global.login_id,

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,

Line 710: p_entered_by => fnd_global.user_id,

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,

Line 713: p_last_updated_by => fnd_global.user_id,

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,

Line 715: p_created_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,
718: p_attribute1 => null,
719: p_attribute2 => null,

Line 717: p_last_update_login => fnd_global.login_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,
720: p_attribute3 => null,
721: p_attribute4 => null,

Line 1130: fnd_global.user_id,

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,

Line 1132: fnd_global.user_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,

Line 1133: fnd_global.login_id,

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,

Line 1558: fnd_global.user_id,

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,

Line 1560: fnd_global.user_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,

Line 1561: fnd_global.login_id,

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,

Line 1783: fnd_global.user_id,

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,

Line 1785: fnd_global.user_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,

Line 1786: fnd_global.login_id,

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,