eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on FND_GLOBAL

Line 217: fnd_global.user_id,

213: (
214: p_x_mel_cdl_header_rec.mel_cdl_header_id,
215: p_x_mel_cdl_header_rec.OBJECT_VERSION_NUMBER,
216: sysdate,
217: fnd_global.user_id,
218: sysdate,
219: fnd_global.user_id,
220: fnd_global.login_id,
221: p_x_mel_cdl_header_rec.PC_NODE_ID,

Line 219: fnd_global.user_id,

215: p_x_mel_cdl_header_rec.OBJECT_VERSION_NUMBER,
216: sysdate,
217: fnd_global.user_id,
218: sysdate,
219: fnd_global.user_id,
220: fnd_global.login_id,
221: p_x_mel_cdl_header_rec.PC_NODE_ID,
222: p_x_mel_cdl_header_rec.MEL_CDL_TYPE_CODE,
223: p_x_mel_cdl_header_rec.STATUS_CODE,

Line 220: fnd_global.login_id,

216: sysdate,
217: fnd_global.user_id,
218: sysdate,
219: fnd_global.user_id,
220: fnd_global.login_id,
221: p_x_mel_cdl_header_rec.PC_NODE_ID,
222: p_x_mel_cdl_header_rec.MEL_CDL_TYPE_CODE,
223: p_x_mel_cdl_header_rec.STATUS_CODE,
224: p_x_mel_cdl_header_rec.REVISION,

Line 532: LAST_UPDATED_BY = fnd_global.user_id,

528: -- Update record in backend
529: UPDATE ahl_mel_cdl_headers
530: SET OBJECT_VERSION_NUMBER = p_x_mel_cdl_header_rec.object_version_number,
531: LAST_UPDATE_DATE = sysdate,
532: LAST_UPDATED_BY = fnd_global.user_id,
533: LAST_UPDATE_LOGIN = fnd_global.login_id,
534: MEL_CDL_TYPE_CODE = p_x_mel_cdl_header_rec.mel_cdl_type_code,
535: STATUS_CODE = p_x_mel_cdl_header_rec.status_code,
536: REVISION = p_x_mel_cdl_header_rec.revision,

Line 533: LAST_UPDATE_LOGIN = fnd_global.login_id,

529: UPDATE ahl_mel_cdl_headers
530: SET OBJECT_VERSION_NUMBER = p_x_mel_cdl_header_rec.object_version_number,
531: LAST_UPDATE_DATE = sysdate,
532: LAST_UPDATED_BY = fnd_global.user_id,
533: LAST_UPDATE_LOGIN = fnd_global.login_id,
534: MEL_CDL_TYPE_CODE = p_x_mel_cdl_header_rec.mel_cdl_type_code,
535: STATUS_CODE = p_x_mel_cdl_header_rec.status_code,
536: REVISION = p_x_mel_cdl_header_rec.revision,
537: REVISION_DATE = p_x_mel_cdl_header_rec.revision_date,

Line 1240: fnd_global.user_id,

1236: (
1237: ahl_mel_cdl_headers_s.NEXTVAL,
1238: 1,
1239: sysdate,
1240: fnd_global.user_id,
1241: sysdate,
1242: fnd_global.user_id,
1243: fnd_global.login_id,
1244: l_mel_cdl_rec.PC_NODE_ID,

Line 1242: fnd_global.user_id,

1238: 1,
1239: sysdate,
1240: fnd_global.user_id,
1241: sysdate,
1242: fnd_global.user_id,
1243: fnd_global.login_id,
1244: l_mel_cdl_rec.PC_NODE_ID,
1245: l_mel_cdl_rec.MEL_CDL_TYPE_CODE,
1246: 'DRAFT',

Line 1243: fnd_global.login_id,

1239: sysdate,
1240: fnd_global.user_id,
1241: sysdate,
1242: fnd_global.user_id,
1243: fnd_global.login_id,
1244: l_mel_cdl_rec.PC_NODE_ID,
1245: l_mel_cdl_rec.MEL_CDL_TYPE_CODE,
1246: 'DRAFT',
1247: to_char(l_mel_cdl_rec.version_number + 1),

Line 1323: fnd_global.user_id,

1319: (
1320: ahl_mel_cdl_ata_sequences_s.nextval,
1321: 1,
1322: sysdate,
1323: fnd_global.user_id,
1324: sysdate,
1325: fnd_global.user_id,
1326: fnd_global.login_id,
1327: x_new_mel_cdl_header_id,

Line 1325: fnd_global.user_id,

1321: 1,
1322: sysdate,
1323: fnd_global.user_id,
1324: sysdate,
1325: fnd_global.user_id,
1326: fnd_global.login_id,
1327: x_new_mel_cdl_header_id,
1328: l_ata_rec.REPAIR_CATEGORY_ID,
1329: l_ata_rec.ATA_CODE,

Line 1326: fnd_global.login_id,

1322: sysdate,
1323: fnd_global.user_id,
1324: sysdate,
1325: fnd_global.user_id,
1326: fnd_global.login_id,
1327: x_new_mel_cdl_header_id,
1328: l_ata_rec.REPAIR_CATEGORY_ID,
1329: l_ata_rec.ATA_CODE,
1330: l_ata_rec.INSTALLED_NUMBER,

Line 1409: p_created_by => fnd_global.user_id,

1405: p_parent_note_id => l_note_rec.parent_note_id,
1406: p_entered_date => sysdate,
1407: p_entered_by => l_note_rec.entered_by,
1408: p_creation_date => sysdate,
1409: p_created_by => fnd_global.user_id,
1410: p_last_update_date => sysdate,
1411: p_last_updated_by => fnd_global.user_id,
1412: p_last_update_login => fnd_global.login_id,
1413: x_jtf_note_id => l_new_note_id,

Line 1411: p_last_updated_by => fnd_global.user_id,

1407: p_entered_by => l_note_rec.entered_by,
1408: p_creation_date => sysdate,
1409: p_created_by => fnd_global.user_id,
1410: p_last_update_date => sysdate,
1411: p_last_updated_by => fnd_global.user_id,
1412: p_last_update_login => fnd_global.login_id,
1413: x_jtf_note_id => l_new_note_id,
1414: x_return_status => l_return_status,
1415: x_msg_count => l_msg_count,

Line 1412: p_last_update_login => fnd_global.login_id,

1408: p_creation_date => sysdate,
1409: p_created_by => fnd_global.user_id,
1410: p_last_update_date => sysdate,
1411: p_last_updated_by => fnd_global.user_id,
1412: p_last_update_login => fnd_global.login_id,
1413: x_jtf_note_id => l_new_note_id,
1414: x_return_status => l_return_status,
1415: x_msg_count => l_msg_count,
1416: x_msg_data => l_msg_data

Line 1484: fnd_global.user_id,

1480: (
1481: ahl_mel_cdl_mo_procedures_s.nextval,
1482: 1,
1483: sysdate,
1484: fnd_global.user_id,
1485: sysdate,
1486: fnd_global.user_id,
1487: fnd_global.login_id,
1488: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,

Line 1486: fnd_global.user_id,

1482: 1,
1483: sysdate,
1484: fnd_global.user_id,
1485: sysdate,
1486: fnd_global.user_id,
1487: fnd_global.login_id,
1488: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,
1489: l_mo_proc_rec.MR_HEADER_ID,
1490: l_mo_proc_rec.ATTRIBUTE_CATEGORY,

Line 1487: fnd_global.login_id,

1483: sysdate,
1484: fnd_global.user_id,
1485: sysdate,
1486: fnd_global.user_id,
1487: fnd_global.login_id,
1488: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,
1489: l_mo_proc_rec.MR_HEADER_ID,
1490: l_mo_proc_rec.ATTRIBUTE_CATEGORY,
1491: l_mo_proc_rec.ATTRIBUTE1,

Line 1578: fnd_global.user_id,

1574: (
1575: ahl_mel_cdl_relationships_s.nextval,
1576: 1,
1577: sysdate,
1578: fnd_global.user_id,
1579: sysdate,
1580: fnd_global.user_id,
1581: fnd_global.login_id,
1582: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,

Line 1580: fnd_global.user_id,

1576: 1,
1577: sysdate,
1578: fnd_global.user_id,
1579: sysdate,
1580: fnd_global.user_id,
1581: fnd_global.login_id,
1582: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,
1583: --priyan
1584: --Fix for Bug #5468974

Line 1581: fnd_global.login_id,

1577: sysdate,
1578: fnd_global.user_id,
1579: sysdate,
1580: fnd_global.user_id,
1581: fnd_global.login_id,
1582: l_old_new_ata_tbl(l_ata_rec_idx).new_object_id,
1583: --priyan
1584: --Fix for Bug #5468974
1585: --l_ata_rel_rec.RELATED_ATA_SEQUENCE_ID,

Line 1926: last_updated_by = fnd_global.user_id,

1922: UPDATE ahl_mel_cdl_headers
1923: SET status_code = 'APPROVAL_PENDING',
1924: object_version_number = p_mel_cdl_object_version + 1,
1925: last_update_date = sysdate,
1926: last_updated_by = fnd_global.user_id,
1927: last_update_login = fnd_global.login_id
1928: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
1929:
1930: -- Start the 'MEL_CDL' approval process for this MEL/CDL

Line 1927: last_update_login = fnd_global.login_id

1923: SET status_code = 'APPROVAL_PENDING',
1924: object_version_number = p_mel_cdl_object_version + 1,
1925: last_update_date = sysdate,
1926: last_updated_by = fnd_global.user_id,
1927: last_update_login = fnd_global.login_id
1928: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
1929:
1930: -- Start the 'MEL_CDL' approval process for this MEL/CDL
1931: ahl_generic_aprv_pvt.start_wf_process

Line 1940: p_requester_userid => fnd_global.user_id,

1936: p_object_version_number => p_mel_cdl_object_version + 1,
1937: p_orig_status_code => 'DRAFT',
1938: p_new_status_code => 'COMPLETE',
1939: p_reject_status_code => 'APPROVAL_REJECTED',
1940: p_requester_userid => fnd_global.user_id,
1941: p_notes_from_requester => null,
1942: p_workflowprocess => l_process_name,
1943: p_item_type => null
1944: );

Line 1971: last_updated_by = fnd_global.user_id,

1967: UPDATE ahl_mel_cdl_headers
1968: SET status_code = 'COMPLETE',
1969: object_version_number = p_mel_cdl_object_version + 1,
1970: last_update_date = sysdate,
1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
1974:
1975: IF (l_version > 1)

Line 1972: last_update_login = fnd_global.login_id

1968: SET status_code = 'COMPLETE',
1969: object_version_number = p_mel_cdl_object_version + 1,
1970: last_update_date = sysdate,
1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
1974:
1975: IF (l_version > 1)
1976: THEN

Line 1994: last_updated_by = fnd_global.user_id,

1990: UPDATE ahl_mel_cdl_headers
1991: SET expired_date = l_prev_expired_date,
1992: object_version_number = object_version_number + 1,
1993: last_update_date = sysdate,
1994: last_updated_by = fnd_global.user_id,
1995: last_update_login = fnd_global.login_id
1996: WHERE mel_cdl_header_id = l_prev_mel_cdl_header_id;
1997: END IF;
1998: END IF;

Line 1995: last_update_login = fnd_global.login_id

1991: SET expired_date = l_prev_expired_date,
1992: object_version_number = object_version_number + 1,
1993: last_update_date = sysdate,
1994: last_updated_by = fnd_global.user_id,
1995: last_update_login = fnd_global.login_id
1996: WHERE mel_cdl_header_id = l_prev_mel_cdl_header_id;
1997: END IF;
1998: END IF;
1999: -- API body ends here