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_REQ_LINES_SV dependencies on FND_GLOBAL

Line 435: last_update_login = fnd_global.login_id,

431: UPDATE PO_REQUISITION_LINES
432: SET cancel_flag = 'I',
433: quantity_cancelled = NVL(X_quantity_cancelled, quantity_cancelled),
434: reqs_in_pool_flag = NULL, --
435: last_update_login = fnd_global.login_id,
436: last_updated_by = fnd_global.user_id,
437: last_update_date = sysdate
438: WHERE requisition_header_id = X_req_header_id
439: AND requisition_line_id = nvl(X_req_line_id, requisition_line_id)

Line 436: last_updated_by = fnd_global.user_id,

432: SET cancel_flag = 'I',
433: quantity_cancelled = NVL(X_quantity_cancelled, quantity_cancelled),
434: reqs_in_pool_flag = NULL, --
435: last_update_login = fnd_global.login_id,
436: last_updated_by = fnd_global.user_id,
437: last_update_date = sysdate
438: WHERE requisition_header_id = X_req_header_id
439: AND requisition_line_id = nvl(X_req_line_id, requisition_line_id)
440: AND nvl(cancel_flag, 'N') IN ('N', 'I')

Line 572: last_update_login = fnd_global.login_id,

568: contractor_status = decode(X_cancel_flag,'Y',null,contractor_status), -- Bug 3495679
569: reqs_in_pool_flag = DECODE(X_terminal_performed,
570: 1,NULL,
571: reqs_in_pool_flag), --
572: last_update_login = fnd_global.login_id,
573: last_updated_by = fnd_global.user_id,
574: last_update_date = sysdate,
575: quantity_cancelled = nvl(X_quantity_cancelled,
576: decode(X_cancel_flag, 'Y', quantity, quantity_cancelled)

Line 573: last_updated_by = fnd_global.user_id,

569: reqs_in_pool_flag = DECODE(X_terminal_performed,
570: 1,NULL,
571: reqs_in_pool_flag), --
572: last_update_login = fnd_global.login_id,
573: last_updated_by = fnd_global.user_id,
574: last_update_date = sysdate,
575: quantity_cancelled = nvl(X_quantity_cancelled,
576: decode(X_cancel_flag, 'Y', quantity, quantity_cancelled)
577: )

Line 658: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)

654:
655: UPDATE po_requisition_lines_all -- Bug 3592153
656: SET line_location_id = NULL,
657: reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
658: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
660: last_update_date = sysdate -- Bug5623016 (updating who column)
661:
662: WHERE line_location_id in (SELECT line_location_id

Line 659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

655: UPDATE po_requisition_lines_all -- Bug 3592153
656: SET line_location_id = NULL,
657: reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
658: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
660: last_update_date = sysdate -- Bug5623016 (updating who column)
661:
662: WHERE line_location_id in (SELECT line_location_id
663: FROM po_line_locations

Line 684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)

680:
681: UPDATE po_requisition_lines_all -- Bug 3592153
682: SET line_location_id = NULL,
683: reqs_in_pool_flag = 'Y', -- Bug 2781027
684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
686: last_update_date = sysdate -- Bug5623016 (updating who column)
687: WHERE line_location_id in (SELECT line_location_id
688: FROM po_line_locations

Line 685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

681: UPDATE po_requisition_lines_all -- Bug 3592153
682: SET line_location_id = NULL,
683: reqs_in_pool_flag = 'Y', -- Bug 2781027
684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
686: last_update_date = sysdate -- Bug5623016 (updating who column)
687: WHERE line_location_id in (SELECT line_location_id
688: FROM po_line_locations
689: WHERE po_release_id = X_entity_id);

Line 709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)

705:
706: UPDATE po_requisition_lines_all -- Bug 3592153
707: SET line_location_id = NULL,
708: reqs_in_pool_flag = 'Y', -- Bug 2781027
709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
711: last_update_date = sysdate -- Bug5623016 (updating who column)
712: WHERE line_location_id in (SELECT line_location_id
713: FROM po_line_locations

Line 710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

706: UPDATE po_requisition_lines_all -- Bug 3592153
707: SET line_location_id = NULL,
708: reqs_in_pool_flag = 'Y', -- Bug 2781027
709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
711: last_update_date = sysdate -- Bug5623016 (updating who column)
712: WHERE line_location_id in (SELECT line_location_id
713: FROM po_line_locations
714: WHERE po_line_id = X_entity_id);

Line 734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)

730:
731: UPDATE po_requisition_lines_all -- Bug 3592153
732: SET line_location_id = NULL,
733: reqs_in_pool_flag = 'Y', -- Bug 2781027
734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
736: last_update_date = sysdate -- Bug5623016 (updating who column)
737: WHERE line_location_id in (SELECT line_location_id
738: FROM po_line_locations

Line 735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

731: UPDATE po_requisition_lines_all -- Bug 3592153
732: SET line_location_id = NULL,
733: reqs_in_pool_flag = 'Y', -- Bug 2781027
734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
736: last_update_date = sysdate -- Bug5623016 (updating who column)
737: WHERE line_location_id in (SELECT line_location_id
738: FROM po_line_locations
739: WHERE line_location_id = X_entity_id);

Line 1138: , prl.last_updated_by = FND_GLOBAL.USER_ID

1134: ELSE
1135: 'Y'
1136: END
1137: , prl.last_update_date = SYSDATE
1138: , prl.last_updated_by = FND_GLOBAL.USER_ID
1139: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1140: WHERE
1141: PRL.Requisition_Line_ID in (
1142: SELECT SUB.Requisition_Line_ID

Line 1139: , prl.last_update_login = FND_GLOBAL.LOGIN_ID

1135: 'Y'
1136: END
1137: , prl.last_update_date = SYSDATE
1138: , prl.last_updated_by = FND_GLOBAL.USER_ID
1139: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1140: WHERE
1141: PRL.Requisition_Line_ID in (
1142: SELECT SUB.Requisition_Line_ID
1143: FROM PO_REQUISITION_LINES_ALL SUB