Hi, this post I will show how to apply and release a hold on workbench in payables.
DECLARE v_rowid ROWID; v_hold_id NUMBER := NULL; BEGIN mo_global.set_policy_context('S', 81); FOR C IN ( SELECT hold, reason, hold_lookup_code FROM ap_holds_hold_name_v WHERE hold_lookup_code = 'RET. PAGAMENTO' ) LOOP AP_HOLDS_PKG.Insert_Row(x_rowid => v_rowid, x_hold_id => v_hold_id, x_invoice_id => 155074, x_line_location_id => NULL, x_hold_lookup_code => c.hold, x_last_update_date => SYSDATE, x_last_updated_by => 1139, x_held_by => 1139, x_hold_date => SYSDATE, x_hold_reason => c.reason, x_release_lookup_code => NULL, x_release_reason => NULL, x_status_flag => NULL, x_last_update_login => NULL, x_creation_date => SYSDATE, x_created_by => 1139, x_responsibility_id => NULL, x_attribute1 => NULL, x_attribute2 => NULL, x_attribute3 => NULL, x_attribute4 => NULL, x_attribute5 => NULL, x_attribute6 => NULL, x_attribute7 => NULL, x_attribute8 => NULL, x_attribute9 => NULL, x_attribute10 => NULL, x_attribute11 => NULL, x_attribute12 => NULL, x_attribute13 => NULL, x_attribute14 => NULL, x_attribute15 => NULL, x_attribute_category => NULL, x_org_id => 81, x_calling_sequence => NULL ); END LOOP; END;
Hold applied..
Now we going to release this hold.
BEGIN mo_global.set_policy_context('S', 81); FOR C IN (SELECT release_lookup_code FROM ap_holds_release_name_v WHERE release_lookup_code = 'LIB. PAGAMENTO') LOOP AP_HOLDS_PKG.release_single_hold ( x_invoice_id => 155074, x_hold_lookup_code => 'RET. PAGAMENTO', x_release_lookup_code => c.release_lookup_code, x_held_by => 1139, x_calling_sequence => NULL); END LOOP; END;
hold was released….
Thanks……
Deixe uma resposta