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 245: l_user_id := fnd_global.user_id;

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

Line 246: l_login_id := fnd_global.login_id;

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

Line 869: l_user_id := fnd_global.user_id;

865: l_old_line_tbl := px_line_table;
866:
867: -- user and login information
868: SELECT Sysdate INTO l_today FROM dual;
869: l_user_id := fnd_global.user_id;
870: l_login_id := fnd_global.login_id;
871:
872: -- create reservations and create line table which qualify for creating order
873:

Line 870: l_login_id := fnd_global.login_id;

866:
867: -- user and login information
868: SELECT Sysdate INTO l_today FROM dual;
869: l_user_id := fnd_global.user_id;
870: l_login_id := fnd_global.login_id;
871:
872: -- create reservations and create line table which qualify for creating order
873:
874: OPEN rs_info_cur(l_header_rec.requirement_header_id);

Line 1204: l_user_id := fnd_global.user_id;

1200: l_line_tbl := px_line_table;
1201:
1202: -- user and login information
1203: SELECT Sysdate INTO l_today FROM dual;
1204: l_user_id := fnd_global.user_id;
1205: l_login_id := fnd_global.login_id;
1206:
1207: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1205: l_login_id := fnd_global.login_id;

1201:
1202: -- user and login information
1203: SELECT Sysdate INTO l_today FROM dual;
1204: l_user_id := fnd_global.user_id;
1205: l_login_id := fnd_global.login_id;
1206:
1207: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1209: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',

Line 1632: l_user_id := fnd_global.user_id;

1628: l_line_tbl := px_line_tbl;
1629:
1630: -- user and login information
1631: SELECT Sysdate INTO l_today FROM dual;
1632: l_user_id := fnd_global.user_id;
1633:
1634: l_login_id := fnd_global.login_id;
1635:
1636: IF (l_header_rec.requirement_header_id IS NULL) THEN

Line 1634: l_login_id := fnd_global.login_id;

1630: -- user and login information
1631: SELECT Sysdate INTO l_today FROM dual;
1632: l_user_id := fnd_global.user_id;
1633:
1634: l_login_id := fnd_global.login_id;
1635:
1636: IF (l_header_rec.requirement_header_id IS NULL) THEN
1637: -- create header
1638: --get resource information

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

2287: END IF;
2288: END If;
2289: -- insert into l_rqmt_line_rec for updation.
2290: l_rqmt_line_tbl(I).requirement_line_id := l_line_tbl(I).requirement_line_id;
2291: l_rqmt_line_tbl(I).last_updated_by := nvl(FND_GLOBAL.user_id, 1);
2292: l_rqmt_line_tbl(I).last_update_date := sysdate;
2293: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2294: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;

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

2289: -- insert into l_rqmt_line_rec for updation.
2290: l_rqmt_line_tbl(I).requirement_line_id := l_line_tbl(I).requirement_line_id;
2291: l_rqmt_line_tbl(I).last_updated_by := nvl(FND_GLOBAL.user_id, 1);
2292: l_rqmt_line_tbl(I).last_update_date := sysdate;
2293: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2294: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);

Line 2443: l_user_id := fnd_global.user_id;

2439: x_return_status := FND_API.G_RET_STS_SUCCESS;
2440:
2441: -- user and login information
2442: SELECT Sysdate INTO l_today FROM dual;
2443: l_user_id := fnd_global.user_id;
2444: l_login_id := fnd_global.login_id;
2445:
2446: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2444: l_login_id := fnd_global.login_id;

2440:
2441: -- user and login information
2442: SELECT Sysdate INTO l_today FROM dual;
2443: l_user_id := fnd_global.user_id;
2444: l_login_id := fnd_global.login_id;
2445:
2446: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2448: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',