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 2003: l_user_id := nvl(fnd_global.user_id, 0) ;

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

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

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

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

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

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

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