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 436: last_update_login = fnd_global.login_id,

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

Line 437: last_updated_by = fnd_global.user_id,

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

Line 489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;

485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;

Line 490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;

486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;

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

753: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
754: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
755: FROM po_requisition_headers_all rh
756: WHERE rh.requisition_header_id = rl.requisition_header_id),
757: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
758: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
759: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
760: WHERE rl.line_location_id in (SELECT pll.line_location_id
761: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

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

754: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
755: FROM po_requisition_headers_all rh
756: WHERE rh.requisition_header_id = rl.requisition_header_id),
757: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
758: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
759: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
760: WHERE rl.line_location_id in (SELECT pll.line_location_id
761: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
762: WHERE pll.po_header_id = X_entity_id);

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

791: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
792: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
793: FROM po_requisition_headers_all rh
794: WHERE rh.requisition_header_id = rl.requisition_header_id),
795: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
796: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
797: rl.last_update_date = sysdate -- Bug5623016 (upda ting who column)
798: WHERE rl.line_location_id in (SELECT pll.line_location_id
799: FROM po_line_locations_all pll--Bug 8777237: Looking into the base table instead of po_line_locations

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

792: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
793: FROM po_requisition_headers_all rh
794: WHERE rh.requisition_header_id = rl.requisition_header_id),
795: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
796: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
797: rl.last_update_date = sysdate -- Bug5623016 (upda ting who column)
798: WHERE rl.line_location_id in (SELECT pll.line_location_id
799: FROM po_line_locations_all pll--Bug 8777237: Looking into the base table instead of po_line_locations
800: WHERE pll.po_release_id = X_entity_id);

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

835: pll.po_line_id = X_entity_id)
836: -- Bug 15875473
837:
838: ),
839: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
840: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
841: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
842: WHERE rl.line_location_id IN (SELECT pll.line_location_id
843: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

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

836: -- Bug 15875473
837:
838: ),
839: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
840: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
841: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
842: WHERE rl.line_location_id IN (SELECT pll.line_location_id
843: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
844: WHERE pll.po_line_id = X_entity_id);

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

874: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
875: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
876: FROM po_requisition_headers_all rh
877: WHERE rh.requisition_header_id = rl.requisition_header_id),
878: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
879: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
880: rl.last_update_date = SYSDATE -- Bug5623016 (updating who column)
881: WHERE rl.line_location_id IN (SELECT pll.line_location_id
882: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

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

875: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
876: FROM po_requisition_headers_all rh
877: WHERE rh.requisition_header_id = rl.requisition_header_id),
878: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
879: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
880: rl.last_update_date = SYSDATE -- Bug5623016 (updating who column)
881: WHERE rl.line_location_id IN (SELECT pll.line_location_id
882: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
883: WHERE pll.line_location_id = X_entity_id);

Line 1294: , prl.last_updated_by = FND_GLOBAL.USER_ID

1290: ELSE
1291: 'Y'
1292: END
1293: , prl.last_update_date = SYSDATE
1294: , prl.last_updated_by = FND_GLOBAL.USER_ID
1295: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1296: WHERE
1297: PRL.Requisition_Line_ID in (
1298: SELECT SUB.Requisition_Line_ID

Line 1295: , prl.last_update_login = FND_GLOBAL.LOGIN_ID

1291: 'Y'
1292: END
1293: , prl.last_update_date = SYSDATE
1294: , prl.last_updated_by = FND_GLOBAL.USER_ID
1295: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1296: WHERE
1297: PRL.Requisition_Line_ID in (
1298: SELECT SUB.Requisition_Line_ID
1299: FROM PO_REQUISITION_LINES_ALL SUB

Line 1702: last_updated_by = FND_GLOBAL.USER_ID,

1698: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1699: UPDATE po_requisition_lines_all
1700: SET linked_po_count = linked_po_count - l_unlinked_po_count(i),
1701: last_update_date = SYSDATE,
1702: last_updated_by = FND_GLOBAL.USER_ID,
1703: last_update_login = FND_GLOBAL.LOGIN_ID
1704: WHERE requisition_line_id = l_unlinked_reqLine_ids(i);
1705:
1706: x_progress := 30;

Line 1703: last_update_login = FND_GLOBAL.LOGIN_ID

1699: UPDATE po_requisition_lines_all
1700: SET linked_po_count = linked_po_count - l_unlinked_po_count(i),
1701: last_update_date = SYSDATE,
1702: last_updated_by = FND_GLOBAL.USER_ID,
1703: last_update_login = FND_GLOBAL.LOGIN_ID
1704: WHERE requisition_line_id = l_unlinked_reqLine_ids(i);
1705:
1706: x_progress := 30;
1707: IF g_fnd_debug = 'Y' THEN

Line 2042: last_updated_by = FND_GLOBAL.USER_ID,

2038: UPDATE po_requisition_lines_all
2039: SET reqs_in_pool_flag = 'Y',
2040: linked_po_count = NULL,
2041: last_update_date = SYSDATE,
2042: last_updated_by = FND_GLOBAL.USER_ID,
2043: last_update_login = FND_GLOBAL.LOGIN_ID
2044: WHERE requisition_line_id = l_eligible_reqLine_ids(i)
2045: AND requisition_header_id = l_eligible_reqHeader_ids(i) ;
2046:

Line 2043: last_update_login = FND_GLOBAL.LOGIN_ID

2039: SET reqs_in_pool_flag = 'Y',
2040: linked_po_count = NULL,
2041: last_update_date = SYSDATE,
2042: last_updated_by = FND_GLOBAL.USER_ID,
2043: last_update_login = FND_GLOBAL.LOGIN_ID
2044: WHERE requisition_line_id = l_eligible_reqLine_ids(i)
2045: AND requisition_header_id = l_eligible_reqHeader_ids(i) ;
2046:
2047: --Call update_par_draft_line_status to update draft_line_status on PAR lines