DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on FND_GLOBAL

Line 347: LAST_UPDATED_BY = fnd_global.user_id,

343: -- Update record in backend
344: UPDATE ahl_mel_cdl_ata_sequences
345: SET OBJECT_VERSION_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
346: LAST_UPDATE_DATE = sysdate,
347: LAST_UPDATED_BY = fnd_global.user_id,
348: LAST_UPDATE_LOGIN = fnd_global.login_id,
349: REPAIR_CATEGORY_ID = p_x_ata_sequences_tbl(l_rec_idx).repair_category_id,
350: INSTALLED_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).installed_number,
351: DISPATCH_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).dispatch_number,

Line 348: LAST_UPDATE_LOGIN = fnd_global.login_id,

344: UPDATE ahl_mel_cdl_ata_sequences
345: SET OBJECT_VERSION_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
346: LAST_UPDATE_DATE = sysdate,
347: LAST_UPDATED_BY = fnd_global.user_id,
348: LAST_UPDATE_LOGIN = fnd_global.login_id,
349: REPAIR_CATEGORY_ID = p_x_ata_sequences_tbl(l_rec_idx).repair_category_id,
350: INSTALLED_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).installed_number,
351: DISPATCH_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).dispatch_number,
352: ATTRIBUTE_CATEGORY = p_x_ata_sequences_tbl(l_rec_idx).attribute_category,

Line 400: p_entered_by => fnd_global.user_id,

396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,
398: x_msg_data => l_msg_data,
399: p_jtf_note_id => l_note_rec.jtf_note_id,
400: p_entered_by => fnd_global.user_id,
401: p_last_updated_by => fnd_global.user_id,
402: p_last_update_date => sysdate,
403: p_last_update_login => fnd_global.login_id,
404: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),

Line 401: p_last_updated_by => fnd_global.user_id,

397: x_msg_count => l_msg_count,
398: x_msg_data => l_msg_data,
399: p_jtf_note_id => l_note_rec.jtf_note_id,
400: p_entered_by => fnd_global.user_id,
401: p_last_updated_by => fnd_global.user_id,
402: p_last_update_date => sysdate,
403: p_last_update_login => fnd_global.login_id,
404: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
405: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,

Line 403: p_last_update_login => fnd_global.login_id,

399: p_jtf_note_id => l_note_rec.jtf_note_id,
400: p_entered_by => fnd_global.user_id,
401: p_last_updated_by => fnd_global.user_id,
402: p_last_update_date => sysdate,
403: p_last_update_login => fnd_global.login_id,
404: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
405: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
406: p_append_flag => 'N',
407: p_note_status => l_note_rec.note_status,

Line 458: p_entered_by => fnd_global.user_id,

454: p_source_object_code => 'AHL_MEL_CDL',
455: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
456: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
457: p_note_status => 'E',
458: p_entered_by => fnd_global.user_id,
459: p_entered_date => sysdate,
460: x_jtf_note_id => l_jtf_note_id,
461: p_last_updated_by => fnd_global.user_id,
462: p_last_update_date => sysdate,

Line 461: p_last_updated_by => fnd_global.user_id,

457: p_note_status => 'E',
458: p_entered_by => fnd_global.user_id,
459: p_entered_date => sysdate,
460: x_jtf_note_id => l_jtf_note_id,
461: p_last_updated_by => fnd_global.user_id,
462: p_last_update_date => sysdate,
463: p_created_by => fnd_global.user_id,
464: p_creation_date => sysdate,
465: p_last_update_login => fnd_global.login_id,

Line 463: p_created_by => fnd_global.user_id,

459: p_entered_date => sysdate,
460: x_jtf_note_id => l_jtf_note_id,
461: p_last_updated_by => fnd_global.user_id,
462: p_last_update_date => sysdate,
463: p_created_by => fnd_global.user_id,
464: p_creation_date => sysdate,
465: p_last_update_login => fnd_global.login_id,
466: p_attribute1 => null,
467: p_attribute2 => null,

Line 465: p_last_update_login => fnd_global.login_id,

461: p_last_updated_by => fnd_global.user_id,
462: p_last_update_date => sysdate,
463: p_created_by => fnd_global.user_id,
464: p_creation_date => sysdate,
465: p_last_update_login => fnd_global.login_id,
466: p_attribute1 => null,
467: p_attribute2 => null,
468: p_attribute3 => null,
469: p_attribute4 => null,

Line 645: fnd_global.user_id,

