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
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,
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
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
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
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;