APPS.CSP_EXCESS_PARTS_PVT dependencies on FND_GLOBAL

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

251: Begin
252: SAVEPOINT Create_excess_parts_PUB;
253:
254: SELECT Sysdate INTO l_today FROM dual;
255: l_user_id := nvl(fnd_global.user_id, 0) ;
256: l_login_id := nvl(fnd_global.login_id, -1);
257:
258: FOR Rec IN PLANNING_NODE_REC LOOP
259: IF (Rec.NODE_TYPE <> 'REGION' AND Rec.ORGANIZATION_ID is NOT NULL) THEN

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

252: SAVEPOINT Create_excess_parts_PUB;
253:
254: SELECT Sysdate INTO l_today FROM dual;
255: l_user_id := nvl(fnd_global.user_id, 0) ;
256: l_login_id := nvl(fnd_global.login_id, -1);
257:
258: FOR Rec IN PLANNING_NODE_REC LOOP
259: IF (Rec.NODE_TYPE <> 'REGION' AND Rec.ORGANIZATION_ID is NOT NULL) THEN
260:

Line 514: p_CREATED_BY => fnd_global.user_id,

510: else
511: x_excess_line_id := null;
512: csp_excess_lists_pkg.Insert_Row(
513: px_EXCESS_LINE_ID => x_excess_line_id,
514: p_CREATED_BY => fnd_global.user_id,
515: p_CREATION_DATE => sysdate,
516: p_LAST_UPDATED_BY => fnd_global.user_id,
517: p_LAST_UPDATE_DATE => sysdate,
518: p_LAST_UPDATE_LOGIN => null,

Line 516: p_LAST_UPDATED_BY => fnd_global.user_id,

512: csp_excess_lists_pkg.Insert_Row(
513: px_EXCESS_LINE_ID => x_excess_line_id,
514: p_CREATED_BY => fnd_global.user_id,
515: p_CREATION_DATE => sysdate,
516: p_LAST_UPDATED_BY => fnd_global.user_id,
517: p_LAST_UPDATE_DATE => sysdate,
518: p_LAST_UPDATE_LOGIN => null,
519: p_ORGANIZATION_ID => p_organization_id,
520: p_SUBINVENTORY_CODE => p_subinventory_code,

Line 607: p_CREATED_BY => fnd_global.user_id,

603: else
604: x_excess_line_id := null;
605: csp_excess_lists_pkg.Insert_Row(
606: px_EXCESS_LINE_ID => x_excess_line_id,
607: p_CREATED_BY => fnd_global.user_id,
608: p_CREATION_DATE => sysdate,
609: p_LAST_UPDATED_BY => fnd_global.user_id,
610: p_LAST_UPDATE_DATE => sysdate,
611: p_LAST_UPDATE_LOGIN => null,

Line 609: p_LAST_UPDATED_BY => fnd_global.user_id,

605: csp_excess_lists_pkg.Insert_Row(
606: px_EXCESS_LINE_ID => x_excess_line_id,
607: p_CREATED_BY => fnd_global.user_id,
608: p_CREATION_DATE => sysdate,
609: p_LAST_UPDATED_BY => fnd_global.user_id,
610: p_LAST_UPDATE_DATE => sysdate,
611: p_LAST_UPDATE_LOGIN => null,
612: p_ORGANIZATION_ID => p_organization_id,
613: p_SUBINVENTORY_CODE => null,

Line 692: p_CREATED_BY => fnd_global.user_id,

688: else
689: x_excess_line_id := null;
690: csp_excess_lists_pkg.Insert_Row(
691: px_EXCESS_LINE_ID => x_excess_line_id,
692: p_CREATED_BY => fnd_global.user_id,
693: p_CREATION_DATE => sysdate,
694: p_LAST_UPDATED_BY => fnd_global.user_id,
695: p_LAST_UPDATE_DATE => sysdate,
696: p_LAST_UPDATE_LOGIN => null,

Line 694: p_LAST_UPDATED_BY => fnd_global.user_id,

690: csp_excess_lists_pkg.Insert_Row(
691: px_EXCESS_LINE_ID => x_excess_line_id,
692: p_CREATED_BY => fnd_global.user_id,
693: p_CREATION_DATE => sysdate,
694: p_LAST_UPDATED_BY => fnd_global.user_id,
695: p_LAST_UPDATE_DATE => sysdate,
696: p_LAST_UPDATE_LOGIN => null,
697: p_ORGANIZATION_ID => p_organization_id,
698: p_SUBINVENTORY_CODE => curs.secondary_inventory_name,

Line 1073: p_CREATED_BY => fnd_global.user_id,

1069: else
1070: x_excess_line_id := null;
1071: csp_excess_lists_pkg.Insert_Row(
1072: px_EXCESS_LINE_ID => x_excess_line_id,
1073: p_CREATED_BY => fnd_global.user_id,
1074: p_CREATION_DATE => sysdate,
1075: p_LAST_UPDATED_BY => fnd_global.user_id,
1076: p_LAST_UPDATE_DATE => sysdate,
1077: p_LAST_UPDATE_LOGIN => null,

Line 1075: p_LAST_UPDATED_BY => fnd_global.user_id,

1071: csp_excess_lists_pkg.Insert_Row(
1072: px_EXCESS_LINE_ID => x_excess_line_id,
1073: p_CREATED_BY => fnd_global.user_id,
1074: p_CREATION_DATE => sysdate,
1075: p_LAST_UPDATED_BY => fnd_global.user_id,
1076: p_LAST_UPDATE_DATE => sysdate,
1077: p_LAST_UPDATE_LOGIN => null,
1078: p_ORGANIZATION_ID => d.organization_id,
1079: p_SUBINVENTORY_CODE => d.subinventory_code,