eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on FND_GLOBAL

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

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

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

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

Line 517: p_CREATED_BY => fnd_global.user_id,

513: x_excess_line_id := null;
514: /*
515: csp_excess_lists_pkg.Insert_Row(
516: px_EXCESS_LINE_ID => x_excess_line_id,
517: p_CREATED_BY => fnd_global.user_id,
518: p_CREATION_DATE => sysdate,
519: p_LAST_UPDATED_BY => fnd_global.user_id,
520: p_LAST_UPDATE_DATE => sysdate,
521: p_LAST_UPDATE_LOGIN => null,

Line 519: p_LAST_UPDATED_BY => fnd_global.user_id,

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

Line 551: v_excess_part.CREATED_BY := fnd_global.user_id;

547: */
548:
549:
550: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
551: v_excess_part.CREATED_BY := fnd_global.user_id;
552: v_excess_part.CREATION_DATE := sysdate;
553: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
554: v_excess_part.LAST_UPDATE_DATE := sysdate;
555: v_excess_part.ORGANIZATION_ID := p_organization_id;

Line 553: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;

549:
550: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
551: v_excess_part.CREATED_BY := fnd_global.user_id;
552: v_excess_part.CREATION_DATE := sysdate;
553: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
554: v_excess_part.LAST_UPDATE_DATE := sysdate;
555: v_excess_part.ORGANIZATION_ID := p_organization_id;
556: v_excess_part.SUBINVENTORY_CODE := p_subinventory_code;
557: v_excess_part.CONDITION_CODE := 'G';

Line 639: p_CREATED_BY => fnd_global.user_id,

635: x_excess_line_id := null;
636: /*
637: csp_excess_lists_pkg.Insert_Row(
638: px_EXCESS_LINE_ID => x_excess_line_id,
639: p_CREATED_BY => fnd_global.user_id,
640: p_CREATION_DATE => sysdate,
641: p_LAST_UPDATED_BY => fnd_global.user_id,
642: p_LAST_UPDATE_DATE => sysdate,
643: p_LAST_UPDATE_LOGIN => null,

Line 641: p_LAST_UPDATED_BY => fnd_global.user_id,

637: csp_excess_lists_pkg.Insert_Row(
638: px_EXCESS_LINE_ID => x_excess_line_id,
639: p_CREATED_BY => fnd_global.user_id,
640: p_CREATION_DATE => sysdate,
641: p_LAST_UPDATED_BY => fnd_global.user_id,
642: p_LAST_UPDATE_DATE => sysdate,
643: p_LAST_UPDATE_LOGIN => null,
644: p_ORGANIZATION_ID => p_organization_id,
645: p_SUBINVENTORY_CODE => null,

Line 672: v_excess_part.CREATED_BY := fnd_global.user_id;

668: p_ATTRIBUTE15 => null);
669: */
670:
671: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
672: v_excess_part.CREATED_BY := fnd_global.user_id;
673: v_excess_part.CREATION_DATE := sysdate;
674: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
675: v_excess_part.LAST_UPDATE_DATE := sysdate;
676: v_excess_part.ORGANIZATION_ID := p_organization_id;

Line 674: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;

670:
671: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
672: v_excess_part.CREATED_BY := fnd_global.user_id;
673: v_excess_part.CREATION_DATE := sysdate;
674: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
675: v_excess_part.LAST_UPDATE_DATE := sysdate;
676: v_excess_part.ORGANIZATION_ID := p_organization_id;
677: v_excess_part.CONDITION_CODE := 'G';
678: v_excess_part.INVENTORY_ITEM_ID := coi.inventory_item_id;

Line 751: p_CREATED_BY => fnd_global.user_id,

