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.PO_CHG_REQUEST_PVT dependencies on FND_GLOBAL

Line 573: l_user_id NUMBER := fnd_global.user_id;

569: v_request_group_id number;
570: accp_flag char(1);
571: v_buyer_id number;
572: v_document_type po_change_requests.DOCUMENT_TYPE%TYPE;
573: l_user_id NUMBER := fnd_global.user_id;
574: l_login_id NUMBER := fnd_global.login_id;
575: l_api_name CONSTANT VARCHAR2(30) := 'save_request';
576: l_api_version_number CONSTANT NUMBER := 1.0;
577:

Line 574: l_login_id NUMBER := fnd_global.login_id;

570: accp_flag char(1);
571: v_buyer_id number;
572: v_document_type po_change_requests.DOCUMENT_TYPE%TYPE;
573: l_user_id NUMBER := fnd_global.user_id;
574: l_login_id NUMBER := fnd_global.login_id;
575: l_api_name CONSTANT VARCHAR2(30) := 'save_request';
576: l_api_version_number CONSTANT NUMBER := 1.0;
577:
578: BEGIN

Line 1006: v_buyer_id, fnd_global.user_id);

1002: l_po_change_requests(i).po_release_id,
1003: l_po_change_requests(i).document_revision_num,
1004: accp_flag,
1005: l_po_change_requests(i).request_reason,
1006: v_buyer_id, fnd_global.user_id);
1007:
1008: elsif (l_po_change_requests(i).request_level='LINE' AND
1009: l_po_change_requests(i).action_type='MODIFICATION') then
1010: callWf := true;

Line 1050: v_buyer_id, fnd_global.user_id);

1046: l_po_change_requests(i).po_release_id,
1047: l_po_change_requests(i).document_revision_num,
1048: 'Y',
1049: l_po_change_requests(i).request_reason,
1050: v_buyer_id, fnd_global.user_id);
1051:
1052: END IF;
1053:
1054: else

Line 1248: l_user_id := fnd_global.user_id;

1244: end if;
1245: -- Update the PO Headers/Releases even if the changes dosent require doc Check
1246: if (callDocCheck=false) then
1247: if (p_user_id is null or p_login_id is null) then
1248: l_user_id := fnd_global.user_id;
1249: l_login_id := fnd_global.login_id;
1250: else
1251: l_user_id := p_user_id;
1252: l_login_id := p_login_id;

Line 1249: l_login_id := fnd_global.login_id;

1245: -- Update the PO Headers/Releases even if the changes dosent require doc Check
1246: if (callDocCheck=false) then
1247: if (p_user_id is null or p_login_id is null) then
1248: l_user_id := fnd_global.user_id;
1249: l_login_id := fnd_global.login_id;
1250: else
1251: l_user_id := p_user_id;
1252: l_login_id := p_login_id;
1253: end if;

Line 1260: request_id = fnd_global.conc_request_id,

1256: update po_releases_all set
1257: last_update_date = sysdate,
1258: last_updated_by = l_user_id,
1259: last_update_login = l_login_id,
1260: request_id = fnd_global.conc_request_id,
1261: program_application_id = fnd_global.prog_appl_id,
1262: program_id = fnd_global.conc_program_id,
1263: program_update_date = sysdate
1264: where po_release_id = p_po_release_id;

Line 1261: program_application_id = fnd_global.prog_appl_id,

1257: last_update_date = sysdate,
1258: last_updated_by = l_user_id,
1259: last_update_login = l_login_id,
1260: request_id = fnd_global.conc_request_id,
1261: program_application_id = fnd_global.prog_appl_id,
1262: program_id = fnd_global.conc_program_id,
1263: program_update_date = sysdate
1264: where po_release_id = p_po_release_id;
1265: else

Line 1262: program_id = fnd_global.conc_program_id,

1258: last_updated_by = l_user_id,
1259: last_update_login = l_login_id,
1260: request_id = fnd_global.conc_request_id,
1261: program_application_id = fnd_global.prog_appl_id,
1262: program_id = fnd_global.conc_program_id,
1263: program_update_date = sysdate
1264: where po_release_id = p_po_release_id;
1265: else
1266: update po_headers_all set

Line 1270: request_id = fnd_global.conc_request_id,

1266: update po_headers_all set
1267: last_update_date = sysdate,
1268: last_updated_by = l_user_id,
1269: last_update_login = l_login_id,
1270: request_id = fnd_global.conc_request_id,
1271: program_application_id = fnd_global.prog_appl_id,
1272: program_id = fnd_global.conc_program_id,
1273: program_update_date = sysdate
1274: where po_header_id = p_po_header_id;

Line 1271: program_application_id = fnd_global.prog_appl_id,

1267: last_update_date = sysdate,
1268: last_updated_by = l_user_id,
1269: last_update_login = l_login_id,
1270: request_id = fnd_global.conc_request_id,
1271: program_application_id = fnd_global.prog_appl_id,
1272: program_id = fnd_global.conc_program_id,
1273: program_update_date = sysdate
1274: where po_header_id = p_po_header_id;
1275: end if;

Line 1272: program_id = fnd_global.conc_program_id,

1268: last_updated_by = l_user_id,
1269: last_update_login = l_login_id,
1270: request_id = fnd_global.conc_request_id,
1271: program_application_id = fnd_global.prog_appl_id,
1272: program_id = fnd_global.conc_program_id,
1273: program_update_date = sysdate
1274: where po_header_id = p_po_header_id;
1275: end if;
1276: end if; -- if call doc check is false

Line 1321: l_user_id := fnd_global.user_id;

1317: BEGIN
1318:
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320: if (p_user_id is null or p_login_id is null) then
1321: l_user_id := fnd_global.user_id;
1322: l_login_id := fnd_global.login_id;
1323: else
1324: l_user_id := p_user_id;
1325: l_login_id := p_login_id;

Line 1322: l_login_id := fnd_global.login_id;

1318:
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320: if (p_user_id is null or p_login_id is null) then
1321: l_user_id := fnd_global.user_id;
1322: l_login_id := fnd_global.login_id;
1323: else
1324: l_user_id := p_user_id;
1325: l_login_id := p_login_id;
1326: end if;

Line 1335: request_id = fnd_global.conc_request_id,

1331: CHANGE_REQUESTED_BY = 'SUPPLIER',
1332: last_update_date = sysdate,
1333: last_updated_by = l_user_id,
1334: last_update_login = l_login_id,
1335: request_id = fnd_global.conc_request_id,
1336: program_application_id = fnd_global.prog_appl_id,
1337: program_id = fnd_global.conc_program_id,
1338: program_update_date = sysdate
1339: where po_header_id = p_po_header_id;

Line 1336: program_application_id = fnd_global.prog_appl_id,

1332: last_update_date = sysdate,
1333: last_updated_by = l_user_id,
1334: last_update_login = l_login_id,
1335: request_id = fnd_global.conc_request_id,
1336: program_application_id = fnd_global.prog_appl_id,
1337: program_id = fnd_global.conc_program_id,
1338: program_update_date = sysdate
1339: where po_header_id = p_po_header_id;
1340:

Line 1337: program_id = fnd_global.conc_program_id,

1333: last_updated_by = l_user_id,
1334: last_update_login = l_login_id,
1335: request_id = fnd_global.conc_request_id,
1336: program_application_id = fnd_global.prog_appl_id,
1337: program_id = fnd_global.conc_program_id,
1338: program_update_date = sysdate
1339: where po_header_id = p_po_header_id;
1340:
1341: -- Update the approved_flag to R for all the shipments that has been changed

Line 1408: request_id = fnd_global.conc_request_id,

1404: revised_date = sysdate,
1405: last_update_date = sysdate,
1406: last_updated_by = l_user_id,
1407: last_update_login = l_login_id,
1408: request_id = fnd_global.conc_request_id,
1409: program_application_id = fnd_global.prog_appl_id,
1410: program_id = fnd_global.conc_program_id,
1411: program_update_date = sysdate
1412: where po_release_id = p_po_release_id;

Line 1409: program_application_id = fnd_global.prog_appl_id,

1405: last_update_date = sysdate,
1406: last_updated_by = l_user_id,
1407: last_update_login = l_login_id,
1408: request_id = fnd_global.conc_request_id,
1409: program_application_id = fnd_global.prog_appl_id,
1410: program_id = fnd_global.conc_program_id,
1411: program_update_date = sysdate
1412: where po_release_id = p_po_release_id;
1413:

Line 1410: program_id = fnd_global.conc_program_id,

