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.

APPS.CSP_PARTS_REQUIREMENT dependencies on FND_GLOBAL

Line 242: l_user_id := fnd_global.user_id;

238: l_line_tbl := px_line_table;
239:
240: -- user and login information
241: SELECT Sysdate INTO l_today FROM dual;
242: l_user_id := fnd_global.user_id;
243: l_login_id := fnd_global.login_id;
244:
245: -- call availability API to get source organization
246: l_resource_rec.resource_type := l_header_Rec.resource_type;

Line 243: l_login_id := fnd_global.login_id;

239:
240: -- user and login information
241: SELECT Sysdate INTO l_today FROM dual;
242: l_user_id := fnd_global.user_id;
243: l_login_id := fnd_global.login_id;
244:
245: -- call availability API to get source organization
246: l_resource_rec.resource_type := l_header_Rec.resource_type;
247: l_resource_Rec.resource_id := l_header_Rec.resource_id;

Line 854: l_user_id := fnd_global.user_id;

850: l_old_line_tbl := px_line_table;
851:
852: -- user and login information
853: SELECT Sysdate INTO l_today FROM dual;
854: l_user_id := fnd_global.user_id;
855: l_login_id := fnd_global.login_id;
856:
857: -- create reservations and create line table which qualify for creating order
858:

Line 855: l_login_id := fnd_global.login_id;

851:
852: -- user and login information
853: SELECT Sysdate INTO l_today FROM dual;
854: l_user_id := fnd_global.user_id;
855: l_login_id := fnd_global.login_id;
856:
857: -- create reservations and create line table which qualify for creating order
858:
859: OPEN rs_info_cur(l_header_rec.requirement_header_id);

Line 1175: l_user_id := fnd_global.user_id;

1171: l_line_tbl := px_line_table;
1172:
1173: -- user and login information
1174: SELECT Sysdate INTO l_today FROM dual;
1175: l_user_id := fnd_global.user_id;
1176: l_login_id := fnd_global.login_id;
1177:
1178: -- create reservations and create line table which qualify for creating order
1179: K := 1;

Line 1176: l_login_id := fnd_global.login_id;

1172:
1173: -- user and login information
1174: SELECT Sysdate INTO l_today FROM dual;
1175: l_user_id := fnd_global.user_id;
1176: l_login_id := fnd_global.login_id;
1177:
1178: -- create reservations and create line table which qualify for creating order
1179: K := 1;
1180: J := 1;

Line 1518: l_user_id := fnd_global.user_id;

1514: l_line_tbl := px_line_tbl;
1515:
1516: -- user and login information
1517: SELECT Sysdate INTO l_today FROM dual;
1518: l_user_id := fnd_global.user_id;
1519:
1520: l_login_id := fnd_global.login_id;
1521:
1522: IF (l_header_rec.requirement_header_id IS NULL) THEN

Line 1520: l_login_id := fnd_global.login_id;

1516: -- user and login information
1517: SELECT Sysdate INTO l_today FROM dual;
1518: l_user_id := fnd_global.user_id;
1519:
1520: l_login_id := fnd_global.login_id;
1521:
1522: IF (l_header_rec.requirement_header_id IS NULL) THEN
1523: -- create header
1524: --get resource information

Line 2171: l_rqmt_line_tbl(I).last_updated_by := nvl(FND_GLOBAL.user_id, 1);

2167: END IF;
2168: END If;
2169: -- insert into l_rqmt_line_rec for updation.
2170: l_rqmt_line_tbl(I).requirement_line_id := l_line_tbl(I).requirement_line_id;
2171: l_rqmt_line_tbl(I).last_updated_by := nvl(FND_GLOBAL.user_id, 1);
2172: l_rqmt_line_tbl(I).last_update_date := sysdate;
2173: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2174: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2175: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;

Line 2173: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);

2169: -- insert into l_rqmt_line_rec for updation.
2170: l_rqmt_line_tbl(I).requirement_line_id := l_line_tbl(I).requirement_line_id;
2171: l_rqmt_line_tbl(I).last_updated_by := nvl(FND_GLOBAL.user_id, 1);
2172: l_rqmt_line_tbl(I).last_update_date := sysdate;
2173: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2174: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2175: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2176: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2177: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);

Line 2323: l_user_id := fnd_global.user_id;

2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: -- user and login information
2322: SELECT Sysdate INTO l_today FROM dual;
2323: l_user_id := fnd_global.user_id;
2324: l_login_id := fnd_global.login_id;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2324: l_login_id := fnd_global.login_id;

2320:
2321: -- user and login information
2322: SELECT Sysdate INTO l_today FROM dual;
2323: l_user_id := fnd_global.user_id;
2324: l_login_id := fnd_global.login_id;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2328: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',