DBA Data[Home] [Help]

APPS.AP_HOLDS_PKG dependencies on FND_GLOBAL

Line 685: FND_GLOBAL.user_id, -- 7299826

681: LAST_UPDATE_DATE, LAST_UPDATED_BY,
682: HELD_BY, HOLD_REASON, ORG_ID, HOLD_ID)
683: SELECT
684: X_invoice_id, X_hold_lookup_code, SYSDATE,
685: FND_GLOBAL.user_id, -- 7299826
686: SYSDATE,
687: FND_GLOBAL.LOGIN_ID, -- 7299826
688: SYSDATE,
689: FND_GLOBAL.user_id, -- 7299826

Line 687: FND_GLOBAL.LOGIN_ID, -- 7299826

683: SELECT
684: X_invoice_id, X_hold_lookup_code, SYSDATE,
685: FND_GLOBAL.user_id, -- 7299826
686: SYSDATE,
687: FND_GLOBAL.LOGIN_ID, -- 7299826
688: SYSDATE,
689: FND_GLOBAL.user_id, -- 7299826
690: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
691: l_hold_reason,

Line 689: FND_GLOBAL.user_id, -- 7299826

685: FND_GLOBAL.user_id, -- 7299826
686: SYSDATE,
687: FND_GLOBAL.LOGIN_ID, -- 7299826
688: SYSDATE,
689: FND_GLOBAL.user_id, -- 7299826
690: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
691: l_hold_reason,
692: ORG_ID,L_HOLD_ID
693: FROM ap_invoices

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

686: SYSDATE,
687: FND_GLOBAL.LOGIN_ID, -- 7299826
688: SYSDATE,
689: FND_GLOBAL.user_id, -- 7299826
690: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
691: l_hold_reason,
692: ORG_ID,L_HOLD_ID
693: FROM ap_invoices
694: WHERE invoice_id = X_invoice_id

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

771: release_reason = (SELECT description
772: FROM ap_lookup_codes
773: WHERE lookup_type = 'HOLD CODE'
774: AND lookup_code = X_release_lookup_code),
775: last_updated_by = FND_GLOBAL.user_id, -- 7299826
776: last_update_date = SYSDATE,
777: last_update_login = FND_GLOBAL.login_id -- 7299826
778: WHERE invoice_id = X_invoice_id
779: AND held_by = nvl(X_held_by,held_by) -- 7299826

Line 777: last_update_login = FND_GLOBAL.login_id -- 7299826

773: WHERE lookup_type = 'HOLD CODE'
774: AND lookup_code = X_release_lookup_code),
775: last_updated_by = FND_GLOBAL.user_id, -- 7299826
776: last_update_date = SYSDATE,
777: last_update_login = FND_GLOBAL.login_id -- 7299826
778: WHERE invoice_id = X_invoice_id
779: AND held_by = nvl(X_held_by,held_by) -- 7299826
780: AND release_lookup_code IS NULL
781: AND hold_lookup_code = X_hold_lookup_code;