DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on FND_GLOBAL

Line 2531: FND_GLOBAL.user_id,

2527: p_x_material_req_tbl(i).attribute13,
2528: p_x_material_req_tbl(i).attribute14,
2529: p_x_material_req_tbl(i).attribute15,
2530: SYSDATE,
2531: FND_GLOBAL.user_id,
2532: SYSDATE,
2533: FND_GLOBAL.user_id,
2534: FND_GLOBAL.login_id,
2535: p_x_material_req_tbl(i).in_service --pdoki added for OGMA 105 issue

Line 2533: FND_GLOBAL.user_id,

2529: p_x_material_req_tbl(i).attribute15,
2530: SYSDATE,
2531: FND_GLOBAL.user_id,
2532: SYSDATE,
2533: FND_GLOBAL.user_id,
2534: FND_GLOBAL.login_id,
2535: p_x_material_req_tbl(i).in_service --pdoki added for OGMA 105 issue
2536: ) RETURNING rt_oper_material_id INTO l_rt_oper_material_id;
2537:

Line 2534: FND_GLOBAL.login_id,

2530: SYSDATE,
2531: FND_GLOBAL.user_id,
2532: SYSDATE,
2533: FND_GLOBAL.user_id,
2534: FND_GLOBAL.login_id,
2535: p_x_material_req_tbl(i).in_service --pdoki added for OGMA 105 issue
2536: ) RETURNING rt_oper_material_id INTO l_rt_oper_material_id;
2537:
2538: IF G_DEBUG = 'Y' THEN

Line 2610: last_updated_by = FND_GLOBAL.user_id,

2606: attribute13 = p_x_material_req_tbl(i).attribute13,
2607: attribute14 = p_x_material_req_tbl(i).attribute14,
2608: attribute15 = p_x_material_req_tbl(i).attribute15,
2609: last_update_date = SYSDATE,
2610: last_updated_by = FND_GLOBAL.user_id,
2611: last_update_login = FND_GLOBAL.login_id
2612: WHERE rt_oper_material_id = p_x_material_req_tbl(i).rt_oper_material_id
2613: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2614:

Line 2611: last_update_login = FND_GLOBAL.login_id

2607: attribute14 = p_x_material_req_tbl(i).attribute14,
2608: attribute15 = p_x_material_req_tbl(i).attribute15,
2609: last_update_date = SYSDATE,
2610: last_updated_by = FND_GLOBAL.user_id,
2611: last_update_login = FND_GLOBAL.login_id
2612: WHERE rt_oper_material_id = p_x_material_req_tbl(i).rt_oper_material_id
2613: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2614:
2615: -- If the record does not exist, then, abort API.

Line 3046: FND_GLOBAL.USER_ID,

3042: p_x_route_efct_tbl(i).MC_ID,
3043: p_x_route_efct_tbl(i).MC_HEADER_ID,
3044: p_x_route_efct_tbl(i).object_version_number,
3045: SYSDATE,
3046: FND_GLOBAL.USER_ID,
3047: SYSDATE,
3048: FND_GLOBAL.USER_ID,
3049: FND_GLOBAL.LOGIN_ID,
3050: NULL,

Line 3048: FND_GLOBAL.USER_ID,

3044: p_x_route_efct_tbl(i).object_version_number,
3045: SYSDATE,
3046: FND_GLOBAL.USER_ID,
3047: SYSDATE,
3048: FND_GLOBAL.USER_ID,
3049: FND_GLOBAL.LOGIN_ID,
3050: NULL,
3051: p_x_route_efct_tbl(i).attribute_category,
3052: p_x_route_efct_tbl(i).attribute1,

Line 3049: FND_GLOBAL.LOGIN_ID,

3045: SYSDATE,
3046: FND_GLOBAL.USER_ID,
3047: SYSDATE,
3048: FND_GLOBAL.USER_ID,
3049: FND_GLOBAL.LOGIN_ID,
3050: NULL,
3051: p_x_route_efct_tbl(i).attribute_category,
3052: p_x_route_efct_tbl(i).attribute1,
3053: p_x_route_efct_tbl(i).attribute2,

Line 3087: last_updated_by = FND_GLOBAL.USER_ID,

3083: UPDATE ahl_route_effectivities
3084: SET
3085: object_version_number = object_version_number + 1,
3086: last_update_date = SYSDATE,
3087: last_updated_by = FND_GLOBAL.USER_ID,
3088: last_update_login = FND_GLOBAL.LOGIN_ID,
3089: security_group_id = p_x_route_efct_tbl(i).security_group_id,
3090: attribute_category = p_x_route_efct_tbl(i).attribute_category,
3091: attribute1 = p_x_route_efct_tbl(i).attribute1,

Line 3088: last_update_login = FND_GLOBAL.LOGIN_ID,

3084: SET
3085: object_version_number = object_version_number + 1,
3086: last_update_date = SYSDATE,
3087: last_updated_by = FND_GLOBAL.USER_ID,
3088: last_update_login = FND_GLOBAL.LOGIN_ID,
3089: security_group_id = p_x_route_efct_tbl(i).security_group_id,
3090: attribute_category = p_x_route_efct_tbl(i).attribute_category,
3091: attribute1 = p_x_route_efct_tbl(i).attribute1,
3092: attribute2 = p_x_route_efct_tbl(i).attribute2,