641: (
642: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_ATA_SEQUENCE_ID,
643: p_x_ata_sequences_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
644: sysdate,
645: fnd_global.user_id,
646: sysdate,
647: fnd_global.user_id,
648: fnd_global.login_id,
649: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,

Line 647: fnd_global.user_id,

643: p_x_ata_sequences_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
644: sysdate,
645: fnd_global.user_id,
646: sysdate,
647: fnd_global.user_id,
648: fnd_global.login_id,
649: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
650: p_x_ata_sequences_tbl(l_rec_idx).REPAIR_CATEGORY_ID,
651: p_x_ata_sequences_tbl(l_rec_idx).ATA_CODE,

Line 648: fnd_global.login_id,

644: sysdate,
645: fnd_global.user_id,
646: sysdate,
647: fnd_global.user_id,
648: fnd_global.login_id,
649: p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
650: p_x_ata_sequences_tbl(l_rec_idx).REPAIR_CATEGORY_ID,
651: p_x_ata_sequences_tbl(l_rec_idx).ATA_CODE,
652: p_x_ata_sequences_tbl(l_rec_idx).INSTALLED_NUMBER,

Line 704: p_entered_by => fnd_global.user_id,

700: p_source_object_code => 'AHL_MEL_CDL',
701: p_notes => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
702: p_notes_detail => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
703: p_note_status => 'E',
704: p_entered_by => fnd_global.user_id,
705: p_entered_date => sysdate,
706: x_jtf_note_id => l_jtf_note_id,
707: p_last_updated_by => fnd_global.user_id,
708: p_last_update_date => sysdate,

Line 707: p_last_updated_by => fnd_global.user_id,

703: p_note_status => 'E',
704: p_entered_by => fnd_global.user_id,
705: p_entered_date => sysdate,
706: x_jtf_note_id => l_jtf_note_id,
707: p_last_updated_by => fnd_global.user_id,
708: p_last_update_date => sysdate,
709: p_created_by => fnd_global.user_id,
710: p_creation_date => sysdate,
711: p_last_update_login => fnd_global.login_id,

Line 709: p_created_by => fnd_global.user_id,

705: p_entered_date => sysdate,
706: x_jtf_note_id => l_jtf_note_id,
707: p_last_updated_by => fnd_global.user_id,
708: p_last_update_date => sysdate,
709: p_created_by => fnd_global.user_id,
710: p_creation_date => sysdate,
711: p_last_update_login => fnd_global.login_id,
712: p_attribute1 => null,
713: p_attribute2 => null,

Line 711: p_last_update_login => fnd_global.login_id,

707: p_last_updated_by => fnd_global.user_id,
708: p_last_update_date => sysdate,
709: p_created_by => fnd_global.user_id,
710: p_creation_date => sysdate,
711: p_last_update_login => fnd_global.login_id,
712: p_attribute1 => null,
713: p_attribute2 => null,
714: p_attribute3 => null,
715: p_attribute4 => null,

Line 1124: fnd_global.user_id,

1120: (
1121: p_x_mo_procedures_tbl(l_rec_idx).MEL_CDL_MO_PROCEDURE_ID,
1122: p_x_mo_procedures_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1123: sysdate,
1124: fnd_global.user_id,
1125: sysdate,
1126: fnd_global.user_id,
1127: fnd_global.login_id,
1128: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,

Line 1126: fnd_global.user_id,

1122: p_x_mo_procedures_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1123: sysdate,
1124: fnd_global.user_id,
1125: sysdate,
1126: fnd_global.user_id,
1127: fnd_global.login_id,
1128: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1129: p_x_mo_procedures_tbl(l_rec_idx).MR_HEADER_ID,
1130: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,

Line 1127: fnd_global.login_id,

1123: sysdate,
1124: fnd_global.user_id,
1125: sysdate,
1126: fnd_global.user_id,
1127: fnd_global.login_id,
1128: p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1129: p_x_mo_procedures_tbl(l_rec_idx).MR_HEADER_ID,
1130: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1131: p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE1,

Line 1552: fnd_global.user_id,

1548: (
1549: p_x_ata_relations_tbl(l_rec_idx).MEL_CDL_RELATIONSHIP_ID,
1550: p_x_ata_relations_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1551: sysdate,
1552: fnd_global.user_id,
1553: sysdate,
1554: fnd_global.user_id,
1555: fnd_global.login_id,
1556: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,

Line 1554: fnd_global.user_id,

1550: p_x_ata_relations_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
1551: sysdate,
1552: fnd_global.user_id,
1553: sysdate,
1554: fnd_global.user_id,
1555: fnd_global.login_id,
1556: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1557: p_x_ata_relations_tbl(l_rec_idx).RELATED_ATA_SEQUENCE_ID,
1558: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,

Line 1555: fnd_global.login_id,

1551: sysdate,
1552: fnd_global.user_id,
1553: sysdate,
1554: fnd_global.user_id,
1555: fnd_global.login_id,
1556: p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
1557: p_x_ata_relations_tbl(l_rec_idx).RELATED_ATA_SEQUENCE_ID,
1558: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
1559: p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE1,

Line 1777: fnd_global.user_id,

1773: (
1774: ahl_mel_cdl_mo_procedures_s.nextval,
1775: 1,
1776: sysdate,
1777: fnd_global.user_id,
1778: sysdate,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: l_ata_seq_id,

Line 1779: fnd_global.user_id,

1775: 1,
1776: sysdate,
1777: fnd_global.user_id,
1778: sysdate,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: l_ata_seq_id,
1782: p_new_mr_header_id,
1783: null,

Line 1780: fnd_global.login_id,

1776: sysdate,
1777: fnd_global.user_id,
1778: sysdate,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: l_ata_seq_id,
1782: p_new_mr_header_id,
1783: null,
1784: null,