APPS.AP_HOLDS_PKG dependencies on FND_GLOBAL

Line 734: FND_GLOBAL.user_id, -- 7299826

730: LAST_UPDATE_DATE, LAST_UPDATED_BY,
731: HELD_BY, HOLD_REASON, ORG_ID, HOLD_ID)
732: SELECT
733: X_invoice_id, X_hold_lookup_code, SYSDATE,
734: FND_GLOBAL.user_id, -- 7299826
735: SYSDATE,
736: FND_GLOBAL.LOGIN_ID, -- 7299826
737: SYSDATE,
738: FND_GLOBAL.user_id, -- 7299826

Line 736: FND_GLOBAL.LOGIN_ID, -- 7299826

732: SELECT
733: X_invoice_id, X_hold_lookup_code, SYSDATE,
734: FND_GLOBAL.user_id, -- 7299826
735: SYSDATE,
736: FND_GLOBAL.LOGIN_ID, -- 7299826
737: SYSDATE,
738: FND_GLOBAL.user_id, -- 7299826
739: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
740: l_hold_reason,

Line 738: FND_GLOBAL.user_id, -- 7299826

734: FND_GLOBAL.user_id, -- 7299826
735: SYSDATE,
736: FND_GLOBAL.LOGIN_ID, -- 7299826
737: SYSDATE,
738: FND_GLOBAL.user_id, -- 7299826
739: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
740: l_hold_reason,
741: ORG_ID,L_HOLD_ID
742: FROM ap_invoices

Line 739: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826

735: SYSDATE,
736: FND_GLOBAL.LOGIN_ID, -- 7299826
737: SYSDATE,
738: FND_GLOBAL.user_id, -- 7299826
739: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
740: l_hold_reason,
741: ORG_ID,L_HOLD_ID
742: FROM ap_invoices
743: WHERE invoice_id = X_invoice_id

Line 856: last_updated_by = FND_GLOBAL.user_id, -- 7299826

852: release_reason = (SELECT description
853: FROM ap_lookup_codes
854: WHERE lookup_type = 'HOLD CODE'
855: AND lookup_code = X_release_lookup_code),
856: last_updated_by = FND_GLOBAL.user_id, -- 7299826
857: last_update_date = SYSDATE,
858: last_update_login = FND_GLOBAL.login_id -- 7299826
859: WHERE invoice_id = X_invoice_id
860: AND held_by = nvl(X_held_by,held_by) -- 7299826

Line 858: last_update_login = FND_GLOBAL.login_id -- 7299826

854: WHERE lookup_type = 'HOLD CODE'
855: AND lookup_code = X_release_lookup_code),
856: last_updated_by = FND_GLOBAL.user_id, -- 7299826
857: last_update_date = SYSDATE,
858: last_update_login = FND_GLOBAL.login_id -- 7299826
859: WHERE invoice_id = X_invoice_id
860: AND held_by = nvl(X_held_by,held_by) -- 7299826
861: AND release_lookup_code IS NULL
862: AND hold_lookup_code = X_hold_lookup_code;