DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on FND_GLOBAL

Line 2344: last_updated_by = FND_GLOBAL.USER_ID,

2340: WHERE paa1.bid_number = l_bid_number
2341: AND paa1.IS_LINKED_PR_LINE_YN = 'Y'
2342: AND prl.REQUISITION_LINE_ID = paa1.ORIG_REQ_LINE_ID),
2343: last_update_date = SYSDATE,
2344: last_updated_by = FND_GLOBAL.USER_ID,
2345: last_update_login = FND_GLOBAL.LOGIN_ID
2346: WHERE prl.REQUISITION_LINE_ID IN (SELECT paa.ORIG_REQ_LINE_ID
2347: FROM pon_award_allocations paa
2348: WHERE paa.bid_number = l_bid_number

Line 2345: last_update_login = FND_GLOBAL.LOGIN_ID

2341: AND paa1.IS_LINKED_PR_LINE_YN = 'Y'
2342: AND prl.REQUISITION_LINE_ID = paa1.ORIG_REQ_LINE_ID),
2343: last_update_date = SYSDATE,
2344: last_updated_by = FND_GLOBAL.USER_ID,
2345: last_update_login = FND_GLOBAL.LOGIN_ID
2346: WHERE prl.REQUISITION_LINE_ID IN (SELECT paa.ORIG_REQ_LINE_ID
2347: FROM pon_award_allocations paa
2348: WHERE paa.bid_number = l_bid_number
2349: AND paa.IS_LINKED_PR_LINE_YN = 'Y')

Line 2376: last_updated_by = FND_GLOBAL.USER_ID,

2372:
2373: UPDATE po_requisition_lines_all
2374: SET reqs_in_pool_flag = null,
2375: last_update_date = SYSDATE,
2376: last_updated_by = FND_GLOBAL.USER_ID,
2377: last_update_login = FND_GLOBAL.LOGIN_ID
2378:
2379: WHERE requisition_header_id = l_requisition_header_id
2380: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'

Line 2377: last_update_login = FND_GLOBAL.LOGIN_ID

2373: UPDATE po_requisition_lines_all
2374: SET reqs_in_pool_flag = null,
2375: last_update_date = SYSDATE,
2376: last_updated_by = FND_GLOBAL.USER_ID,
2377: last_update_login = FND_GLOBAL.LOGIN_ID
2378:
2379: WHERE requisition_header_id = l_requisition_header_id
2380: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'
2381: AND ((requisition_line_id = l_req_line_ids_tbl(i))