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_RA_NR_PROFILE_PVT dependencies on FND_GLOBAL

Line 1419: FND_GLOBAL.user_id,

1415: (
1416: p_x_nr_prof_est_tbl(i).nr_profile_det_id,
1417: p_x_nr_prof_est_tbl(i).object_version_number,
1418: SYSDATE,
1419: FND_GLOBAL.user_id,
1420: SYSDATE,
1421: FND_GLOBAL.user_id,
1422: FND_GLOBAL.login_id,
1423: p_x_nr_prof_est_tbl(i).nr_profile_header_id,

Line 1421: FND_GLOBAL.user_id,

1417: p_x_nr_prof_est_tbl(i).object_version_number,
1418: SYSDATE,
1419: FND_GLOBAL.user_id,
1420: SYSDATE,
1421: FND_GLOBAL.user_id,
1422: FND_GLOBAL.login_id,
1423: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1424: p_x_nr_prof_est_tbl(i).stage_type_code,
1425: p_x_nr_prof_est_tbl(i).inventory_item_id,

Line 1422: FND_GLOBAL.login_id,

1418: SYSDATE,
1419: FND_GLOBAL.user_id,
1420: SYSDATE,
1421: FND_GLOBAL.user_id,
1422: FND_GLOBAL.login_id,
1423: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1424: p_x_nr_prof_est_tbl(i).stage_type_code,
1425: p_x_nr_prof_est_tbl(i).inventory_item_id,
1426: p_x_nr_prof_est_tbl(i).uom_code,

Line 1465: last_updated_by = FND_GLOBAL.user_id,

1461: SET analysis_qty = p_x_nr_prof_est_tbl(i).analysis_qty,
1462: required_qty = p_x_nr_prof_est_tbl(i).required_qty,
1463: object_version_number = object_version_number + 1,
1464: last_update_date = SYSDATE,
1465: last_updated_by = FND_GLOBAL.user_id,
1466: last_update_login = FND_GLOBAL.login_id,
1467: demantra_updated_date = p_x_nr_prof_est_tbl(i).demantra_updated_date,
1468: excluded_date = NULL
1469: WHERE NR_PROFILE_DET_ID = l_nr_profile_det_id ;

Line 1466: last_update_login = FND_GLOBAL.login_id,

1462: required_qty = p_x_nr_prof_est_tbl(i).required_qty,
1463: object_version_number = object_version_number + 1,
1464: last_update_date = SYSDATE,
1465: last_updated_by = FND_GLOBAL.user_id,
1466: last_update_login = FND_GLOBAL.login_id,
1467: demantra_updated_date = p_x_nr_prof_est_tbl(i).demantra_updated_date,
1468: excluded_date = NULL
1469: WHERE NR_PROFILE_DET_ID = l_nr_profile_det_id ;
1470: -- If Update command is not executed properly throw error message

Line 1529: FND_GLOBAL.user_id,

1525: (
1526: p_x_nr_prof_est_tbl(i).nr_profile_det_id,
1527: p_x_nr_prof_est_tbl(i).object_version_number,
1528: SYSDATE,
1529: FND_GLOBAL.user_id,
1530: SYSDATE,
1531: FND_GLOBAL.user_id,
1532: FND_GLOBAL.login_id,
1533: p_x_nr_prof_est_tbl(i).nr_profile_header_id,

Line 1531: FND_GLOBAL.user_id,

1527: p_x_nr_prof_est_tbl(i).object_version_number,
1528: SYSDATE,
1529: FND_GLOBAL.user_id,
1530: SYSDATE,
1531: FND_GLOBAL.user_id,
1532: FND_GLOBAL.login_id,
1533: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1534: p_x_nr_prof_est_tbl(i).stage_type_code,
1535: p_x_nr_prof_est_tbl(i).inventory_item_id,

Line 1532: FND_GLOBAL.login_id,

1528: SYSDATE,
1529: FND_GLOBAL.user_id,
1530: SYSDATE,
1531: FND_GLOBAL.user_id,
1532: FND_GLOBAL.login_id,
1533: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1534: p_x_nr_prof_est_tbl(i).stage_type_code,
1535: p_x_nr_prof_est_tbl(i).inventory_item_id,
1536: p_x_nr_prof_est_tbl(i).uom_code,

Line 1597: FND_GLOBAL.user_id,

1593: (
1594: p_x_nr_prof_est_tbl(i).nr_profile_det_id,
1595: p_x_nr_prof_est_tbl(i).object_version_number,
1596: SYSDATE,
1597: FND_GLOBAL.user_id,
1598: SYSDATE,
1599: FND_GLOBAL.user_id,
1600: FND_GLOBAL.login_id,
1601: p_x_nr_prof_est_tbl(i).nr_profile_header_id,

Line 1599: FND_GLOBAL.user_id,

1595: p_x_nr_prof_est_tbl(i).object_version_number,
1596: SYSDATE,
1597: FND_GLOBAL.user_id,
1598: SYSDATE,
1599: FND_GLOBAL.user_id,
1600: FND_GLOBAL.login_id,
1601: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1602: p_x_nr_prof_est_tbl(i).stage_type_code,
1603: p_x_nr_prof_est_tbl(i).inventory_item_id,

Line 1600: FND_GLOBAL.login_id,

1596: SYSDATE,
1597: FND_GLOBAL.user_id,
1598: SYSDATE,
1599: FND_GLOBAL.user_id,
1600: FND_GLOBAL.login_id,
1601: p_x_nr_prof_est_tbl(i).nr_profile_header_id,
1602: p_x_nr_prof_est_tbl(i).stage_type_code,
1603: p_x_nr_prof_est_tbl(i).inventory_item_id,
1604: p_x_nr_prof_est_tbl(i).uom_code,

Line 1627: last_updated_by = FND_GLOBAL.user_id,

1623: THEN
1624: UPDATE AHL_NR_PROFILE_DETAILS
1625: SET object_version_number = object_version_number +1,
1626: last_update_date = SYSDATE,
1627: last_updated_by = FND_GLOBAL.user_id,
1628: last_update_login = FND_GLOBAL.login_id,
1629: required_qty = p_x_nr_prof_est_tbl(i).required_qty
1630: WHERE NR_PROFILE_DET_ID = p_x_nr_prof_est_tbl(i).nr_profile_det_id ;
1631:

Line 1628: last_update_login = FND_GLOBAL.login_id,

1624: UPDATE AHL_NR_PROFILE_DETAILS
1625: SET object_version_number = object_version_number +1,
1626: last_update_date = SYSDATE,
1627: last_updated_by = FND_GLOBAL.user_id,
1628: last_update_login = FND_GLOBAL.login_id,
1629: required_qty = p_x_nr_prof_est_tbl(i).required_qty
1630: WHERE NR_PROFILE_DET_ID = p_x_nr_prof_est_tbl(i).nr_profile_det_id ;
1631:
1632: IF (SQL%NOTFOUND)

Line 1665: last_updated_by = FND_GLOBAL.user_id,

1661: ELSE
1662: UPDATE AHL_NR_PROFILE_DETAILS
1663: SET object_version_number = object_version_number +1,
1664: last_update_date = SYSDATE,
1665: last_updated_by = FND_GLOBAL.user_id,
1666: last_update_login = FND_GLOBAL.login_id,
1667: excluded_date = SYSDATE
1668: WHERE nr_profile_det_id = p_x_nr_prof_est_tbl(i).nr_profile_det_id ;
1669: END IF;

Line 1666: last_update_login = FND_GLOBAL.login_id,

1662: UPDATE AHL_NR_PROFILE_DETAILS
1663: SET object_version_number = object_version_number +1,
1664: last_update_date = SYSDATE,
1665: last_updated_by = FND_GLOBAL.user_id,
1666: last_update_login = FND_GLOBAL.login_id,
1667: excluded_date = SYSDATE
1668: WHERE nr_profile_det_id = p_x_nr_prof_est_tbl(i).nr_profile_det_id ;
1669: END IF;
1670:

Line 1689: last_updated_by = FND_GLOBAL.user_id,

1685: IF(p_x_nr_prof_est_tbl(i).excluded_date IS NULL)
1686: THEN
1687: UPDATE ahl_nr_profile_headers
1688: SET last_update_date = SYSDATE,
1689: last_updated_by = FND_GLOBAL.user_id,
1690: last_update_login = FND_GLOBAL.login_id
1691: WHERE nr_profile_header_id = p_x_nr_prof_est_tbl(i).nr_profile_header_id;
1692:
1693: IF (SQL%NOTFOUND)

Line 1690: last_update_login = FND_GLOBAL.login_id

1686: THEN
1687: UPDATE ahl_nr_profile_headers
1688: SET last_update_date = SYSDATE,
1689: last_updated_by = FND_GLOBAL.user_id,
1690: last_update_login = FND_GLOBAL.login_id
1691: WHERE nr_profile_header_id = p_x_nr_prof_est_tbl(i).nr_profile_header_id;
1692:
1693: IF (SQL%NOTFOUND)
1694: THEN

Line 2028: FND_GLOBAL.user_id,

2024: (
2025: p_x_nr_profile_header_rec.nr_profile_header_id,
2026: p_x_nr_profile_header_rec.object_version_number,
2027: SYSDATE,
2028: FND_GLOBAL.user_id,
2029: SYSDATE,
2030: FND_GLOBAL.user_id,
2031: FND_GLOBAL.login_id,
2032: p_x_nr_profile_header_rec.MR_TITLE,

Line 2030: FND_GLOBAL.user_id,

2026: p_x_nr_profile_header_rec.object_version_number,
2027: SYSDATE,
2028: FND_GLOBAL.user_id,
2029: SYSDATE,
2030: FND_GLOBAL.user_id,
2031: FND_GLOBAL.login_id,
2032: p_x_nr_profile_header_rec.MR_TITLE,
2033: p_x_nr_profile_header_rec.STATUS_CODE,
2034: p_x_nr_profile_header_rec.IDENT_SEQ_THIRD,

Line 2031: FND_GLOBAL.login_id,

2027: SYSDATE,
2028: FND_GLOBAL.user_id,
2029: SYSDATE,
2030: FND_GLOBAL.user_id,
2031: FND_GLOBAL.login_id,
2032: p_x_nr_profile_header_rec.MR_TITLE,
2033: p_x_nr_profile_header_rec.STATUS_CODE,
2034: p_x_nr_profile_header_rec.IDENT_SEQ_THIRD,
2035: p_x_nr_profile_header_rec.IDENT_SEQ_FOURTH,

Line 2060: last_updated_by = FND_GLOBAL.user_id,

2056: THEN
2057: UPDATE ahl_nr_profile_headers
2058: SET object_version_number = object_version_number +1,
2059: last_update_date = SYSDATE,
2060: last_updated_by = FND_GLOBAL.user_id,
2061: last_update_login = FND_GLOBAL.login_id,
2062: status_code = p_x_nr_profile_header_rec.status_code,
2063: ident_seq_third = p_x_nr_profile_header_rec.ident_seq_third,
2064: ident_seq_fourth = p_x_nr_profile_header_rec.ident_seq_fourth,

Line 2061: last_update_login = FND_GLOBAL.login_id,

2057: UPDATE ahl_nr_profile_headers
2058: SET object_version_number = object_version_number +1,
2059: last_update_date = SYSDATE,
2060: last_updated_by = FND_GLOBAL.user_id,
2061: last_update_login = FND_GLOBAL.login_id,
2062: status_code = p_x_nr_profile_header_rec.status_code,
2063: ident_seq_third = p_x_nr_profile_header_rec.ident_seq_third,
2064: ident_seq_fourth = p_x_nr_profile_header_rec.ident_seq_fourth,
2065: security_group_id = p_x_nr_profile_header_rec.security_group_id,

Line 2144: last_updated_by = FND_GLOBAL.user_id,

2140:
2141: UPDATE AHL_NR_PROFILE_HEADERS
2142: SET object_version_number = object_version_number +1,
2143: last_update_date = SYSDATE,
2144: last_updated_by = FND_GLOBAL.user_id,
2145: last_update_login = FND_GLOBAL.login_id,
2146: status_code = 'DELETED'
2147: WHERE nr_profile_header_id = l_nr_profile_header_id;
2148:

Line 2145: last_update_login = FND_GLOBAL.login_id,

2141: UPDATE AHL_NR_PROFILE_HEADERS
2142: SET object_version_number = object_version_number +1,
2143: last_update_date = SYSDATE,
2144: last_updated_by = FND_GLOBAL.user_id,
2145: last_update_login = FND_GLOBAL.login_id,
2146: status_code = 'DELETED'
2147: WHERE nr_profile_header_id = l_nr_profile_header_id;
2148:
2149: END IF;