DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on FND_GLOBAL

Line 999: FND_GLOBAL.EMPLOYEE_ID, --PREPARER_ID (Should be logged in user)

995: p_po_req_line_tbl(i).PO_LINE_TYPE_ID, --LINE_TYPE_ID
996: 'VENDOR', --SOURCE_TYPE_CODE
997: 'EXPENSE', --DESTINATION_TYPE_CODE
998: 'INCOMPLETE', --AUTHORIZATION_STATUS
999: FND_GLOBAL.EMPLOYEE_ID, --PREPARER_ID (Should be logged in user)
1000: p_po_req_line_tbl(i).ITEM_ID, --ITEM_ID
1001: p_po_req_line_tbl(i).ITEM_DESCRIPTION, --ITEM_DESCRIPTION
1002: p_po_req_line_tbl(i).QUANTITY, --QUANTITY
1003: l_category_seg1, --CATEGORY_SEGMENT1

Line 1010: FND_GLOBAL.EMPLOYEE_ID, --DELIVER_TO_REQUESTOR_ID

1006: l_price, --UNIT_PRICE
1007: p_po_req_line_tbl(i).NEED_BY_DATE, --NEED_BY_DATE
1008: p_po_req_line_tbl(i).SHIP_TO_ORG_ID, --DESTINATION_ORGANIZATION_ID
1009: p_po_req_line_tbl(i).SHIP_TO_LOC_ID, --DELIVER_TO_LOCATION_ID
1010: FND_GLOBAL.EMPLOYEE_ID, --DELIVER_TO_REQUESTOR_ID
1011: p_po_req_hdr_rec.BUYER_ID, --SUGGESTED_BUYER_ID
1012: p_po_req_hdr_rec.VENDOR_ID, --SUGGESTED_VENDOR_ID
1013: p_po_req_hdr_rec.VENDOR_SITE_ID, --SUGGESTED_VENDOR_SITE_ID
1014: p_po_req_hdr_rec.VENDOR_CONTACT_ID, --SUGGESTED_VENDOR_CONTACT_ID

Line 1540: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

1536: X_ATTRIBUTE14 => l_osp_dtls_rec.ATTRIBUTE14,
1537: X_ATTRIBUTE15 => l_osp_dtls_rec.ATTRIBUTE15,
1538: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
1539: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
1540: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
1541: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1544: END IF;

Line 1541: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated

1537: X_ATTRIBUTE15 => l_osp_dtls_rec.ATTRIBUTE15,
1538: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
1539: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
1540: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
1541: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1544: END IF;
1545: END Update_OSP_Order;

Line 1825: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

1821: P_ATTRIBUTE13 => l_osp_line_dtls_rec.ATTRIBUTE13,
1822: P_ATTRIBUTE14 => l_osp_line_dtls_rec.ATTRIBUTE14,
1823: P_ATTRIBUTE15 => l_osp_line_dtls_rec.ATTRIBUTE15,
1824: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
1825: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
1826: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
1827:
1828: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 1826: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated

1822: P_ATTRIBUTE14 => l_osp_line_dtls_rec.ATTRIBUTE14,
1823: P_ATTRIBUTE15 => l_osp_line_dtls_rec.ATTRIBUTE15,
1824: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
1825: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
1826: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
1827:
1828: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1830: END IF;

Line 1922: last_updated_by = fnd_global.user_id,

1918: update ahl_osp_order_lines
1919: set po_req_line_id = null,
1920: object_version_number = l_osp_line_details_rec.object_version_number + 1,
1921: last_update_date = TRUNC(sysdate),
1922: last_updated_by = fnd_global.user_id,
1923: last_update_login = fnd_global.login_id
1924: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
1925: END IF;
1926: ELSE

Line 1923: last_update_login = fnd_global.login_id

1919: set po_req_line_id = null,
1920: object_version_number = l_osp_line_details_rec.object_version_number + 1,
1921: last_update_date = TRUNC(sysdate),
1922: last_updated_by = fnd_global.user_id,
1923: last_update_login = fnd_global.login_id
1924: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
1925: END IF;
1926: ELSE
1927: -- Physically delete this line (REQ_DELETED, REQ_CANCELLED)

Line 1945: last_updated_by = fnd_global.user_id,

1941: po_request_id = null,
1942: status_code = G_OSP_ENTERED_STATUS,
1943: object_version_number = l_osp_details_rec.object_version_number + 1,
1944: last_update_date = TRUNC(sysdate),
1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: where osp_order_id = l_osp_details_rec.osp_order_id;
1948: END LOOP;
1949: CLOSE get_req_deleted_osps_csr;

Line 1946: last_update_login = fnd_global.login_id

1942: status_code = G_OSP_ENTERED_STATUS,
1943: object_version_number = l_osp_details_rec.object_version_number + 1,
1944: last_update_date = TRUNC(sysdate),
1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: where osp_order_id = l_osp_details_rec.osp_order_id;
1948: END LOOP;
1949: CLOSE get_req_deleted_osps_csr;
1950: