APPS.CSP_PLANNER_NOTIFICATIONS dependencies on FND_GLOBAL

Line 260: l_user_id := nvl(fnd_global.user_id, 0) ;

256:
257: -- initialize return status, get audit columns
258: --x_return_status := FND_API.G_RET_STS_SUCCESS;
259: SELECT Sysdate INTO l_today FROM dual;
260: l_user_id := nvl(fnd_global.user_id, 0) ;
261: l_login_id := nvl(fnd_global.login_id, -1);
262:
263: Cleanup_Notifications(p_organization_id);
264:

Line 261: l_login_id := nvl(fnd_global.login_id, -1);

257: -- initialize return status, get audit columns
258: --x_return_status := FND_API.G_RET_STS_SUCCESS;
259: SELECT Sysdate INTO l_today FROM dual;
260: l_user_id := nvl(fnd_global.user_id, 0) ;
261: l_login_id := nvl(fnd_global.login_id, -1);
262:
263: Cleanup_Notifications(p_organization_id);
264:
265: IF (p_notif_for_io = 2 and p_notif_for_po = 2 and

Line 2000: l_user_id := nvl(fnd_global.user_id, 0) ;

1996: l_item_Select,
1997: l_cat_select);
1998:
1999: l_order_by := ' order by 1' ;
2000: l_user_id := nvl(fnd_global.user_id, 0) ;
2001: IF (p_item_rec.employee_id IS NOT NULL) THEN
2002: OPEN employee_id_cur;
2003: FETCH employee_id_cur INTO l_employee_id;
2004: CLOSE employee_id_cur;

Line 2658: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)

2654: ,p_ORDER_BY_DATE => nvl(p_order_by_dt,sysdate)
2655: ,p_SOURCE_TYPE => p_source_type
2656: ,p_SOURCE_ORGANIZATION_ID => p_parts_rec.source_org_id
2657: ,p_SOURCE_SUBINVENTORY => p_parts_rec.source_subinv
2658: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
2659: ,p_CREATION_DATE => sysdate
2660: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
2661: ,p_LAST_UPDATE_DATE => sysdate
2662: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

Line 2660: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)

2656: ,p_SOURCE_ORGANIZATION_ID => p_parts_rec.source_org_id
2657: ,p_SOURCE_SUBINVENTORY => p_parts_rec.source_subinv
2658: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
2659: ,p_CREATION_DATE => sysdate
2660: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
2661: ,p_LAST_UPDATE_DATE => sysdate
2662: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
2663: ,p_ATTRIBUTE_CATEGORY => null
2664: ,p_ATTRIBUTE1 => null

Line 2662: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

2658: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
2659: ,p_CREATION_DATE => sysdate
2660: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
2661: ,p_LAST_UPDATE_DATE => sysdate
2662: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
2663: ,p_ATTRIBUTE_CATEGORY => null
2664: ,p_ATTRIBUTE1 => null
2665: ,p_ATTRIBUTE2 => null
2666: ,p_ATTRIBUTE3 => null