1406: last_updated_by = l_user_id,
1407: last_update_login = l_login_id,
1408: request_id = fnd_global.conc_request_id,
1409: program_application_id = fnd_global.prog_appl_id,
1410: program_id = fnd_global.conc_program_id,
1411: program_update_date = sysdate
1412: where po_release_id = p_po_release_id;
1413:
1414: -- Now Update the approved_flag to R for all the shipments that has been

Line 2790: last_updated_by = fnd_global.user_id,

2786: authorization_status = 'APPROVED',
2787: CHANGE_REQUESTED_BY = null,
2788: revised_date = sysdate,
2789: last_update_date = sysdate,
2790: last_updated_by = fnd_global.user_id,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_application_id = fnd_global.prog_appl_id,
2794: program_id = fnd_global.conc_program_id,

Line 2791: last_update_login = fnd_global.login_id,

2787: CHANGE_REQUESTED_BY = null,
2788: revised_date = sysdate,
2789: last_update_date = sysdate,
2790: last_updated_by = fnd_global.user_id,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_application_id = fnd_global.prog_appl_id,
2794: program_id = fnd_global.conc_program_id,
2795: program_update_date = sysdate

Line 2792: request_id = fnd_global.conc_request_id,

2788: revised_date = sysdate,
2789: last_update_date = sysdate,
2790: last_updated_by = fnd_global.user_id,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_application_id = fnd_global.prog_appl_id,
2794: program_id = fnd_global.conc_program_id,
2795: program_update_date = sysdate
2796: where po_release_id = p_po_release_id;

Line 2793: program_application_id = fnd_global.prog_appl_id,

2789: last_update_date = sysdate,
2790: last_updated_by = fnd_global.user_id,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_application_id = fnd_global.prog_appl_id,
2794: program_id = fnd_global.conc_program_id,
2795: program_update_date = sysdate
2796: where po_release_id = p_po_release_id;
2797: -- Update all the change requests with current revision number

Line 2794: program_id = fnd_global.conc_program_id,

2790: last_updated_by = fnd_global.user_id,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_application_id = fnd_global.prog_appl_id,
2794: program_id = fnd_global.conc_program_id,
2795: program_update_date = sysdate
2796: where po_release_id = p_po_release_id;
2797: -- Update all the change requests with current revision number
2798: else

Line 2826: last_updated_by = fnd_global.user_id,

2822: update po_headers_all set
2823: authorization_status = 'APPROVED',
2824: CHANGE_REQUESTED_BY = null,
2825: last_update_date = sysdate,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id,
2828: request_id = fnd_global.conc_request_id,
2829: program_application_id = fnd_global.prog_appl_id,
2830: program_id = fnd_global.conc_program_id,

Line 2827: last_update_login = fnd_global.login_id,

2823: authorization_status = 'APPROVED',
2824: CHANGE_REQUESTED_BY = null,
2825: last_update_date = sysdate,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id,
2828: request_id = fnd_global.conc_request_id,
2829: program_application_id = fnd_global.prog_appl_id,
2830: program_id = fnd_global.conc_program_id,
2831: program_update_date = sysdate

Line 2828: request_id = fnd_global.conc_request_id,

2824: CHANGE_REQUESTED_BY = null,
2825: last_update_date = sysdate,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id,
2828: request_id = fnd_global.conc_request_id,
2829: program_application_id = fnd_global.prog_appl_id,
2830: program_id = fnd_global.conc_program_id,
2831: program_update_date = sysdate
2832: where po_header_id = p_po_header_id;

Line 2829: program_application_id = fnd_global.prog_appl_id,

2825: last_update_date = sysdate,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id,
2828: request_id = fnd_global.conc_request_id,
2829: program_application_id = fnd_global.prog_appl_id,
2830: program_id = fnd_global.conc_program_id,
2831: program_update_date = sysdate
2832: where po_header_id = p_po_header_id;
2833: -- Update all the change requests with current revision number

Line 2830: program_id = fnd_global.conc_program_id,

2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id,
2828: request_id = fnd_global.conc_request_id,
2829: program_application_id = fnd_global.prog_appl_id,
2830: program_id = fnd_global.conc_program_id,
2831: program_update_date = sysdate
2832: where po_header_id = p_po_header_id;
2833: -- Update all the change requests with current revision number
2834: else