APPS.CSP_NOTIFICATIONS_ORDER_PKG dependencies on FND_GLOBAL

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

94: OPEN item_attr_cur;
95: FETCH item_attr_cur INTO l_item_attr_Rec;
96: CLOSE item_attr_cur;
97:
98: l_user_id := nvl(fnd_global.user_id, 0);
99:
100: IF ((p_src_type IS NULL AND (l_item_attr_rec.mbf = 2)) OR
101: ((p_src_type <> 'WIP') AND (p_src_type <> 'REPAIR'))) THEN
102:

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

173: ,p_ORDER_BY_DATE => p_need_Date
174: ,p_SOURCE_TYPE => p_src_type
175: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
176: ,p_SOURCE_SUBINVENTORY => p_src_subinv
177: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
178: ,p_CREATION_DATE => sysdate
179: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
180: ,p_LAST_UPDATE_DATE => sysdate
181: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

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

175: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
176: ,p_SOURCE_SUBINVENTORY => p_src_subinv
177: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
178: ,p_CREATION_DATE => sysdate
179: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
180: ,p_LAST_UPDATE_DATE => sysdate
181: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
182: ,p_ATTRIBUTE_CATEGORY => null
183: ,p_ATTRIBUTE1 => null

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

177: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
178: ,p_CREATION_DATE => sysdate
179: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
180: ,p_LAST_UPDATE_DATE => sysdate
181: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
182: ,p_ATTRIBUTE_CATEGORY => null
183: ,p_ATTRIBUTE1 => null
184: ,p_ATTRIBUTE2 => null
185: ,p_ATTRIBUTE3 => null

Line 277: nvl(fnd_global.login_id, -1),

273: sysdate,
274: l_user_id,
275: l_item_attr_rec.item_Description,
276: sysdate,
277: nvl(fnd_global.login_id, -1),
278: l_employee_id,
279: 'CSP',
280: 'PURCHASE',
281: 'APPROVED',

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

309: ,p_ORDER_BY_DATE => p_need_date
310: ,p_SOURCE_TYPE => 'PO'
311: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
312: ,p_SOURCE_SUBINVENTORY => p_src_subinv
313: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
314: ,p_CREATION_DATE => sysdate
315: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
316: ,p_LAST_UPDATE_DATE => sysdate
317: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

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

311: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
312: ,p_SOURCE_SUBINVENTORY => p_src_subinv
313: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
314: ,p_CREATION_DATE => sysdate
315: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
316: ,p_LAST_UPDATE_DATE => sysdate
317: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
318: ,p_ATTRIBUTE_CATEGORY => null
319: ,p_ATTRIBUTE1 => null

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

313: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
314: ,p_CREATION_DATE => sysdate
315: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
316: ,p_LAST_UPDATE_DATE => sysdate
317: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
318: ,p_ATTRIBUTE_CATEGORY => null
319: ,p_ATTRIBUTE1 => null
320: ,p_ATTRIBUTE2 => null
321: ,p_ATTRIBUTE3 => null

Line 367: nvl(fnd_global.login_id, 0),

363: VALUES(
364: sysdate,
365: l_user_id,
366: sysdate,
367: nvl(fnd_global.login_id, 0),
368: l_wip_id,
369: 2,
370: 1,
371: p_dest_orgn_id,

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

383: ,p_ORDER_BY_DATE => p_need_date
384: ,p_SOURCE_TYPE => 'WIP'
385: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
386: ,p_SOURCE_SUBINVENTORY => p_src_subinv
387: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
388: ,p_CREATION_DATE => sysdate
389: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
390: ,p_LAST_UPDATE_DATE => sysdate
391: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

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

385: ,p_SOURCE_ORGANIZATION_ID => p_Src_orgn_id
386: ,p_SOURCE_SUBINVENTORY => p_src_subinv
387: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
388: ,p_CREATION_DATE => sysdate
389: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
390: ,p_LAST_UPDATE_DATE => sysdate
391: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
392: ,p_ATTRIBUTE_CATEGORY => null
393: ,p_ATTRIBUTE1 => null

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

387: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
388: ,p_CREATION_DATE => sysdate
389: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
390: ,p_LAST_UPDATE_DATE => sysdate
391: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
392: ,p_ATTRIBUTE_CATEGORY => null
393: ,p_ATTRIBUTE1 => null
394: ,p_ATTRIBUTE2 => null
395: ,p_ATTRIBUTE3 => null

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

469: ,p_ORDER_BY_DATE => p_need_date
470: ,p_SOURCE_TYPE => p_src_type
471: ,p_SOURCE_ORGANIZATION_ID => p_repair_supplier_id
472: ,p_SOURCE_SUBINVENTORY => null
473: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
474: ,p_CREATION_DATE => sysdate
475: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
476: ,p_LAST_UPDATE_DATE => sysdate
477: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)

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

471: ,p_SOURCE_ORGANIZATION_ID => p_repair_supplier_id
472: ,p_SOURCE_SUBINVENTORY => null
473: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
474: ,p_CREATION_DATE => sysdate
475: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
476: ,p_LAST_UPDATE_DATE => sysdate
477: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
478: ,p_ATTRIBUTE_CATEGORY => null
479: ,p_ATTRIBUTE1 => null

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

473: ,p_CREATED_BY => nvl(fnd_global.user_id, 0)
474: ,p_CREATION_DATE => sysdate
475: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 0)
476: ,p_LAST_UPDATE_DATE => sysdate
477: ,p_LAST_UPDATE_LOGIN => nvl(fnd_global.login_id, -1)
478: ,p_ATTRIBUTE_CATEGORY => null
479: ,p_ATTRIBUTE1 => null
480: ,p_ATTRIBUTE2 => null
481: ,p_ATTRIBUTE3 => null