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.

[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on FND_GLOBAL

Line 2418: FND_GLOBAL.user_id,

2414: p_x_material_req_tbl(i).attribute13,
2415: p_x_material_req_tbl(i).attribute14,
2416: p_x_material_req_tbl(i).attribute15,
2417: SYSDATE,
2418: FND_GLOBAL.user_id,
2419: SYSDATE,
2420: FND_GLOBAL.user_id,
2421: FND_GLOBAL.login_id,
2422: p_x_material_req_tbl(i).in_service, --pdoki added for OGMA 105 issue

Line 2420: FND_GLOBAL.user_id,

2416: p_x_material_req_tbl(i).attribute15,
2417: SYSDATE,
2418: FND_GLOBAL.user_id,
2419: SYSDATE,
2420: FND_GLOBAL.user_id,
2421: FND_GLOBAL.login_id,
2422: p_x_material_req_tbl(i).in_service, --pdoki added for OGMA 105 issue
2423: --sukhwsin: Added columns values for SB Effectivity Starts
2424: p_x_material_req_tbl(i).mc_id,

Line 2421: FND_GLOBAL.login_id,

2417: SYSDATE,
2418: FND_GLOBAL.user_id,
2419: SYSDATE,
2420: FND_GLOBAL.user_id,
2421: FND_GLOBAL.login_id,
2422: p_x_material_req_tbl(i).in_service, --pdoki added for OGMA 105 issue
2423: --sukhwsin: Added columns values for SB Effectivity Starts
2424: p_x_material_req_tbl(i).mc_id,
2425: p_x_material_req_tbl(i).mc_position_key

Line 2504: last_updated_by = FND_GLOBAL.user_id,

2500: attribute13 = p_x_material_req_tbl(i).attribute13,
2501: attribute14 = p_x_material_req_tbl(i).attribute14,
2502: attribute15 = p_x_material_req_tbl(i).attribute15,
2503: last_update_date = SYSDATE,
2504: last_updated_by = FND_GLOBAL.user_id,
2505: last_update_login = FND_GLOBAL.login_id
2506: WHERE rt_oper_material_id = p_x_material_req_tbl(i).rt_oper_material_id
2507: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2508: -- If the record does not exist, then, abort API.

Line 2505: last_update_login = FND_GLOBAL.login_id

2501: attribute14 = p_x_material_req_tbl(i).attribute14,
2502: attribute15 = p_x_material_req_tbl(i).attribute15,
2503: last_update_date = SYSDATE,
2504: last_updated_by = FND_GLOBAL.user_id,
2505: last_update_login = FND_GLOBAL.login_id
2506: WHERE rt_oper_material_id = p_x_material_req_tbl(i).rt_oper_material_id
2507: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2508: -- If the record does not exist, then, abort API.
2509: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2887: FND_GLOBAL.USER_ID,

2883: p_x_route_efct_tbl(i).MC_ID,
2884: p_x_route_efct_tbl(i).MC_HEADER_ID,
2885: p_x_route_efct_tbl(i).object_version_number,
2886: SYSDATE,
2887: FND_GLOBAL.USER_ID,
2888: SYSDATE,
2889: FND_GLOBAL.USER_ID,
2890: FND_GLOBAL.LOGIN_ID,
2891: NULL,

Line 2889: FND_GLOBAL.USER_ID,

2885: p_x_route_efct_tbl(i).object_version_number,
2886: SYSDATE,
2887: FND_GLOBAL.USER_ID,
2888: SYSDATE,
2889: FND_GLOBAL.USER_ID,
2890: FND_GLOBAL.LOGIN_ID,
2891: NULL,
2892: p_x_route_efct_tbl(i).attribute_category,
2893: p_x_route_efct_tbl(i).attribute1,

Line 2890: FND_GLOBAL.LOGIN_ID,

2886: SYSDATE,
2887: FND_GLOBAL.USER_ID,
2888: SYSDATE,
2889: FND_GLOBAL.USER_ID,
2890: FND_GLOBAL.LOGIN_ID,
2891: NULL,
2892: p_x_route_efct_tbl(i).attribute_category,
2893: p_x_route_efct_tbl(i).attribute1,
2894: p_x_route_efct_tbl(i).attribute2,

Line 2924: last_updated_by = FND_GLOBAL.USER_ID,

2920: UPDATE ahl_route_effectivities
2921: SET
2922: object_version_number = object_version_number + 1,
2923: last_update_date = SYSDATE,
2924: last_updated_by = FND_GLOBAL.USER_ID,
2925: last_update_login = FND_GLOBAL.LOGIN_ID,
2926: security_group_id = p_x_route_efct_tbl(i).security_group_id,
2927: attribute_category = p_x_route_efct_tbl(i).attribute_category,
2928: attribute1 = p_x_route_efct_tbl(i).attribute1,

Line 2925: last_update_login = FND_GLOBAL.LOGIN_ID,

2921: SET
2922: object_version_number = object_version_number + 1,
2923: last_update_date = SYSDATE,
2924: last_updated_by = FND_GLOBAL.USER_ID,
2925: last_update_login = FND_GLOBAL.LOGIN_ID,
2926: security_group_id = p_x_route_efct_tbl(i).security_group_id,
2927: attribute_category = p_x_route_efct_tbl(i).attribute_category,
2928: attribute1 = p_x_route_efct_tbl(i).attribute1,
2929: attribute2 = p_x_route_efct_tbl(i).attribute2,