747: x_excess_line_id := null;
748: /*
749: csp_excess_lists_pkg.Insert_Row(
750: px_EXCESS_LINE_ID => x_excess_line_id,
751: p_CREATED_BY => fnd_global.user_id,
752: p_CREATION_DATE => sysdate,
753: p_LAST_UPDATED_BY => fnd_global.user_id,
754: p_LAST_UPDATE_DATE => sysdate,
755: p_LAST_UPDATE_LOGIN => null,

Line 753: p_LAST_UPDATED_BY => fnd_global.user_id,

749: csp_excess_lists_pkg.Insert_Row(
750: px_EXCESS_LINE_ID => x_excess_line_id,
751: p_CREATED_BY => fnd_global.user_id,
752: p_CREATION_DATE => sysdate,
753: p_LAST_UPDATED_BY => fnd_global.user_id,
754: p_LAST_UPDATE_DATE => sysdate,
755: p_LAST_UPDATE_LOGIN => null,
756: p_ORGANIZATION_ID => p_organization_id,
757: p_SUBINVENTORY_CODE => curs.secondary_inventory_name,

Line 784: v_excess_part.CREATED_BY := fnd_global.user_id;

780: p_ATTRIBUTE15 => null);
781: */
782:
783: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
784: v_excess_part.CREATED_BY := fnd_global.user_id;
785: v_excess_part.CREATION_DATE := sysdate;
786: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
787: v_excess_part.LAST_UPDATE_DATE := sysdate;
788: v_excess_part.ORGANIZATION_ID := p_organization_id;

Line 786: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;

782:
783: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
784: v_excess_part.CREATED_BY := fnd_global.user_id;
785: v_excess_part.CREATION_DATE := sysdate;
786: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
787: v_excess_part.LAST_UPDATE_DATE := sysdate;
788: v_excess_part.ORGANIZATION_ID := p_organization_id;
789: v_excess_part.SUBINVENTORY_CODE := curs.secondary_inventory_name;
790: v_excess_part.CONDITION_CODE := 'G';

Line 1165: p_CREATED_BY => fnd_global.user_id,

1161: x_excess_line_id := null;
1162: /*
1163: csp_excess_lists_pkg.Insert_Row(
1164: px_EXCESS_LINE_ID => x_excess_line_id,
1165: p_CREATED_BY => fnd_global.user_id,
1166: p_CREATION_DATE => sysdate,
1167: p_LAST_UPDATED_BY => fnd_global.user_id,
1168: p_LAST_UPDATE_DATE => sysdate,
1169: p_LAST_UPDATE_LOGIN => null,

Line 1167: p_LAST_UPDATED_BY => fnd_global.user_id,

1163: csp_excess_lists_pkg.Insert_Row(
1164: px_EXCESS_LINE_ID => x_excess_line_id,
1165: p_CREATED_BY => fnd_global.user_id,
1166: p_CREATION_DATE => sysdate,
1167: p_LAST_UPDATED_BY => fnd_global.user_id,
1168: p_LAST_UPDATE_DATE => sysdate,
1169: p_LAST_UPDATE_LOGIN => null,
1170: p_ORGANIZATION_ID => d.organization_id,
1171: p_SUBINVENTORY_CODE => d.subinventory_code,

Line 1198: v_excess_part.CREATED_BY := fnd_global.user_id;

1194: p_ATTRIBUTE15 => null);
1195: */
1196:
1197: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
1198: v_excess_part.CREATED_BY := fnd_global.user_id;
1199: v_excess_part.CREATION_DATE := sysdate;
1200: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
1201: v_excess_part.LAST_UPDATE_DATE := sysdate;
1202: v_excess_part.ORGANIZATION_ID := d.organization_id;

Line 1200: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;

1196:
1197: v_excess_part := CSP_EXCESS_LISTS_PKG.G_MISS_EXCESS_REC;
1198: v_excess_part.CREATED_BY := fnd_global.user_id;
1199: v_excess_part.CREATION_DATE := sysdate;
1200: v_excess_part.LAST_UPDATED_BY := fnd_global.user_id;
1201: v_excess_part.LAST_UPDATE_DATE := sysdate;
1202: v_excess_part.ORGANIZATION_ID := d.organization_id;
1203: v_excess_part.SUBINVENTORY_CODE := d.subinventory_code;
1204: v_excess_part.CONDITION_CODE := 'B';